meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319143' 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, 898 Carolina Street, San Francisco, CA, 94107
ffd_mls_id, 422694542
ffd_salesforce_id, a0E8W00000YZWEPUA5
num_of_rooms__c, 14
of_units__c, 2
address2__c, 898 Carolina Street, San Francisco, CA, 94107
pba__address_pb__c, 898 Carolina Street, San Francisco, CA, 94107
agent_only_remarks__c, Property lives as a true 2 unit building with no internal connection between the units. Connected externally via rear staircase.
appliances__c, Dishwasher;Microwave;Disposal;Electric Cook Top;Wine Refrigerator;Built-In Refrigerator;Built-In Electric Oven;Varies By Unit
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Massimo Loporto
pba__contingentdate__c, 2022-09-26
cooling__c, None
ffd_createddate, 2022-09-14T21:49:48.000+0000
days_on_market__c, 75
dom__c, 40
ffd_description_pb, Ideally located in one of San Francisco's warmest neighborhood, Potrero Hill, 898 Carolina St is a newly renovated 2 unit VIEW property that is a stunning blend of contemporary architecture and modern warmth. Extensively renovated in 2022, this special residence boasts a fabulous main level with an incredible, large walk-out terrace with expansive views. The professional kitchen includes Miele and Thermador appliances, induction cooktop, full-size wine refrigerator, and Mont Blanc quartzite stone. Adjacent to the kitchen and dining area is the living room with multiple seating areas and an attached deck. The top level includes a panoramic view roof deck with views of the bay, Downtown, Twin Peaks, Bernal, and beyond. Main house includes 3 beds, 2 full baths, 2 powder rooms, media room, and 3,835 sqft. The guest house includes 2 beds, 1 bath, and 830 sqft. Add'l features: garden, radiant floor heat in main house, beautiful natural light, and 2 1-car garages.
district__c, SF District 9
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood;Varies by Unit
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant Floor;Central;Varies by Unit
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-10-29T10:49:37.000+0000
pba__latitude_pb__c, 37.757349
pba__latitude_property__c, 37.757349
laundry_features__c, Washer/Dryer Owned;Varies by Unit
listed_date__c, 2022-09-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Frank
pba__listing_agent_lastname__c, Nolan
listing_agent_mls_id__c, 803037
ffd_listingagentname, Frank A Nolan
listing_agent_number__c, 803037
listing_co_agent_mls_id__c, 807921
listing_co_agent_number__c, 1028628
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 4895000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.898carolina.com/
pba__longitude_pb__c, -122.400228
mls_id__c, 422694542
parkingspaces__c, 2
on_market_date__c, 2022-09-14
original_price__c, 4895000
overall_days_on_market__c, -81340
parking_features__c, Garage,Garage Door Opener,Interior Access,Side-by-Side,Varies by Unit
patio_and_porch_features__c, Uncovered Patio;Varies by Unit
pba__pendingdate__c, 2022-10-24
price_per_square_foot__c, 1049.3
pba__propertytype__c, Duplex
ListingId, a0E8W00000YZWEPUA5
sale_date__c, 2022-10-28
sale_price__c, 4895000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 400593
selling_agent_number__c, 1019790
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, 4665
size__c, 4665
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Carolina
subdist__c, Potrero Hill
ffd_name, 898 Carolina Street, San Francisco, CA, 94107
view__c, City;Bay;Downtown;Bay Bridge;San Francisco;Twin Peaks;Hills;Bridges;Varies by Unit
website_property_type__c, Duplex
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530528225-1.jpg