meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331866' 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, 1109 De Haro Street, San Francisco, CA, 94107
ffd_mls_id, 423730176
ffd_salesforce_id, a0E8W00000baVqQUAU
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 1109 De Haro Street, San Francisco, CA, 94107
pba__address_pb__c, 1109 De Haro Street, San Francisco, CA, 94107
agent_only_remarks__c, Short buyer contingency period, happy to put someone in backup! Airbnb financial history of ~$50k per year income, financials in discl package. The lower level was completed w/out benefit of permit and has an active Airbnb permit with the city, buyer to investigate conveyance of permit. Square footage of home is larger than tax record indicates, buyer to investigate. Detailed approved plans for a 3-level, 5 bedroom home w/roof deck. Easy to show with code outside of open house times, contact listing agent. https://app.disclosures.io/link/1109-De-Haro-Street-1q9h603t
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1924
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-04-23
ffd_createddate, 2023-03-31T18:48:52.000+0000
days_on_market__c, 110
dom__c, 28
ffd_description_pb, Opportunities abound in this single-family home with both approved plans to build up and Airbnb bonus space on the lower level. The main level will impress with its original detail such as the box beam ceiling and wood paneling in the dining room and cozy fireplace in the family room with views of Twin Peaks and Sutro Tower. The updated and modern kitchen is anchored by a large center island that invites gathering. 2 bedrooms, an updated modern bathroom, a desk alcove and laundry area complete this level. Venture outside to access two levels of patio and terraces that command expansive Twin Peaks and hill views. The lower-level bonus space includes a full bathroom and has a positive short-term rental history. Use this space for income, a dedicated home office, guest bedroom, or au-pair space. The one car garage with EV charging outlet includes extra storage and workbench space. Great location with easy access to both Potrero and Mission District shops and restaurants as well as freeways, MUNI, tech bus stops and more. Don't miss this unique home!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-07-13T18:39:35.000+0000
pba__latitude_pb__c, 37.755731
pba__latitude_property__c, 37.755731
laundry_features__c, Hookups Only
listed_date__c, 2023-02-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sherry
pba__listing_agent_lastname__c, Gray
listing_agent_mls_id__c, 810109
ffd_listingagentname, Sherry L Gray
listing_agent_number__c, 1044758
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CITYRE
listing_office_name__c, City Real Estate
listing_office_number__c, 27425
pba__listingprice_pb__c, 1595000
pba__listingtype__c, Sale
pba__listing_website__c, http://1109deharo.com/mls
pba__longitude_pb__c, -122.400419
lower_level__c, Family Room,Full Bath(s),Garage,Street Entrance
mls_id__c, 423730176
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-31
original_price__c, 1595000
overall_days_on_market__c, -81538
parking_access__c, Independent
parking_features__c, EV Charging,Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-04-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000baVqQUAU
sale_date__c, 2023-05-18
sale_price__c, 1650000
selling_agent_mls_id__c, 807431
selling_agent_number__c, 1018261
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, De Haro
subdist__c, Potrero Hill
ffd_name, 1109 De Haro Street, San Francisco, CA, 94107
view__c, Twin Peaks;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530597662-1.jpg