meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337521' 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] => 2023-06-23 08:17:29
[post_modified_gmt] => 2023-06-23 15:17:29
[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, 879 Sanchez Street, San Francisco, CA, 94114
ffd_mls_id, 423900091
ffd_salesforce_id, a0E8W00000cqHZbUAM
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 879 Sanchez Street, San Francisco, CA, 94114
pba__address_pb__c, 879 Sanchez Street, San Francisco, CA, 94114
agent_only_remarks__c, Showings by appointment. This home is still seller occupied. Please give some advance notice for showing requests. Their daughter naps between 12:00-2:00 PM each day so please try to schedule showings with that timeframe in mind. Disclosure package available by request. The 3rd bedroom and bath were added with permit but their square footage does not seem to be reflected in the tax records. Buyer to investigate square footage to their own satisfaction.
appliances__c, Dishwasher;Microwave;Hood Over Range;Built-In Gas Range;Free Standing Refrigerator;Compactor
architectural_style__c, Mid-Century
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1962
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-04T16:45:59.000+0000
days_on_market__c, 17
dom__c, 17
ffd_description_pb, Sitting on the border of the charming Dolores Heights and Noe Valley neighborhoods, this 3-bedroom, 3-bathroom residence is a beacon of natural light, seamlessly blending the timeless allure of mid-century architecture with contemporary luxuries. This home is a gem that offers sweeping western and southern views that cast a mesmerizing backdrop. This residence offers seamless access to the charm of Noe Valley's 24th Street's shops and culinary delights, the vibrant Mission district, the iconic Dolores Park and the cultural tapestry of the Castro. Experience the pinnacle of contemporary living, complemented by a location that effortlessly merges convenience with urban allure.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-09-22T01:46:40.000+0000
pba__latitude_pb__c, 37.755019
pba__latitude_property__c, 37.755019
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2023-08-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Scott
pba__listing_agent_lastname__c, Brittain
listing_agent_mls_id__c, 400402
ffd_listingagentname, Scott Brittain
listing_agent_number__c, 400402
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, 2495000
pba__listingtype__c, Sale
pba__listing_website__c, http://doloresheightsstunner.com
pba__longitude_pb__c, -122.429752
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 423900091
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Double Sinks;Skylight/Solar Tube
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-09-04
open_house_end__c, 2023-09-24T16:00:00.000+0000
open_house_start__c, 2023-09-24T14:00:00.000+0000
original_price__c, 2495000
overall_days_on_market__c, -81695
parking_access__c, Side by Side
parking_features__c, Attached,EV Charging,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
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, 1480.71
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cqHZbUAM
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, 1685
size__c, 1685
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Sanchez
subdist__c, The Castro - Dolores Heights
ffd_name, 879 Sanchez Street, San Francisco, CA, 94114
view__c, Water;San Francisco
website_property_type__c, Single Family Home
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 1962
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530661819-1.jpg
