meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='296495' 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] => 2021-12-01 19:31:12
[post_modified_gmt] => 2021-12-02 03:31:12
[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
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E8W00000V1UwJUAV
pba__address_pb__c 886 Castro Street, San Francisco, CA, 94114
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 3
pba__bedrooms_pb__c 3
days_on_market__c 243
mls_id__c 421608080
pba__totalarea_pb__c 2435
pba__latitude_pb__c 37.7548076
pba__longitude_pb__c -122.4347431
pba__state_pb__c CA
pba__status__c Closed
pba__street_pb__c Castro
listed_date__c 2021-09-15
sale_date__c 2021-11-22
pba__propertytype__c Single Family Residence
pba__listingprice_pb__c 3098000
pba__listingtype__c Sale
sale_price__c 3070000
address2__c 886 Castro Street, San Francisco, CA, 94114
pba__listing_agent_firstname__c Tiffany
pba__listing_agent_lastname__c Hickenbottom
view__c City;City Lights;Bay;Water;Downtown
pba__halfbathrooms_pb__c 1
parkingspaces__c 2
pba__postalcode_pb__c 94114
year_build_text__c 1994
size__c 2435
subdist__c The Castro - Dolores Heights
listing_agent_mls_id__c 807832
selling_agent_mls_id__c 802285
listing_co_office_number__c 0
listing_office_number__c 27341
listing_office_name__c Compass
listing_office_mls_id__c COMP2
of_units__c 0
district__c SF District 5
selling_agent_number__c 116
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 79
dom__c 15
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 1260.78
selling_office_name__c Compass
parking_type__c On Site (Single Family Only)
original_price__c 3098000
agent_only_remarks__c This is a single family residence built with a collection of condominiums in the 90's (per 3R and title report). There is HOA that covers common area use of walkway, elevator, mailbox and gates. Escrow is opened with Fidelity National Title, Paula Siegel. Please use SFAR Purchase contract. If your client is looking for privacy, views, location and space - this is a must see!
pba__yearbuilt_pb__c 1994
pba__listing_agent_email__c [email protected]
monthlyrent__c 0
external_listing__c 1
pba__latitude_property__c 37.7548076
listing_agent_number__c 1027421
on_market_date__c 2021-10-28
architectural_style__c Contemporary;Traditional
pba__listing_website__c http://www.886Castro.com
website_property_type__c Single Family Home
media Array
ListingUpdateDate 2022-06-29T03:16:27