meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='236432' 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, 3133 Folsom Street, San Francisco, CA, 94110
ffd_mls_id, 422648534
ffd_salesforce_id, a0E8W00000WhIDaUAN
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 9
address2__c, 3133 Folsom Street, San Francisco, CA, 94110
pba__address_pb__c, 3133 Folsom Street, San Francisco, CA, 94110
agent_only_remarks__c, Buyer will need to deposit two months worth of HOA dues + property taxes (aka. "regular monthly assessment") for their unit. Please confirm with Title & Buyers lender. Please use latest SFAR PC with TIC Addendum & Contingency Removal Form, and include PoF, Pre-Approval letter and Signed DP with offer.
appliances__c, Dishwasher;Gas Water Heater;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Tile;Closet
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1909
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-04-27
ffd_createddate, 2022-04-15T17:46:31.000+0000
days_on_market__c, 460
dom__c, 28
ffd_description_pb, Precita Park classic Edwardian elegance & vintage charm meets modern comfort residence. Super cute bay windowed flat w stunning downtown views exactly where you want to be in Bernal's prime North Slope! Top flr, light-filled residence, quite possibly the finest home in this established TIC building. Desirable open Liv/Din/Kit experience-all garnished w superb dwntwn SF views -24/7! Large rooms w all the allure of trad. architecture, like gorgeous orig. H/W flrs, wainscoting, dramatic hi ceilings, period details, lux retro light fixtures & more! Modern upgrades incl. new dble-paned windows, recessed lighting & in-unit W/D. Large mod Kit w island, & Bath, extol a fresh alluring aesthetic, complimented by new fixtures, sinks, hardware, quartz & granite cntrs. Convenient utility room/WFH Off, & dappled arbor outlooks from the private king-sized primary Bedrm are a rare find! Palatial sunny common back yard patio & huge private storage. Convenient to Tech shuttles, BART, MUNI & Hwy access!
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Insurance,Sewer,Trash,Water
pba__hoafees__c, 440
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-06-10T10:50:51.000+0000
pba__latitude_pb__c, 37.7477833
pba__latitude_property__c, 37.7477833
laundry_features__c, Inside Area;Washer Included;Dryer Included
listed_date__c, 2022-03-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Shelley
pba__listing_agent_lastname__c, Trew
listing_agent_mls_id__c, 802542
ffd_listingagentname, Shelley D Trew
listing_agent_number__c, 802542
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 895000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/699579269
pba__longitude_pb__c, -122.4136
mls_id__c, 422648534
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-04-15
original_price__c, 895000
overall_days_on_market__c, -81188
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2022-05-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-06-09T13:52:21.000+0000
price_per_square_foot__c, 1060.61
pba__propertytype__c, Tenancy In Common
id, a0E8W00000WhIDaUAN
room_type__c, Storage;Office;Laundry;Den;Kitchen;Living Room;Dining Room;Great Room
sale_date__c, 2022-05-31
sale_price__c, 980000
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
selling_co_agent_mls_id__c, 666666
selling_co_agent_number__c, 666666
selling_co_office_mls_id__c, NMSS
selling_co_office_name__c, Compass
selling_co_office_number__c, 2691
selling_office_name__c, Copass
pba__status__c, Closed
pba__totalarea_pb__c, 924
size__c, 924
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Folsom
subdist__c, Bernal Heights
ffd_name, 3133 Folsom Street, San Francisco, CA, 94110
view__c, City;Downtown;San Francisco
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Full;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/530438670-1.jpg
ListingId, a0E8W00000WhIDaUAN