meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329476' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15717
[post_author] => 4
[post_date] => 2018-11-02 19:54:32
[post_date_gmt] => 2018-11-02 19:54:32
[post_content] => Once a San Francisco skunkworks flying pirate flags filled with humble Victorian cottages owned by ladies who loved ladies and looked forward to long dog walks. Then it gentrified. Silicon Valley stock options splurged on homes here. Dwell magazine arrived next to document the results. While it might be one Bernal, the neighborhood has several distinct geographic vibes and styles. It's not complicated, perhaps recently algorithmically optimized?
[post_title] => Bernal Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bernal-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-05 06:31:31
[post_modified_gmt] => 2022-12-05 14:31:31
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15717
[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, 200 Ellsworth Street, San Francisco, CA, 94110
ffd_mls_id, 423732900
ffd_salesforce_id, a0E8W00000baulgUAA
num_of_rooms__c, 11
of_units__c, 2
address2__c, 200 Ellsworth Street, San Francisco, CA, 94110
pba__address_pb__c, 200 Ellsworth Street, San Francisco, CA, 94110
agent_only_remarks__c, Impeccably kept and VACANT 2-unit corner building in Bernal Heights. Great opportunity for investors, owner-user, purchase partners, or multi-generational living. Garage is tandem for two smaller cars or one larger car. Buyers should measure their cars. Pre-sale escrow open with Kevin Thompson, First American Title Co.
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Range;Free Standing Refrigerator;Varies By Unit
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1909
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-05-03
ffd_createddate, 2023-04-10T10:50:09.000+0000
days_on_market__c, 46
dom__c, 31
ffd_description_pb, VACANT 2-Unit corner building in Bernal Heights. Upper Unit (approx 1,235 SF) is 3BR/1BA. Lower Unit (approx 950 SF) is 2BR/1BA. Beautifully kept with period details and stylish updates, the building is detached on three sides allowing wonderful light to each unit. Classic architecture with wood floors and lovely details including quintessential Bay windows. Stylishly updated, the units are bright and comfortable, both with access to a large patio. UPPER UNIT: three bedrooms, one updated bath, peek-a-boo water views, living room, dining room, large updated kitchen with office, and undeveloped attic space, laundry, storage. The kitchen includes custom cabinetry, Wolf gas range and hood, dishwasher, refrigerator, custom countertops, and recessed lighting. Full bath with double vanity and shower over the tub. LOWER UNIT: two bedrooms, one updated bath, living room with built-in window seat, dining room, large kitchen, laundry, storage. Both units access the spacious patio and basement. Easy to use as a single family home. Detached garage parking for two small cars, tandem. Highly desirable Bernal Heights location just a block from Cortland's amazing shops, restaurants, library, and services and two blocks from Bernal Hill and its stunning panoramic views.
district__c, SF District 9
external_listing__c, 1
pba__floortype_pb__c, Wood;Varies by Unit
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-05-25T10:51:10.000+0000
pba__latitude_pb__c, 37.740268
pba__latitude_property__c, 37.740268
laundry_features__c, In Each Unit;Washer/Dryer Owned
listed_date__c, 2023-04-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Patricia
pba__listing_agent_lastname__c, Lawton
listing_agent_mls_id__c, 800774
ffd_listingagentname, Patricia A Lawton
listing_agent_number__c, 800774
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, 1995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.414743
mls_id__c, 423732900
parkingspaces__c, 2
on_market_date__c, 2023-04-09
original_price__c, 1995000
overall_days_on_market__c, -81547
parking_features__c, Detached,Garage,Garage Door Opener,Tandem Garage
patio_and_porch_features__c, Enclosed Patio;Uncovered Patio
pba__pendingdate__c, 2023-05-10
price_per_square_foot__c, 961.1
pba__propertytype__c, Duplex
ListingId, a0E8W00000baulgUAA
sale_date__c, 2023-05-23
sale_price__c, 2100000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 804279
selling_agent_number__c, 166013787
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Berkshire Hathaway-Franciscan
pba__status__c, Closed
pba__totalarea_pb__c, 2185
size__c, 2185
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Ellsworth
subdist__c, Bernal Heights
ffd_name, 200 Ellsworth Street, San Francisco, CA, 94110
view__c, City;Water;Varies by Unit
website_property_type__c, Duplex
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530601185-1.jpg