meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214014' 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] => 2024-04-11 08:39:15
[post_modified_gmt] => 2024-04-11 15:39:15
[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, 18 Bonview Street, San Francisco, CA, 94110
ffd_mls_id, 503507
ffd_salesforce_id, a0E1I00000S12piUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 18 Bonview Street, San Francisco, CA, 94110
pba__address_pb__c, 18 Bonview Street, San Francisco, CA, 94110
agent_only_remarks__c, Disclosure package available shortly! Please have your clients view the video before scheduling a showing: https://vimeo.com/445192609 All showings BY APPOINTMENT only and to comply with COVID guidelines. Email completed PEAD form to: [email protected]
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator
architectural_style__c, Cottage
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1907
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-08-13T18:45:25.000+0000
days_on_market__c, 1070
dom__c, 26
ffd_description_pb, Magnificent View home on cul-de-sac situated directly across from Bernal Hill Park. Cute as a button, this 3 bedroom, 2 bathroom home has been refreshed and includes den/office, sunny rear view deck perfect for lounging and admiring the dramatic western skyline. Basement has high ceilings that make it ideal for hobbies or as a game/exercise room. A walkers paradise with score of 93, home is close to shuttles/transit. A great condo alternative!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Carpet;Marble;Simulated Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:31:03.000+0000
pba__latitude_pb__c, 37.7447
pba__latitude_property__c, 37.7447
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-08-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Pat
pba__listing_agent_lastname__c, Patricelli
listing_agent_mls_id__c, 800459
ffd_listingagentname, Pat Patricelli
listing_agent_number__c, 800459
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 1295000
pba__listingtype__c, Sale
pba__listing_website__c, http://BonviewCutie.com
pba__longitude_pb__c, -122.415983
pba__lotsize_pb__c, 0.04
mls_id__c, 503507
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2020-08-13
original_price__c, 1295000
overall_days_on_market__c, 66
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-09-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 883
pba__propertytype__c, Single Family Residence
id, a0E1I00000S12piUAB
roof__c, Composition;Shingle
room_type__c, Laundry;Den
sale_date__c, 2020-10-05
sale_price__c, 1200000
selling_agent_mls_id__c, 400612
selling_agent_name__c, Daniel J. Risman-Jones
selling_agent_number__c, 1023994
selling_co_agent_mls_id__c, 810090
selling_co_agent_name__c, Steven Huang
selling_co_agent_number__c, 1044640
selling_co_office_mls_id__c, ASCEND
selling_co_office_name__c, Ascend Real Estate
selling_co_office_number__c, 27278
selling_office_name__c, Ascend Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1359
size__c, 1359
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bonview
subdist__c, Bernal Heights
ffd_name, 18 Bonview Street, San Francisco, CA, 94110
transportation__c, 4+ Blocks
view__c, City Lights;Bay;Twin Peaks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1907
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/368265-1.jpg
ListingId, a0E1I00000S12piUAB