meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385979' 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-05-08 08:45:37
[post_modified_gmt] => 2024-05-08 15:45:37
[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, 1728384786
ffd_listing_title, 674 Douglass Street, San Francisco, CA, 94114
ffd_mls_id, 424063694
ffd_salesforce_id, a0EUd0000033iHNMAY
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 674 Douglass Street, San Francisco, CA, 94114
pba__address_pb__c, 674 Douglass Street, San Francisco, CA, 94114
agent_only_remarks__c, New Price!! Total of 2,318 sqft includes the unwarranted lower level. Buyer to cooperate with sellers' 1031 tax deferred exchange at no cost and liability to buyer. One seller is CA licensed R.E. broker. Fidelity Title pre-escrow FSFM-1072400701, Lynn Chan. Text agent 415-793-6859 only for disclosure package or showing appointment. www.674Douglass.com
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1912
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-09T10:48:04.000+0000
days_on_market__c, 29
dom__c, 29
ffd_description_pb, New attractive price!! Excellent opportunity for developers and or owner-users to this add-value shuffle-ready-to-renovate project with existing approved plans in the flat tree-lined block of the coveted Noe Valley neighborhood with a short stroll to the 24th Street vibrant shopping and ding corridor and the various playgrounds and dog parks are all within reach. The approved new project will be a total of 5BR, 4BA, and a Guest bath spanning three levels of living areas that can be lived like a family compound. View roof deck, outdoor patio, and large backyard. Don't miss out on this exceptional opportunity to create your ideal residence in one of the most coveted neighborhoods, which is known for its sunny weather in the city of San Francisco. Currently, this existing bright and airy 4BR vintage house needs TLC. But it also can be a lovely home for owner-occupiers who love vintage decor and enjoy the outdoors on a large sunny deck with a large backyard.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2024-10-08T10:48:15.000+0000
pba__latitude_pb__c, 37.7530236
pba__latitude_property__c, 37.7530236
listed_date__c, 2024-09-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lucy
pba__listing_agent_lastname__c, Yeung
listing_agent_mls_id__c, 113550
ffd_listingagentname, Lucy Yeung
listing_agent_number__c, 113550
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SFCITY
listing_office_name__c, SF City Properties
listing_office_number__c, 28315
pba__listingprice_pb__c, 2149000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.438915
mls_id__c, 424063694
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-09-09
open_house_end__c, 2024-10-12T16:00:00.000+0000
open_house_start__c, 2024-10-12T14:00:00.000+0000
original_price__c, 2399800
overall_days_on_market__c, -82066
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-10-07T15:00:14.000+0000
price_per_square_foot__c, 927.09
price_reduced__c, 1
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000033iHNMAY
sale_date__c, 1800-01-01
sale_price__c, 0
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, 2318
size__c, 2318
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Douglass
subdist__c, Noe Valley
ffd_name, 674 Douglass Street, San Francisco, CA, 94114
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530838660-1.jpg