meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209649' 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, 32 Blair Terrace, San Francisco, CA, 94107
ffd_mls_id, 493118
ffd_salesforce_id, a0E1I00000QpUOgUAN
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 32 Blair Terrace, San Francisco, CA, 94107
pba__address_pb__c, 32 Blair Terrace, San Francisco, CA, 94107
agent_only_remarks__c, No City First Right Required. OFFERS, to be submitted on SFAR Contract to [email protected], contact me if you need one. More info and drone on website - www.LivingOnBlair.com Fridge in garage to stay. Laundry area in garage with W/D, storage. 3R says one family dwelling. Tax records say townhouse. Buyer to investigate to their satisfaction. Amazing new LEED certified developments underway 1 block away, get in now and see advantages of getting in early. See link - https://www.vmwp.com/wpress/wp-content/uploads/0747-190329-Potrero_PP.pdf Home square footage about 956 - Reportedly in CTIP School Zone - https://archive.sfusd.edu/en/assets/sfusd-staff/enroll/files/Revising_CTIP1_for_2014_15_SY.pdf - Buyer to investigate all to their satisfaction. For Showings Call Marcus - 415.572.0064 or Rachel - 415.225.7743 or Zhane - 702.426.0613 HOA INCLUDES - common area insurance, exterior house painting, exterior grounds maintenance, including landscaping, management, common area electric. Buyer to have their own hazard insurance policy.
appliances__c, Microwave;Disposal;Refrigerator;Freezer
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1984
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-02-03T11:45:37.000+0000
days_on_market__c, 1262
dom__c, 14
ffd_description_pb, Welcome to 32 Blair Terrace, a light filled, three-level single family home conveniently located on the sunny slope of Potrero Hill. Perched on a private, quiet, tree lined street this residence boasts an open concept floor-plan featuring a dining area, view living room and gorgeous, remodeled, designer kitchen with convection oven and new appliances. Dine al fresco off the kitchen, as it opens to your outdoor patio area that is perfect for entertaining, Fido and BBQs. The light filled top floor features 2 spacious bedrooms, with great closet space, 1.25 baths (plenty of room to make it a full bath) and views. A private park for the residents is only a minute away. Moments to the shops and restaurants of the 18th and 24th Street corridors, Mission Bay, DogPatch Street and the new LEED certified developments and parks underway. Easy access to Caltrain, Muni, Downtown, UCSF, Shuttles, Tech Hubs, FWYs and more! Don't miss this opportunity to have it all! No city approval needed!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet
hoa_dues__c, 265
hoa_fee_includes__c, Management,Maintenance Exterior,Maintenance Grounds
pba__hoafees__c, 265
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-12T15:26:04.000+0000
pba__latitude_pb__c, 37.751386
pba__latitude_property__c, 37.751386
laundry_features__c, In Garage;Inside Room;Washer/Dryer Included
listed_date__c, 2019-09-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rachel
pba__listing_agent_lastname__c, Swann
listing_agent_mls_id__c, 807382
ffd_listingagentname, Rachel Swann
listing_agent_number__c, 1016936
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, AGT
listing_office_name__c, The Agency
listing_office_number__c, 27627
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/389289209
pba__longitude_pb__c, -122.399183
pba__lotsize_pb__c, 0
mls_id__c, 493118
main_level__c, Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-02-03
original_price__c, 995000
overall_days_on_market__c, 118
parking__c, Attached,Garage
parking_access__c, Independent
parking_features__c, Attached,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio;Patio(s)
pba__pendingdate__c, 2020-02-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 952.38
pba__propertytype__c, Single Family Residence
id, a0E1I00000QpUOgUAN
roof__c, Shingle
sale_date__c, 2020-03-17
sale_price__c, 1040000
selling_agent_mls_id__c, MLSL155789
selling_agent_number__c, 981186047
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Golden California Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1092
size__c, 1092
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Blair
subdist__c, Potrero Hill
ffd_name, 32 Blair Terrace, San Francisco, CA, 94107
transportation__c, 1 Block
view__c, Garden/Greenbelt;Bay;Water
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
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/358981-1.jpg
ListingId, a0E1I00000QpUOgUAN