meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='420644' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15733
[post_author] => 4
[post_date] => 2018-11-02 19:54:58
[post_date_gmt] => 2018-11-02 19:54:58
[post_content] => Sunny, sedate, central, strollers, and tech-centric. Once upon a time home searches began in Pacific Heights and settled for Noe Valley. Now home searches begin here and settle for Pacific Heights.
Connect with a Jackson Fuller Real Estate agent today and explore the diverse range of homes for sale in Noe Valley.
[post_title] => Noe Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => noe-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-10-31 12:21:05
[post_modified_gmt] => 2024-10-31 19:21:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15733
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1733277298
ffd_listing_title, 4390 Cesar Chavez Street, San Francisco, CA, 94131
ffd_mls_id, 424077729
ffd_salesforce_id, a0EUd000003XxsPMAS
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 4390 Cesar Chavez Street, San Francisco, CA, 94131
pba__address_pb__c, 4390 Cesar Chavez Street, San Francisco, CA, 94131
agent_only_remarks__c, Transparently Priced. Escrow is opened at WFG Title Title #24-205504 with Mary Ann Bunnell [email protected]. More info and photos: https://www.4390cesarchavez.com/mls/163525916. DO NOT USE SHOWING TIME. Call for disclosures package. Multiple measurements.2,190 includes the bonus room and tunnel entry area. Buyer should investigate and satisfy themselves with sq ft. The primary bedroom, bath and lower staircase were added with permits. Credits to buyers considered. Supra will be installed on Wednesday afternoon. Property is virtually staged.
appliances__c, Dishwasher;Microwave
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1938
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-11-06T19:47:09.000+0000
days_on_market__c, 27
dom__c, 27
ffd_description_pb, Got Views? Spectacular, unobstructed and iconic views of Downtown, the Bay, Angel Island, Twin Peaks and beyond await from this 3Bd/2Ba Noe Valley home located just blocks from bustling 24th St. Hardwood and parquet floors and enormous picture windows showcase breathtaking views from the living room, dining room and remodeled kitchen with ss appliances, shaker cabinets and granite counters. Intricate crown molding and a corner fireplace add elegance and character. Completing the upper level are 2 bedrooms and a vintage bath showcasing timeless charm. The mid level offers a private primary retreat with large ensuite bath, walk -in closet, reading nook with built-in bookcase, an expansive deck and more breathtaking views. A grand staircase takes you to a multipurpose bonus room with access to a sweet, landscaped garden providing a private oasis. This level also offers a large storage area perfect for wine storage and more. 1 car garage with laundry area. Don't miss the opportunity to call this remarkable view home your own!Property is virtually staged.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Wood
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Carpet;Cork;Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas;Natural Gas
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2024-12-04T01:47:03.000+0000
pba__latitude_pb__c, 37.7472019
pba__latitude_property__c, 37.7472019
laundry_features__c, In Garage;Hookups Only;Gas Hook-Up
listed_date__c, 2024-10-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lynn
pba__listing_agent_lastname__c, Finnegan
listing_agent_mls_id__c, 804109
ffd_listingagentname, Lynn Finnegan
listing_agent_number__c, 166013562
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 2300000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.4390cesarchavez.com/mls/163525916
pba__longitude_pb__c, -122.437883
lower_level__c, Family Room
mls_id__c, 424077729
main_level__c, Full Bath(s);Bedroom(s);Garage;Street Entrance;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-11-06
open_house_end__c, 2024-12-03T16:00:00.000+0000
open_house_start__c, 2024-12-03T09:00:00.000+0000
original_price__c, 2300000
overall_days_on_market__c, -82124
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1050.23
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000003XxsPMAS
roof__c, Bitumen;Composition
room_type__c, Storage;Bonus Room;Kitchen;Wine Cellar;Dining Room;Wine Storage Area;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 2190
size__c, 2190
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Cesar Chavez
subdist__c, Noe Valley
ffd_name, 4390 Cesar Chavez Street, San Francisco, CA, 94131
view__c, City;Downtown;San Francisco;Twin Peaks;Mountains;Sutro Tower
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1938
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530892422-1.jpg