meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='236004' 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, 1403 De Haro Street, San Francisco, CA, 94107
ffd_mls_id, 422644834
ffd_salesforce_id, a0E8W00000Vw7RcUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1403 De Haro Street, San Francisco, CA, 94107
pba__address_pb__c, 1403 De Haro Street, San Francisco, CA, 94107
agent_only_remarks__c, This townhouse in a PUD feels like a single-family home with its exposure on three sides. Owners have already relocated to the east coast. Inspections (SPCR and General) completed and the reports have been uploaded to Disclosures,IO. Click on the link above or send me an e-mail. Note that the Seller has committed to obtaining a Structural Pest Control clearance and to putting on a new roof this month. Open Sunday April 17th 2-4pm. Offers at any time.
appliances__c, Dishwasher;Insulated Water Heater;Microwave;Disposal;Hood Over Range;Free Standing Refrigerator
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1984
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-04-19
ffd_createddate, 2022-04-01T20:47:41.000+0000
days_on_market__c, 474
dom__c, 31
ffd_description_pb, Remodeled 3 bedroom, 2 full bathroom townhouse in sunny Potrero Hill! Large bay windows in dining area overlook pine trees and community garden. Upper level features an open floor plan with kitchen, dining and living area, a bedroom and connecting bathroom and a sundeck. Lower level has primary bedroom with garden patio entrance, connecting bathroom, third bedroom, washer & dryer and 1-car garage. Large closets throughout. Additional parking in driveway. Less than 1 mile to Potrero Hill and Dogpatch eateries and bars. Half a mile to Potrero Hill Recreation Center with dog park, tennis and basketball courts, baseball field, incredible views of the Bay and large playground. Homeowner's amenities include a 'tot lot' (children's playground), community garden and guest parking. Neighborhood school is within walking distance and one of only two in SF to feature a Mandarin language immersion option. Close to 101 and 280 freeways for easy commute Downtown, to SFO, or to the Peninsula.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Simulated Wood
hoa_fee_includes__c, Maintenance Exterior,Maintenance Grounds,Management
pba__hoafees__c, 275
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Parkview Heights
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-05-19T10:49:07.000+0000
pba__latitude_pb__c, 37.751892
pba__latitude_property__c, 37.751892
laundry_features__c, Ground Floor;Washer Included;Dryer Included
listed_date__c, 2022-04-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Parry
listing_agent_mls_id__c, 202699
ffd_listingagentname, David Parry
listing_agent_number__c, 202699
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/xd6h7HDT4l4
pba__longitude_pb__c, -122.400205
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 422644834
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-04-01
original_price__c, 995000
overall_days_on_market__c, -81174
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Guest Parking Available,Interior Access
parking_type__c, On Site (Single Family Only);On Site - Mapped (Condo Only)
pba__pendingdate__c, 2022-05-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-05-18T17:46:04.000+0000
price_per_square_foot__c, 864.01
pba__propertytype__c, Townhouse
id, a0E8W00000Vw7RcUAJ
roof__c, Shingle
sale_date__c, 2022-05-18
sale_price__c, 1150000
selling_agent_mls_id__c, 810762
selling_agent_number__c, 1047860
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, 1331
size__c, 1331
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, De Haro
subdist__c, Potrero Hill
ffd_name, 1403 De Haro Street, San Francisco, CA, 94107
website_property_type__c, Townhouse
pba__yearbuilt_pb__c, 1984
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530430146-1.jpg
ListingId, a0E8W00000Vw7RcUAJ