meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212306' 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
(
)
)
ffd_listing_title, 35 Clover Street, San Francisco, CA, 94114
ffd_mls_id, 498022
ffd_salesforce_id, a0E1I00000SlmUOUAZ
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 35 Clover Street, San Francisco, CA, 94114
pba__address_pb__c, 35 Clover Street, San Francisco, CA, 94114
agent_only_remarks__c, Back On Market, No Fault of Property. Buyer Canceled due to Financing. Schedule showings at https://calendly.com/wendystorch/35-clover-street-showing You will fall in LOVE! Lower rooms are legal. Great street and special location in the city. Inspector suggests that the estimate to repair retaining wall in the range of of $10,000 to 15,000. Agents may call inspector to discuss. Disclosures available on Disclosures IO link. View Virtual Tour @ www.35Clover.com View Video @https://vimeo.com/420657491
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;ENERGY STAR Qualified Appliances;Ice Maker
architectural_style__c, Victorian;Traditional;Cottage
bath_features__c, Tub w/Shower Over;Shower Stall(s);Remodeled;Marble;Tile;Dual Flush Toilet;Granite
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-06-15
ffd_createddate, 2020-05-20T17:45:36.000+0000
days_on_market__c, 1155
dom__c, 27
ffd_description_pb, With sweeping outlooks across a lush garden to Eureka Valley & Mission Dolores, set on an absolutely adorable one-block street, this magical Victorian Cottage has an airy polish, sought-after village walkability & quiet, best-kept-secret-street prestige. The shingle facade &front garden a riot of blooms & fragrant shrubs, gives way to the expansive open layout & soaring, sky-lit ceilings of its main living space. In addition, there are 2 bedrooms & full bath on this level, gleaming wood flooring, well appointed stainless kitchen & decks which create an indoor outdoor livability. Below, an efficient wet-bar, full bath suite with an additional private deck are a serene retreat. The solar array powering this home, robust storage, garage parking with interior access & excellent storage make this home as convenient as is it lovely. The location is highly prized for its proximity to Kite Hill, Castro retail, EZ commute the Fidi, South Bay & geographically central to the entire city.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Gas Piped
pba__floortype_pb__c, Carpet;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:22:54.000+0000
pba__latitude_pb__c, 37.760039
pba__latitude_property__c, 37.760039
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-03-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Wendy
pba__listing_agent_lastname__c, Storch
listing_agent_mls_id__c, 803139
ffd_listingagentname, Wendy M Storch
listing_agent_number__c, 803139
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, 1795000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.35Clover.com
pba__longitude_pb__c, -122.441292
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 498022
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-05-20
original_price__c, 1795000
overall_days_on_market__c, 122
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-06-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1179.85
pba__propertytype__c, Single Family Residence
id, a0E1I00000SlmUOUAZ
roof__c, Composition;Shingle
room_type__c, Storage
sale_date__c, 2020-07-16
sale_price__c, 1850000
selling_agent_mls_id__c, 808958
selling_agent_name__c, Ryan Richard
selling_agent_number__c, 1038682
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1568
size__c, 1568
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Clover
subdist__c, The Castro - Dolores Heights
ffd_name, 35 Clover Street, San Francisco, CA, 94114
transportation__c, 1 Block
view__c, Marina;City Lights;Garden/Greenbelt;Water;San Francisco;Mountains;Mt Diablo
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363361-1.jpg
ListingId, a0E1I00000SlmUOUAZ