meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327068' 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, 125 Richland Avenue, San Francisco, CA, 94110
ffd_mls_id, 423713959
ffd_salesforce_id, a0E8W00000a8NZ7UAM
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 125 Richland Avenue, San Francisco, CA, 94110
pba__address_pb__c, 125 Richland Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Be advised lower level was completed without the benefit of permits and is not included in the tax records square footage. Floor plan artist measured main level at 1220 sft, lower level 650 sft (1870 sft total). Sellers have a permit to operate the an Airbnb - lower lvl BDR/BA has a private entrance that accesses the bedroom directly. New owner would need to apply for their own Airbnb permit subject to city approval. Buyer to investigate. Explore vertical expansion via the attic. Lots of options! www.BernalHeightsBeauty.com
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1907
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-02-10
ffd_createddate, 2023-02-03T01:48:21.000+0000
days_on_market__c, 167
dom__c, 15
ffd_description_pb, This beautiful reno'd, 2 lvl Edwardian Bernal Heights home w/ a magical backyard is everything! 2 BDRs connect via spiral staircase to a bonus family room and a 3rd BDR downstairs (think guests/Airbnb/au pair), an 87 WalkScore, steps to Holly Park, and a short walk to Cortland's village. Spacious, open living on two levels, and ample space for family, entertaining and more! Light-filled, warm, modern interior. Open living, dining and kitchen spaces flow together, w coved archways, and open to a sun drenched deck and a level, lush, private, low maintenance turf lawn backyard. Spacious, pro kitchen w custom cabinets, marble countertops, stainless appliances, and a Jenn-Air 5 burner range. KIT opens to a sunroom/ office space and leads to the rear deck and verdant garden. Two sumptuous BDRs, a luxe, tiled ensuite bath, California Closets, a standup shower, and a gorgeous soaking tub complete the main level. Downstairs, 2 bonus rooms: the spacious family room, and a private 3rd BDR w a beautiful full, tiled ensuite bath. Laundry space. Warm wood floors throughout. Rare, large Bernal lot at ~2500 sft. Huge garage and driveway pkg. Explore vertical expansion! 1.5 blks to Holly Pk, a short walk to Cortland Avenue's village. Close to tech coaches, public transit, and 101/280. Wow
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-07-13T18:21:32.000+0000
pba__latitude_pb__c, 37.736234
pba__latitude_property__c, 37.736234
listed_date__c, 2022-11-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jessica
pba__listing_agent_lastname__c, Branson
listing_agent_mls_id__c, 805610
ffd_listingagentname, Jessica Branson
listing_agent_number__c, 166015601
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://player.vimeo.com/video/795222797
pba__longitude_pb__c, -122.423859
mls_id__c, 423713959
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-02-02
original_price__c, 1495000
overall_days_on_market__c, -81481
parking_access__c, Independent
parking_features__c, Attached,Garage Facing Front,Interior Access,Other
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-02-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a8NZ7UAM
sale_date__c, 2023-03-03
sale_price__c, 1700000
selling_agent_mls_id__c, 808467
selling_agent_number__c, 1035533
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Richland
subdist__c, Bernal Heights
ffd_name, 125 Richland Avenue, San Francisco, CA, 94110
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/530575216-1.jpg