meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216618' 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, 414 Bosworth #A, San Francisco, CA, 94112
ffd_mls_id, 512111
ffd_salesforce_id, a0E1I00000TvazAUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 414 Bosworth #A, San Francisco, CA, 94112
pba__address_pb__c, 414 Bosworth #A, San Francisco, CA, 94112
agent_only_remarks__c, Transparent pricing; offers as they come. Tremendous value! Contact Listing Agent for COVID compliant showings Full disclosure package with home and pest inspection reports available via Disclosures.io- request from LA. Pre-escrow open with Elisabeth Davis, Fidelity National Title Company, Market St. Many of the photos on the MLS are virtually staged with photos directly after of a vacant unit.
appliances__c, Dishwasher;Disposal;Hood Over Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Tile;Dual Flush Toilet;Jetted Tub;Granite
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2011
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-01-31
ffd_createddate, 2021-01-19T19:45:38.000+0000
days_on_market__c, 912
dom__c, 49
ffd_description_pb, Amazing value & an unbelievably spacious home (perfect for SIP!) in a wonderful Bernal/Glen Park neighborhood. Close to all of the fantastic neighborhood amenities of both! $537 per sq. foot on a 2 level condo (feels like a single family home!) that was newly constructed in 2011. Main level: large light-filled living room, 1/2 bath, & spacious open kitchen/dining/family room w/ gas fireplace- perfect for entertaining! Gourmet kitchen: large island (equipped for seating), gas range, & ample storage/pantry. Walk out to a lovely, private landscaped back yard. Upper level: Consists of a huge main bedroom suite, a 2nd bedroom suite, & a 3rd bedroom and hall bath. There are balconies off of the 2 back bedrooms and there are wonderful views from main bedroom suite! Laundry room on this floor as well. 1 car garage parking w/ interior access. Just blocks to the Glen Park BART station, Glen Park Village, local restaurants, grocery stores, public library, nearby parks, freeways & so much more!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped;Family Room
pba__floor__c, 0
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_dues__c, 288
pba__hoafees__c, 288
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 414 Bosworth HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:42:42.000+0000
pba__latitude_pb__c, 37.733300953178
pba__latitude_property__c, 37.733300953178
laundry_appliances__c, Washer/Dryer,In Laundry Room
laundry_features__c, Inside Room
listed_date__c, 2021-01-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Eric
pba__listing_agent_lastname__c, Rahe
listing_agent_mls_id__c, 806789
ffd_listingagentname, Eric T Rahe
listing_agent_number__c, 166017619
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, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.414abosworth.com
pba__longitude_pb__c, -122.43078024465
pba__lotsize_pb__c, 0
mls_id__c, 512111
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Tub
master_property__c, a0O1I000004VXwFUAW
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-01-18
original_price__c, 1495000
overall_days_on_market__c, 174
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Enclosed Patio
pba__pendingdate__c, 2021-03-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 554.76
pba__propertytype__c, Condominium
id, a0E1I00000TvazAUAR
room_type__c, Laundry
sale_date__c, 2021-03-17
sale_price__c, 1545000
selling_agent_mls_id__c, 806076
selling_agent_number__c, 166016242
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Farrell Real Estate Investments
pba__status__c, Closed
pba__totalarea_pb__c, 2785
size__c, 2785
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bosworth
subdist__c, Bernal Heights
ffd_name, 414 Bosworth #A, San Francisco, CA, 94112
transportation__c, 1 Block
unit_number__c, A
view__c, City Lights;Garden/Greenbelt;Hills
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2011
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/375839-1.jpg
ListingId, a0E1I00000TvazAUAR