meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='384586' 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, 1724324344
ffd_listing_title, 851 Church 853 Street, San Francisco, CA, 94114
ffd_mls_id, 424048142
ffd_salesforce_id, a0EUd000002f4uYMAQ
num_of_rooms__c, 9
of_units__c, 2
address2__c, 851 Church 853 Street, San Francisco, CA, 94114
pba__address_pb__c, 851 Church 853 Street, San Francisco, CA, 94114
agent_only_remarks__c, Offer date is Wednesday August 7, 2024 by 12pm Noon. Showing of tenant occupied unit #851 requires 24 hours notice. Please DO NO DISTURB TENANT. No record of evictions or Ellis per owner and SF Rent Board, buyer should confirm. Disclosures available via this link here: https://app.disclosures.io/link/851853-Church-Street-mknbsm7a.
appliances__c, Dishwasher;Insulated Water Heater;Gas Water Heater;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Other
architectural_style__c, Edwardian;Victorian;Traditional
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1909
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Virginia C Thackwell
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-07-25T10:51:13.000+0000
days_on_market__c, 28
dom__c, 14
ffd_description_pb, Built 1909. Two unit corner building in Dolores Heights. These units have many original views, an easy flow and pretty outlooks. The spacious corner lot has THREE detached independent garages, plus one large tandem spot (fits 2 cars) under the main building. Surrounded by tall and leafy mature trees, the outlooks are serene. There is a large two story deck leading to a spacious garden-patio. The upper unit 3BR, 1.5BA will be delivered vacant, providing a blank canvas for your vision. The lower unit is a 2BR, 1BA with lovely details and is currently tenant-occupied. This is a rare opportunity for developers, investors, or owner-occupants to create a bespoke residence in one of San Francisco's most delightful locations! The possibilities are endless here! Add an ADU? Develop the garage space? Have a car collection and need 5 garage spaces? This is the right place. Supra Lockbox for #853 and property, garages, garden, only. 24 Hours Notice required for #851. https://851-853churchstreet.com/ OPEN HOUSES: Thursday Aug 1 Twilight 6-7:30pm 851-853 Entire Property *NEW SHOWING ADDED* Sunday Aug 4 2-4pm Entire Property.
district__c, SF District 5
external_listing__c, 1
pba__floortype_pb__c, Linoleum;Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Floor Furnace;Wall Furnace;Gas
ffd_lastmodifieddate, 2024-08-22T10:51:10.000+0000
pba__latitude_pb__c, 37.7678965
pba__latitude_property__c, 37.7678965
laundry_features__c, Washer/Dryer Owned
listed_date__c, 2024-07-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Robin
pba__listing_agent_lastname__c, Whiteside
listing_agent_mls_id__c, 818785
ffd_listingagentname, Robin Whiteside
listing_agent_number__c, 1077493
listing_co_agent_mls_id__c, A336250
listing_co_agent_number__c, 981092333
listing_co_office_mls_id__c, AZEPH9
listing_co_office_name__c, Corcoran Icon Properties
listing_co_office_number__c, 981028552
listing_office_mls_id__c, CIP
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28936
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4285879
mls_id__c, 424048142
parkingspaces__c, 5
on_market_date__c, 2024-07-25
original_price__c, 1495000
overall_days_on_market__c, -82020
parking_features__c, Detached,EV Charging,Garage,Tandem Garage
patio_and_porch_features__c, Uncovered Deck;Balcony/Deck
pba__pendingdate__c, 2024-08-08
price_per_square_foot__c, 754.55
pba__propertytype__c, Duplex
ListingId, a0EUd000002f4uYMAQ
roof__c, Tar/Gravel;Flat
sale_date__c, 2024-08-21
sale_price__c, 2075000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 802842
selling_agent_number__c, 802842
selling_co_agent_mls_id__c, 806005
selling_co_agent_number__c, 166016135
selling_co_office_mls_id__c, CIP14
selling_co_office_name__c, Corcoran Icon Properties
selling_co_office_number__c, 28965
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 2750
size__c, 2750
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Church
subdist__c, The Castro - Dolores Heights
ffd_name, 851 Church 853 Street, San Francisco, CA, 94114
view__c, Bay;Downtown;Bay Bridge
website_property_type__c, Duplex
window_features__c, Bay Window(s);Dual Pane Partial;Varies by Unit
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530815684-1.jpg