meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210975' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15714
[post_author] => 4
[post_date] => 2018-11-02 19:54:27
[post_date_gmt] => 2018-11-02 19:54:27
[post_content] => Meet Potrero Hill, where you can check out but you can never really leave. Sunny weather, jaw-dropping views of the downtown skyline and San Francisco Bay. Friendly, charming, and filled with more than you'd expect, it's a hill unto itself.
[post_title] => Potrero Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => potrero-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:08:25
[post_modified_gmt] => 2024-03-19 21:08:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15714
[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, 715 De Haro 717 Street, San Francisco, CA, 94107
ffd_mls_id, 503683
ffd_salesforce_id, a0E1I00000TRlbZUAT
vacant__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 715 De Haro 717 Street, San Francisco, CA, 94107
pba__address_pb__c, 715 De Haro 717 Street, San Francisco, CA, 94107
agent_only_remarks__c, Please contact [email protected] for showing requests. Upper unit (717) is vacant & staged and can be shown anytime. Lower unit (715) is tenant-occupied with market-rate rent and need 24 hours notice to show at minimum, and prefer offers written subject to walk-through of 715 De Haro within 24 hours of contract ratification. ***Please note showings of 715 can typically only be accommodated on the weekends or early evenings (~6PM). We will do our best otherwise.*** Two car garage is for sole use of 717 - not a part of 715's lease. Backyard only accessible via Unit 715. Website at www.deharoduplex.com
appliances__c, Dishwasher;Disposal;Free Standing Refrigerator;Free Standing Oven/Range
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1965
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sara Werner Costa
pba__contingentdate__c, 2021-01-23
cooling__c, Ceiling Fan(s)
ffd_createddate, 2020-10-05T20:46:46.000+0000
days_on_market__c, 1017
dom__c, 123
ffd_description_pb, Located on the coveted, sunny North Slope of Potrero Hill, this duplex is the one! The penthouse primary unit (2 bed, 2 bath) has A/C and contains a luxurious primary suite with walk-in closet, gas fireplace, and marble bathroom with steam shower. The open concept kitchen, dining and living space, including large entertainer's deck, have jaw-dropping panoramic views of downtown. The second bedroom has built-in Murphy bed, cabinetry and desks, and can flex as a home office space. 717 also enjoys exclusive use of the 2 car side by side garage. The lower unit spans two levels and has two bedrooms (currently configured as three bedrooms), modern kitchen, and similar panoramic views. There is direct patio access from the lower level. Views do not come at the sacrifice of convenience for this ideally situated home. The shops and restaurants of 18th Street are merely a few blocks away - including Goat Hill Pizza, Chez Maman, Plow and more. 280, 101 nearby.
district__c, SF District 9
est_total_expenses__c, 0
external_listing__c, 1
pba__floortype_pb__c, Bamboo;Carpet;Wood
gross_annual_income__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Skylight(s);Vaulted Ceiling(s)
ffd_lastmodifieddate, 2022-01-25T13:32:10.000+0000
pba__latitude_pb__c, 37.760766
pba__latitude_property__c, 37.760766
laundry_features__c, Washer/Dryer;In Each Unit;Washer/Dryer Owned
listed_date__c, 2020-08-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Franck
pba__listing_agent_lastname__c, Costa
listing_agent_mls_id__c, 807197
ffd_listingagentname, Franck Costa
listing_agent_number__c, 166018406
listing_co_agent_mls_id__c, 806154
listing_co_agent_number__c, 166016364
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__listing_website__c, http://my.matterport.com/show/?m=Es4Jo8egHxz
pba__longitude_pb__c, -122.400895
pba__lotsize_pb__c, 0.06
mls_id__c, 503683
master_property__c, a0O8W00000DaF4yUAF
parkingspaces__c, 2
on_market_date__c, 2020-10-05
original_price__c, 3150000
overall_days_on_market__c, 141
parking__c, Attached,Garage,Auto Door
parking_features__c, Attached,Garage,Garage Door Opener
patio_and_porch_features__c, Patio(s);Balcony/Deck
pba__pendingdate__c, 2021-02-05
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 795.2
pba__propertytype__c, Duplex
id, a0E1I00000TRlbZUAT
sale_date__c, 2021-02-22
sale_price__c, 2850000
security_features__c, Smoke Detector;Security Gate
selling_agent_mls_id__c, 805631
selling_agent_number__c, 166015627
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 3584
size__c, 3584
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, De Haro
style__c, Contemporary
subdist__c, Potrero Hill
ffd_name, 715 De Haro 717 Street, San Francisco, CA, 94107
type__c, Duplex
view__c, Panoramic;City Lights;Bay Bridge;San Francisco
website_property_type__c, Duplex
window_features__c, Window Coverings;Dual Pane
pba__yearbuilt_pb__c, 1965
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371658-1.jpg
ListingId, a0E1I00000TRlbZUAT