meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237678' 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, 1172 De Haro Street, San Francisco, CA, 94107
ffd_mls_id, 422686329
ffd_salesforce_id, a0E8W00000YY9HJUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 1172 De Haro Street, San Francisco, CA, 94107
pba__address_pb__c, 1172 De Haro Street, San Francisco, CA, 94107
agent_only_remarks__c, Try to show during daylight. Trust Sale - No Court Confirmation Needed. Please use current SFAR Purchase Contract. Disclosures here https://app.disclosures.io/link/1172-De-Haro-Street-89y2xj6y Home is in a bit of disrepair, please be aware of soft deck boards in the rear yard. Lower Unit can be accessed via the front door and go down via the rear stairs. Buyers encouraged to complete any due diligence needed to fulfill their needs. Offer information to follow. Please note that public record states different bed and bath count that what exists.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Gas Plumbed
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1911
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Michael F Hirner
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-08-11T21:47:20.000+0000
days_on_market__c, 342
dom__c, 4
ffd_description_pb, Calling all Contractors! This diamond in the rough Potrero Hill home is perfect for a renovation, remodel or rebuild. An attractive perfectly San Francisco house with a lot of potential. This 1387 sq ft home sits on a deep lot and includes an unwarranted in-law unit below.
district__c, SF District 9
electric__c, Photovoltaics Seller Owned
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Laminate;Slate;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Open Beam Ceiling
ffd_lastmodifieddate, 2023-07-13T17:29:42.000+0000
pba__latitude_pb__c, 37.755008
pba__latitude_property__c, 37.755008
laundry_features__c, Washer/Dryer Stacked Included;In Basement
listed_date__c, 2022-08-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sheldon
pba__listing_agent_lastname__c, Rilliet
listing_agent_mls_id__c, 806943
ffd_listingagentname, Sheldon T Rilliet
listing_agent_number__c, 199021669
listing_co_agent_mls_id__c, 802272
listing_co_agent_number__c, 802272
listing_co_office_mls_id__c, COMP31
listing_co_office_name__c, Compass
listing_co_office_number__c, 27894
listing_office_mls_id__c, COMP31
listing_office_name__c, Compass
listing_office_number__c, 27894
pba__listingprice_pb__c, 900000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.400975
mls_id__c, 422686329
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-08-11
original_price__c, 900000
overall_days_on_market__c, -81306
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-08-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 865.18
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000YY9HJUA1
road_surface_type__c, Paved
roof__c, Composition;Shingle
room_type__c, Storage;Bonus Room;Kitchen;In Law Apartment;Living Room;Dining Room
sale_date__c, 2022-08-24
sale_price__c, 1200000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, MLSL5091044
selling_agent_number__c, 981378425
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, 1387
size__c, 1387
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, De Haro
subdist__c, Potrero Hill
ffd_name, 1172 De Haro Street, San Francisco, CA, 94107
website_property_type__c, Single Family Home
window_features__c, Window Coverings;Bay Window(s)
pba__yearbuilt_pb__c, 1911
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530511640-1.jpg