meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='373536' 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, 1713390904
ffd_listing_title, 808 Dolores Street, San Francisco, CA, 94110
ffd_mls_id, 424007261
ffd_salesforce_id, a0EUd000001Kcq9MAC
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 2
address2__c, 808 Dolores Street, San Francisco, CA, 94110
pba__address_pb__c, 808 Dolores Street, San Francisco, CA, 94110
agent_only_remarks__c, Please use ShowingTime to schedule showings. Buyers to verify all information provided to satisfaction. Disclosures available via disclosures.io, send email to listing agent. Escrow opened with Heather Schiffer at First American Title. Offer date tbd, please check with Listing Agent.
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1916
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-04T11:47:03.000+0000
days_on_market__c, 44
dom__c, 44
ffd_description_pb, Completely remodeled condo with modern simplicity and rear yard. Excellent Dolores Heights location just minutes to shopping, dining, Dolores Park and the Mission District. Approximately 2,095 square feet of total living space on two levels with 3 bedrooms, 3 bathrooms and 1 half-bath. Living-and-dining room ensemble with fireplace and catering station. Gourmet kitchen with top-of-the-line appliances. Upper level includes two master bedroom suites and powder room. Lower-level bedroom suite with spa bath, access to the private rear yard with outdoor heater and independent access to garage. Laundry area with Miele front-loading washer and dryer. Attached two-car garage with one dedicated space and with locked extra storage. Seismic retrofits, radiant boiler system, wired for ADT alarm, Nest thermostat, sprinkler connected to SF Fire Department, dedicated garage parking, bike storage. Convenient access to public transportation and commute routes.
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Fireplace;Wet Bar
external_listing__c, 1
fencing__c, Back Yard;Fenced
pba__floortype_pb__c, Wood
pba__hoafees__c, 330
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 806-808 Dolores HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant Floor;Fireplace(s)
ffd_lastmodifieddate, 2024-04-17T21:46:42.000+0000
pba__latitude_pb__c, 37.756411
pba__latitude_property__c, 37.756411
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2023-12-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Harold
pba__listing_agent_lastname__c, Deblander
listing_agent_mls_id__c, 809042
ffd_listingagentname, Harold Deblander
listing_agent_number__c, 1039971
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 2990000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=XpwzaL5224j&mls=1
pba__longitude_pb__c, -122.4259649
lower_level__c, Full Bath(s),Garage,Primary Bedroom
mls_id__c, 424007261
main_level__c, Partial Bath(s);Bedroom(s);Living Room;Dining Room
master_property__c, a0OUd000004PSTUMA4
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-04
open_house_end__c, 2024-04-21T16:30:00.000+0000
open_house_start__c, 2024-04-21T14:30:00.000+0000
original_price__c, 2990000
overall_days_on_market__c, -81877
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1427.21
pba__propertytype__c, Condominium
ListingId, a0EUd000001Kcq9MAC
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 2095
size__c, 2095
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Dolores
subdist__c, The Castro - Dolores Heights
ffd_name, 808 Dolores Street, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1916
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530738425-1.jpg