meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='239614' 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, 688 Douglass 690 Street, San Francisco, CA, 94114
ffd_mls_id, 422691493
ffd_salesforce_id, a0E8W00000ZKIfIUAX
num_of_fireplaces__c, 0
num_of_rooms__c, 11
of_units__c, 0
address2__c, 688 Douglass 690 Street, San Francisco, CA, 94114
pba__address_pb__c, 688 Douglass 690 Street, San Francisco, CA, 94114
agent_only_remarks__c, Please call or text Colleen Cotter(415.706.1781)or Zoe Frankel (415.235.9422)for showing requests. Property is consists of 2 houses on 1 lot, full address being 688-690 Douglass Street. The main residence (688)is classified as single family dwelling per 3R Building Report. Square footage includes total for both main residence & guest house. Disclosures linked HERE: https://app.disclosures.io/link/688690-Douglass-St-7905y5m5
appliances__c, Dishwasher;Built-In Gas Range;Tankless Water Heater;Double Oven;Built-In Refrigerator
architectural_style__c, Edwardian;Victorian
bath_features__c, Tub w/Shower Over;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-11-28
ffd_createddate, 2022-09-23T01:47:08.000+0000
days_on_market__c, 300
dom__c, 69
ffd_description_pb, Rare opportunity to own a quintessential Noe Valley property! Featuring a main residence with 4 bedrooms and 2.5 baths as well as a 1 bedroom freestanding guest cottage in the back of the property. The main residence features hardwood floors throughout, met with an abundance of natural light from its east-facing windows & soaring skylights. Enjoy VIEWS of San Francisco Bay and hills of Noe Valley from the top floor where all 4 bedrooms are situated. The entertainment-ready ground floor hosts a gourmet kitchen and open living space with designated areas for a traditional dining room, family room, and living room. The Chef's kitchen features recessed lighting, industrial sized fridge/freezer, Dual Electrolux Icon ovens, and a Viking Island Cooktop with a wok ring burner. Enjoying the sought-after Noe sunshine comes easy in this home two sun-splashed outdoor patios in the front & back. The free-standing guest cottage offers a full kitchen & living space, perfect for hosting guests!
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Balcony;Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T17:48:50.000+0000
pba__latitude_pb__c, 37.752805
pba__latitude_property__c, 37.752805
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-09-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Colleen
pba__listing_agent_lastname__c, Cotter
listing_agent_mls_id__c, 805388
ffd_listingagentname, Colleen M Cotter
listing_agent_number__c, 166015298
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG06
listing_office_name__c, Vanguard Properties
listing_office_number__c, 25987
pba__listingprice_pb__c, 3450000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.noevalleydouglass.com/
pba__longitude_pb__c, -122.438922
mls_id__c, 422691493
main_level__c, Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-22
original_price__c, 3795000
overall_days_on_market__c, -81348
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio;Front Porch
pba__pendingdate__c, 2022-11-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1071.31
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZKIfIUAX
sale_date__c, 2022-12-20
sale_price__c, 3350000
security_features__c, Security Gate
selling_agent_mls_id__c, 807575
selling_agent_number__c, 1021892
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 3127
size__c, 3127
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Douglass
subdist__c, Noe Valley
ffd_name, 688 Douglass 690 Street, San Francisco, CA, 94114
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530532647-1.jpg
_wp_old_slug, 688-douglass-street-san-francisco-ca-94114