meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='345660' posts_per_page=4 post_type=property
int(1)
Array
(
[ID] => 15603
[post_author] => 4
[post_date] => 2018-11-02 02:29:53
[post_date_gmt] => 2018-11-02 02:29:53
[post_content] => Liberty Hill. The sweet, sweet homes surrounding Dolores Park. Gaze at the downtown skyline after a walk through Dolores Park with the pooch. Not quite Noe Valley or the Castro and rising above Mission Dolores, Dolores Heights is home to some of central San Francisco's most expensive real estate.
[post_title] => Dolores Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dolores-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-31 09:49:52
[post_modified_gmt] => 2023-10-31 16:49:52
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15603
[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, 1700136897
ffd_listing_title, 429 Douglass Street, San Francisco, CA, 94114
ffd_mls_id, 423915431
ffd_salesforce_id, a0EUd00000083bzMAA
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 429 Douglass Street, San Francisco, CA, 94114
pba__address_pb__c, 429 Douglass Street, San Francisco, CA, 94114
agent_only_remarks__c, Owner occupied, showings by appointment only with notice. Contact Frank Nolan, 415.377.3726, [email protected]. www.429Douglass.com
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Range;Wine Refrigerator;Built-In Refrigerator
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tub;Tile;Window
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-11-16T01:47:04.000+0000
days_on_market__c, 1
dom__c, 1
ffd_description_pb, Perched on a quiet ridge in Eureka Valley, this architecturally stunning Bauhaus Modern home has been renovated and expanded and captures spectacular San Francisco views from all four levels. The home boasts 4 bedrooms, 4 full bathrooms, an office area, and an additional family room with an adjacent formal dining area. The professional kitchen boasts an abundance of counter space along with a large center island and a breakfast area. The top level of the home is encompassed by two terraces and the primary suite, complete with a spa-like bathroom with a soaking tub and picturesque views. Impeccable indoor-outdoor flow intertwines the lower two levels to the lush landscaped garden with multiple seating areas and a grass area at the bottom with a built in slide. Nestled just one block to Noe Valley, 429 Douglass St is located on a quiet dead-end street with easy access to shops, parks, cafes, and restaurants. Additional features include hardwood floors, integrated sound, 1 car garage, and courtyard front entry.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Gas Starter
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-11-16T11:48:00.000+0000
pba__latitude_pb__c, 37.7567701
pba__latitude_property__c, 37.7567701
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-11-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Frank
pba__listing_agent_lastname__c, Nolan
listing_agent_mls_id__c, 803037
ffd_listingagentname, Frank A Nolan
listing_agent_number__c, 803037
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 5785000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.429douglass.com/
pba__longitude_pb__c, -122.4387808
lower_level__c, Family Room
mls_id__c, 423915431
main_level__c, Full Bath(s);Kitchen;Garage;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile;Soaking Tub;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-11-15
open_house_end__c, 2023-11-21T14:00:00.000+0000
open_house_start__c, 2023-11-21T12:00:00.000+0000
original_price__c, 5785000
overall_days_on_market__c, -81767
parking_access__c, Independent
parking_features__c, Garage Facing Front
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
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, 0
pba__propertytype__c, Single Family Residence
ListingId, a0EUd00000083bzMAA
room_type__c, Storage;Family Room
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Douglass
subdist__c, The Castro - Dolores Heights
ffd_name, 429 Douglass Street, San Francisco, CA, 94114
view__c, City;Panoramic;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Twin Peaks;Sutro Tower;Mt Diablo
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530703273-1.jpg