meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385740' 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] => 2024-03-19 13:49:28
[post_modified_gmt] => 2024-03-19 20:49:28
[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, 1726707336
ffd_listing_title, 229 Douglass Street #A, San Francisco, CA, 94114
ffd_mls_id, 424061822
ffd_salesforce_id, a0EUd0000032ckFMAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 229 Douglass Street #A, San Francisco, CA, 94114
pba__address_pb__c, 229 Douglass Street #A, San Francisco, CA, 94114
agent_only_remarks__c, By appt only. Call Edward 415-609-1450 to set-up. Do NOT disturb the front house. Offer date TBD please call for disclosures.
appliances__c, Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Built-In Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Tile;Radiant Heat
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2008
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Edward J Lee
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-09-05T21:47:06.000+0000
days_on_market__c, 13
dom__c, 13
ffd_description_pb, Welcome to this hidden gem! Private single-family home features stunning architectural details on three levels of living. Originally built as a 2-bedroom home, the previous owners transformed the lower level into a luxurious bedroom w/office. Tucked off the street, the lower level features a formal entry w/ton of storage, a beautiful bathroom w/shower and a spacious, grand room w/high-ceiling and tons of natural light. This unique space has so much potential for use: an exquisite primary suite as the current owner utilized, fabulous entertainment, or creative space. There is a separate space for home office or gym. The main level features a skylight that brings the outside light in and welcomes you to a bedroom suite w/shower stall, and a guest bedroom w/built-in storage and third bath w/shower over tub. The top level's open floorplan features a wall of windows, bespoke cabinetry & shelving w/ built-in lighting, a bespoke contemporary chandelier designed specifically for the dining area, remote Vluxe skylights, a large flatscreen tv w/soundbar & subwoofer, w/Sonos throughout the living/dining, guest bath, and the en-suite bedroom. This unique home is nestled on a darling Eureka Valley block, in close proximity to Castro restaurants, cafes, markets, & transportation options.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Concrete;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant
interior_features__c, Skylight(s);Storage Area(s);Cathedral Ceiling;Open Beam Ceiling
ffd_lastmodifieddate, 2024-09-19T00:47:00.000+0000
pba__latitude_pb__c, 37.759779
pba__latitude_property__c, 37.759779
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2024-08-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrea
pba__listing_agent_lastname__c, Swetland
listing_agent_mls_id__c, 520168
ffd_listingagentname, Andrea F Swetland
listing_agent_number__c, 520168
listing_co_agent_mls_id__c, 810619
listing_co_agent_number__c, 1047324
listing_co_office_mls_id__c, VANG03
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 1228
listing_office_mls_id__c, VANG06
listing_office_name__c, Vanguard Properties
listing_office_number__c, 25987
pba__listingprice_pb__c, 2495000
pba__listingtype__c, Sale
pba__listing_website__c, http://229adouglass.com
pba__longitude_pb__c, -122.438811
lower_level__c, Bedroom(s),Full Bath(s),Street Entrance
mls_id__c, 424061822
main_level__c, Full Bath(s);Bedroom(s)
master_bathroom_features__c, Shower Stall(s);Tile;Radiant Heat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-09-05
open_house_end__c, 2024-09-19T18:30:00.000+0000
open_house_start__c, 2024-09-19T17:00:00.000+0000
original_price__c, 2495000
overall_days_on_market__c, -82062
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, 1408.01
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000032ckFMAQ
roof__c, Shingle
room_type__c, Office
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;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, 1772
size__c, 1772
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Douglass
subdist__c, The Castro - Dolores Heights
ffd_name, 229 Douglass Street #A, San Francisco, CA, 94114
website_property_type__c, Single Family Home
window_features__c, Greenhouse Window(s)
pba__yearbuilt_pb__c, 2008
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530837173-1.jpg