meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211963' 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, 375 Diamond Street, San Francisco, CA, 94114
ffd_mls_id, 497018
ffd_salesforce_id, a0E1I00000Se4DTUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 11
of_units__c, 0
address2__c, 375 Diamond Street, San Francisco, CA, 94114
pba__address_pb__c, 375 Diamond Street, San Francisco, CA, 94114
agent_only_remarks__c, Call Isabelle 415.342.5010 or Matthew 415.794.7988 for more info.
appliances__c, Dishwasher;Electric Range;Microwave;Disposal;Refrigerator
architectural_style__c, Contemporary;Craftsman
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Remodeled;Tile
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 6
year_build_text__c, 1963
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-09-01
ffd_createddate, 2020-04-17T17:46:14.000+0000
days_on_market__c, 1188
dom__c, 135
ffd_description_pb, Spectacular Eureka Valley home offering 3 levels of modern living. With 6 BD & 4 BAs spread across 4,300 Sq ft, the home is designed around a reverse floor plan. The upper level is anchored by a Chef's kitchen with a central island and high-end appliances, with an adjoining living and dining areas. 1BD, 1BA and office complete this level and provide access to the patio leading up to the panoramic view deck. On the main level, the Master suite occupies the entire back of the property featuring an impressive en-suite bathroom with a free-standing jet tub, a large rain shower, a walk-in closet, and private patio. At the front, two BDs are joined by an outdoor deck and share an adjacent BA. The lower level and just a few steps from the front door, a legal one-bedroom, one-bath unit with its own private deck is the perfect guest suite for visitors. Additional features include a laundry room & storage area, a side-by-side two-car garage & exterior spaces from every level
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2022-01-25T15:20:51.000+0000
pba__latitude_pb__c, 37.75635
pba__latitude_property__c, 37.75635
laundry_features__c, Inside Room
listed_date__c, 2019-11-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Isabelle
pba__listing_agent_lastname__c, Grotte
listing_agent_mls_id__c, 807863
ffd_listingagentname, Isabelle Grotte
listing_agent_number__c, 1027872
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 3995000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.375Valley.com
pba__longitude_pb__c, -122.43648
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 497018
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s)
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-04-17
original_price__c, 4295000
overall_days_on_market__c, 258
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-09-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 841.86
pba__propertytype__c, Single Family Residence
id, a0E1I00000Se4DTUAZ
room_type__c, Office
sale_date__c, 2020-10-06
sale_price__c, 3620000
security_features__c, Smoke Detector;Security Alarm(s);Fire Alarm
selling_agent_mls_id__c, 809119
selling_agent_name__c, Judson B. Gregory
selling_agent_number__c, 1040495
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 4300
size__c, 4300
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Diamond
subdist__c, The Castro - Dolores Heights
ffd_name, 375 Diamond Street, San Francisco, CA, 94114
transportation__c, 2 Blocks
view__c, Panoramic;City Lights
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1963
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362124-1.jpg
ListingId, a0E1I00000Se4DTUAZ