meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209403' 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] => 2018-11-02 19:54:27
[post_modified_gmt] => 2018-11-02 19:54:27
[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, 863 Carolina Street, San Francisco, CA, 94121
ffd_mls_id, 484550
ffd_salesforce_id, a0E1I0000084vXwUAI
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 863 Carolina Street, San Francisco, CA, 94121
pba__address_pb__c, 863 Carolina Street, San Francisco, CA, 94121
agent_only_remarks__c, Ready to build! SF Planning Dept approved plans.
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2019-05-06T16:46:53.000+0000
days_on_market__c, 1263
dom__c, 240
ffd_description_pb, San Francisco Planning Department approved and zoned for 4,451 square feet, 4 floors, 4 bedrooms, 4 full baths, a 2-car garage and a private elevator to each floor. The plans include a rarely approved entitlement to build one level above the neighboring structures and a permit to demolish the existing shack. Sutro Architects' design for a luxurious two-unit building at 863 Carolina Street incorporates 360-degree views of the San Francisco skyline from all four levels. Sutro is the go-to architecture firm lauded for distinctive residential and commercial projects from San Francisco to wine country. For this project the team capitalized on the views as well as the sunny Potrero Hill location by adding a spacious light well, ideal for a living wall. Potrero Hill offers not only the best weather in San Francisco but also quick and easy access to I-280, I-80, I-101, and Caltrain. Neighbors include Chase Center (the new Warriors stadium), Mission Rock, Oracle Park, Pier 70, and UCSF Med Ctr
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-12T15:23:37.000+0000
pba__latitude_pb__c, 37.7577428
pba__latitude_property__c, 37.7577428
listed_date__c, 2019-05-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Anne
pba__listing_agent_lastname__c, Laury
listing_agent_mls_id__c, 810542
ffd_listingagentname, Anne Laury
listing_agent_number__c, 1046806
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 2088000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/291265732
pba__longitude_pb__c, -122.3996602
pba__lotsize_pb__c, 0.06
mls_id__c, 484550
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2019-05-06
original_price__c, 2500000
overall_days_on_market__c, 366
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-01-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 443.72
pba__propertytype__c, Single Family Residence
id, a0E1I0000084vXwUAI
sale_date__c, 2020-03-03
sale_price__c, 1975000
selling_agent_mls_id__c, 814249
selling_agent_name__c, Samantha Villatoro
selling_agent_number__c, 1065399
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Zephyr Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 4451
size__c, 4451
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Carolina
subdist__c, Potrero Hill
ffd_name, 863 Carolina Street, San Francisco, CA, 94121
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/349900-1.jpg
ListingId, a0E1I0000084vXwUAI