meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210283' 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-10-31 09:49:52
[post_modified_gmt] => 2023-10-31 16:49:52
[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, 580 Hill Street, San Francisco, CA, 94114
ffd_mls_id, 495633
ffd_salesforce_id, a0E1I00000RtDXaUAN
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 580 Hill Street, San Francisco, CA, 94114
pba__address_pb__c, 580 Hill Street, San Francisco, CA, 94114
agent_only_remarks__c, Stunning designer renovation on 3 levels with ideal floor plan. 3 Beds on one level + large media and office/4th bedroom on main floor. Pre-sale escrow is with Paula Siegel, Fidelity on Market Contact Tiffany 415.933.7001 for Showings.
appliances__c, Dishwasher;Insulated Water Heater;Gas Range;Disposal;Refrigerator;Hood Over Range;ENERGY STAR Qualified Appliances;Freezer
architectural_style__c, Edwardian;Modern/High Tech;Traditional;Craftsman
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Low-Flow Toilet(s);Radiant Heat;Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1905
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-04-10
ffd_createddate, 2020-03-02T18:45:34.000+0000
days_on_market__c, 1234
dom__c, 51
ffd_description_pb, Beautifully renovated Liberty Hill Edwardian on one of Dolores Height's most coveted, tree-lined, flat blocks capturing breathtaking city/skyline views. Perfectly blending old with new, this 3,100 sf+/-, 4BR, 3.5BA home has been restored with attention to every detail. The welcoming main living space is light-filled with high ceilings, designer finishes, custom built-ins, and stylish black framed doors and windows. Bright modern kitchen offers Caesarstone island, Ann Saks backsplash, custom cabinetry and Thermador appliances. Dramatic dining area opens to a view balcony, bringing the outdoors in. Upstairs is a private master with spa-like bath, inspiring views and balcony, as well as 2 more bedrooms and a bath. Designed for seamless indoor-outdoor living, the garden level has a large media/family room opening to a multilevel landscaped yard with firepit, built-in seating and BBQ areas. This level is complete with a full bath, office and laundry room. A true oasis in the city!
district__c, SF District 5
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Brick;Gas Piped
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-12T15:28:46.000+0000
pba__latitude_pb__c, 37.755566
pba__latitude_property__c, 37.755566
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-02-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tiffany
pba__listing_agent_lastname__c, Hickenbottom
listing_agent_mls_id__c, 807832
ffd_listingagentname, Tiffany Hickenbottom
listing_agent_number__c, 1027421
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP2
listing_office_name__c, Compass
listing_office_number__c, 27341
pba__listingprice_pb__c, 4495000
pba__listingtype__c, Sale
pba__listing_website__c, https://player.vimeo.com/video/394010792" width="640" height="360" frameborder="0" allowfullscreen>
pba__longitude_pb__c, -122.433946
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 495633
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2020-03-02
original_price__c, 4495000
overall_days_on_market__c, 92
patio_and_porch_features__c, Deck(s);Patio(s);Covered Patio
pba__pendingdate__c, 2020-04-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1388.89
pba__propertytype__c, Single Family Residence
id, a0E1I00000RtDXaUAN
roof__c, Composition
room_type__c, Laundry
sale_date__c, 2020-04-28
sale_price__c, 4400000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 666666
selling_agent_name__c, Non Member Sales
selling_agent_number__c, 666666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, TheMLS
pba__status__c, Closed
pba__totalarea_pb__c, 3168
size__c, 3168
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Hill
subdist__c, The Castro - Dolores Heights
ffd_name, 580 Hill Street, San Francisco, CA, 94114
transportation__c, 1 Block
view__c, Panoramic;City Lights;Downtown
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane;Weather Stripped
pba__yearbuilt_pb__c, 1905
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/361009-1.jpg
ListingId, a0E1I00000RtDXaUAN