meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='213855' 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-11-19 12:01:01
[post_modified_gmt] => 2024-11-19 20:01:01
[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, 258 Diamond Street, San Francisco, CA, 94114
ffd_mls_id, 503272
ffd_salesforce_id, a0E1I00000S11cVUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 258 Diamond Street, San Francisco, CA, 94114
pba__address_pb__c, 258 Diamond Street, San Francisco, CA, 94114
agent_only_remarks__c, Offer Date: Monday, August 17th at 10am. Please submit offers to Sherri Howe and Kristin Rolph. The sellers do not need a rent back, but they would like to close after 9/1. In an effort to keep us all safe, we will be strictly adhering to the current COVID-19 safety guidelines in San Francisco. Please have buyers review all virtual media @ 258Diamond.com before scheduling a showing. Please contact Kristin Rolph at 415.265.1427 or [email protected] to schedule a qualified showing.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;Freezer
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1916
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kristin E Rolph
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-08-12T05:48:33.000+0000
days_on_market__c, 1608
dom__c, 11
ffd_description_pb, This classic Edwardian home has been lovingly maintained by only 3 different families over the past 104 years. It features a fantastically functional & coveted layout on an oversized lot. Beautifully preserved period details throughout. Move right in & enjoy the home as-is, or select your favorite finishes & make it your own. MAIN FLOOR: Foyer, living room, dining room, family room, kitchen & half bathroom. Direct access from the family room onto the deck & into the expansive backyard with a lawn, mature roses, & raised garden beds.. TOP FLOOR: 3 bedrooms, 2 full bathrooms, & a sunroom. One of the bedrooms is a large room with en-suite bathroom & walk-in closet. BOTTOM FLOOR: 2nd family room, 3rd full bathroom, wine cellar/storage room, & direct yard & garage access. Located on a peaceful tree-lined street in Eureka Valley, with convenient access to public transit on Market Street, & a diverse array of restaurants & retail in the Castro, Mission Dolores, & Noe Valley.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:30:24.000+0000
pba__latitude_pb__c, 37.7581845
pba__latitude_property__c, 37.7581845
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2019-09-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sherri
pba__listing_agent_lastname__c, Howe
listing_agent_mls_id__c, 806718
ffd_listingagentname, Sherri Howe
listing_agent_number__c, 166017501
listing_co_agent_mls_id__c, 811377
listing_co_agent_number__c, 1051265
listing_co_office_mls_id__c, CGL01
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28273
listing_office_mls_id__c, CGL01
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28273
pba__listingprice_pb__c, 2595000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.258Diamond.com
pba__longitude_pb__c, -122.4371017
pba__lotsize_pb__c, 0.07
lower_level__c, Family Room,Full Bath(s)
mls_id__c, 503272
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-08-06
original_price__c, 2595000
overall_days_on_market__c, 52
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Independent
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-08-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1144.53
pba__propertytype__c, Single Family Residence
id, a0E1I00000S11cVUAR
room_type__c, Sun Room
sale_date__c, 2020-09-16
sale_price__c, 2645000
selling_agent_mls_id__c, 802363
selling_agent_name__c, Amy Clemens
selling_agent_number__c, 802363
selling_co_agent_mls_id__c, 808044
selling_co_agent_name__c, Alec L. Mironov
selling_co_agent_number__c, 1030093
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, 2311
size__c, 2311
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Diamond
subdist__c, The Castro - Dolores Heights
ffd_name, 258 Diamond Street, San Francisco, CA, 94114
transportation__c, 2 Blocks
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1916
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/367828-1.jpg
ListingId, a0E1I00000S11cVUAR
_yoast_indexnow_last_ping, 1735656386