meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216521' 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
(
)
)
ffd_listing_title, 374 Douglass Street, San Francisco, CA, 94114
ffd_mls_id, 512160
ffd_salesforce_id, a0E1I00000TvV5eUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 374 Douglass Street, San Francisco, CA, 94114
pba__address_pb__c, 374 Douglass Street, San Francisco, CA, 94114
agent_only_remarks__c, Stunning home with magical outdoor spaces. Sellers spent $700,000+ on finishes since last sale. 2016-2018 Designer Showcase featured, Ian Stallings Design reimagined the home. No garage but street S Permit parking is VERY easy here! | www.LuxeDouglassTreehouse.com | Offers to be reviewed as they come. Full disclosure package available. Only use SFAR Purchase Contract. On the purchase contract, stipulate that buyer's deposit will be in escrow within one (1)business day of acceptance. Escrow has been opened at First American Title with Cathy Bryant. | Please email BOTH [email protected] & [email protected] for COVID-compliant showings. Buyer's agent must provide a signed PEAD-V before viewing home. |
appliances__c, Dishwasher;Disposal;ENERGY STAR Qualified Appliances;Ice Maker
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Shower Stall(s);Marble;Dual Flush Toilet;Radiant Heat
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1910
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Room Air
ffd_createddate, 2021-01-14T01:45:23.000+0000
days_on_market__c, 917
dom__c, 15
ffd_description_pb, Imagine coming home to a magical vacation-like treehouse, perfectly nestled in manicured gardens, overlooking the iconic San Francisco downtown skyline. Internationally known designer Ian Stalling reimagined this custom-built masterpiece to take advantage of its unique setting. The grand living room features vaulted, coffered ceilings and a large picture window with unobstructed views. A professional-grade kitchen features custom cabinetry and an integrated Bosch & Thermador appliance suite. The entry foyer showcases a grand staircase under a trio of Mooi lighting pendants lead you to the master suite and an expansive, 525 square-foot observation deck with a gas fire pit. Truly a spa-like experience, all of the bathrooms boast large walk-in showers, radiant heat flooring and designer light fixtures. A lower-level junior suite makes this a perfect offering for a multi-generational family or the savvy homeowner looking for income potential. | 3D tour & more at LuxeDouglassTreehouse.com
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Marble;Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:42:22.000+0000
pba__latitude_pb__c, 37.757468
pba__latitude_property__c, 37.757468
laundry_features__c, Laundry Closet
listed_date__c, 2020-12-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jonathan
pba__listing_agent_lastname__c, Deason
listing_agent_mls_id__c, 807058
ffd_listingagentname, Jonathan B Deason
listing_agent_number__c, 166018127
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=yYuNxEDTK4U&brand=0
pba__longitude_pb__c, -122.439263
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s),Kitchen
mls_id__c, 512160
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-01-13
original_price__c, 3195000
overall_days_on_market__c, 113
parking_features__c, See Remarks
pba__pendingdate__c, 2021-01-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1466.35
pba__propertytype__c, Single Family Residence
id, a0E1I00000TvV5eUAF
room_type__c, Storage;In Law Apartment
sale_date__c, 2021-02-25
sale_price__c, 3050000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 803339
selling_agent_number__c, 166012442
selling_co_agent_mls_id__c, 800212
selling_co_agent_number__c, 800212
selling_co_office_mls_id__c, CGL01
selling_co_office_name__c, Corcoran Global Living
selling_co_office_number__c, 28273
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 2080
size__c, 2080
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Douglass
subdist__c, The Castro - Dolores Heights
ffd_name, 374 Douglass Street, San Francisco, CA, 94114
transportation__c, 2 Blocks
view__c, Panoramic;City Lights;Bay;Water;Downtown;Bay Bridge;San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1910
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/375598-1.jpg
ListingId, a0E1I00000TvV5eUAF