meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218756' 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, 640 De Haro Street, San Francisco, CA, 94107
ffd_mls_id, 421545907
ffd_salesforce_id, a0E1I00000USe0PUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 640 De Haro Street, San Francisco, CA, 94107
pba__address_pb__c, 640 De Haro Street, San Francisco, CA, 94107
agent_only_remarks__c, Disclosure package in Disclosure IO via MLS. Virtually tour at www.LovePotreroHill.com Schedule a private CDC-compliant showings by emailing [email protected] Send PEAD prior to your tour. All visitors to supply own personal protective equipment. Call or text Debbie for further info 415-640-1487
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Tile;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1990
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-05-16
ffd_createddate, 2021-05-07T18:48:13.000+0000
days_on_market__c, 804
dom__c, 40
ffd_description_pb, Sunny Potrero Hill has a charming small town feel in a world class city. Wonderful top floor 3bd/2ba condo checks a lot of boxes. Filled with natural light, the open living, dining area has Bay Bridge, Downtown + City views. The living rm has a wood burning fireplace adding to this enjoyable entertaining space. Brand new, eat-in kitchen with stainless appliances, gas stove, abundant marble counters and cabinetry. The serene primary bedrm is softly sunlit w/walk-in closet plus a bathrm w/skylight + double vanity. 3bd/2ba are on one level. Expand your living space with the spacious common decks w/sweeping city views. Laundry, 2 parking spaces, one in garage and one in the driveway. There are no HOA dues. Walk Score 90, close to Whole Foods, Le Cordon Bleu College of Culinary Arts, California College of the Arts, Design Center, UCSF Mission Bay, Chase Center, Oracle Park, restaurants, shops + easy fwy access. Love where you live
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__hoafees__c, 0
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
interior_features__c, Skylight Tube;Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:51:46.000+0000
pba__latitude_pb__c, 37.761731
pba__latitude_property__c, 37.761731
laundry_features__c, In Garage
listed_date__c, 2021-05-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Debbie
pba__listing_agent_lastname__c, Hemingway
listing_agent_mls_id__c, 355987
ffd_listingagentname, Debbie Hemingway
listing_agent_number__c, 355987
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, 1650000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=ERZADRHWz34&mls=1
pba__longitude_pb__c, -122.401648
mls_id__c, 421545907
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Double Sinks
master_property__c, a0O1I000004VYQsUAO
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-05-06
original_price__c, 1650000
overall_days_on_market__c, 117
parking_access__c, Independent
parking_features__c, Assigned,Covered,Enclosed,Garage Door Opener,Interior Access,Uncovered Parking Space
parking_type__c, On Site - Assigned (Condo Only);On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-06-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 979.88
pba__propertytype__c, Condominium
id, a0E1I00000USe0PUAT
sale_date__c, 2021-06-16
sale_price__c, 1631500
selling_agent_mls_id__c, 812094
selling_agent_number__c, 1054840
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, 1665
size__c, 1665
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, De Haro
subdist__c, Potrero Hill
ffd_name, 640 De Haro Street, San Francisco, CA, 94107
view__c, City;City Lights;Downtown;Bay Bridge
website_property_type__c, Condominium
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1990
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530234169-1.jpg
ListingId, a0E1I00000USe0PUAT