meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330033' 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-03-07 13:06:57
[post_modified_gmt] => 2024-03-07 21:06:57
[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
(
)
)
ffd_listing_title, 3969 Cesar Chavez 3971 Street, San Francisco, CA, 94131
ffd_mls_id, 423720180
ffd_salesforce_id, a0E8W00000bFRJoUAO
num_of_rooms__c, 10
of_units__c, 2
address2__c, 3969 Cesar Chavez 3971 Street, San Francisco, CA, 94131
pba__address_pb__c, 3969 Cesar Chavez 3971 Street, San Francisco, CA, 94131
agent_only_remarks__c, Contact [email protected] to show. Seller occupied lower unit, vacant upper unit. Delivered vacant. Please allow 24 hour notice to show, but easy to show. Large area/rooms downstairs with possible development potential, good ceiling height + windows (buyer to verify).
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1929
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Derek Chin
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-10T11:52:03.000+0000
days_on_market__c, 131
dom__c, 12
ffd_description_pb, We're pleased to present a large, generational property which has been in the same family for many years before the street name was changed from Army Street. In a prime Noe Valley location close to 24th Street shops and restaurants, parks, playgrounds, transportation and freeway access, this 1929 building consists of 2 expansive units plus a bonus space on the ground floor. Lower unit a 2 BR, Upper a 3; each with a split bathroom, gas kitchen, formal living and dining rooms. Many period details of its era of construction are intact. There are 2 parking spots in the garage with plentiful room for storage and hobbies. One of two widest lots on the block! Ownership flexibility: Live in the upper unit & rent out the lower, buy with a partner for potential condo conversion, or perhaps rent out the entire building and cash flow? This is a prime piece of Old San Francisco real estate you'll not want to miss out on.
district__c, SF District 5
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-04-19T22:50:38.000+0000
pba__latitude_pb__c, 37.747362
pba__latitude_property__c, 37.747362
laundry_features__c, In Each Unit
listed_date__c, 2023-01-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Natalie
pba__listing_agent_lastname__c, Rome
listing_agent_mls_id__c, 803584
ffd_listingagentname, Natalie Rome
listing_agent_number__c, 803584
listing_co_agent_mls_id__c, 189082
listing_co_agent_number__c, 189082
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 2195000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.3969-3971cesarchavez.com/mls
pba__longitude_pb__c, -122.4285
mls_id__c, 423720180
parkingspaces__c, 2
on_market_date__c, 2023-03-10
original_price__c, 2195000
overall_days_on_market__c, -81517
parking_features__c, Garage,Tandem Garage
pba__pendingdate__c, 2023-03-22
price_per_square_foot__c, 605.36
pba__propertytype__c, Duplex
ListingId, a0E8W00000bFRJoUAO
sale_date__c, 2023-04-19
sale_price__c, 2350000
selling_agent_mls_id__c, 803139
selling_agent_number__c, 803139
selling_co_agent_mls_id__c, 811258
selling_co_agent_number__c, 1050698
selling_co_office_mls_id__c, STHB
selling_co_office_name__c, Sotheby's International Realty
selling_co_office_number__c, 2050
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 3882
size__c, 3882
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Cesar Chavez
subdist__c, Noe Valley
ffd_name, 3969 Cesar Chavez 3971 Street, San Francisco, CA, 94131
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1929
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530585549-1.jpg