meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319243' 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, 3415 Cesar Chavez Street #C, San Francisco, CA, 94110
ffd_mls_id, 422687144
ffd_salesforce_id, a0E8W00000YZJzeUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 4
address2__c, 3415 Cesar Chavez Street #C, San Francisco, CA, 94110
pba__address_pb__c, 3415 Cesar Chavez Street #C, San Francisco, CA, 94110
agent_only_remarks__c, This is a fabulous unit with an incredible roof deck. Evening showings esp powerful around sunset. Text Michael for hosted showings 415.606.2625. Escrow opened with Alethea Benally, ORTC. Disclosures available here: DISCLOSURELINKCOMINGSOON. Seller is a licensed real estate agent.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Electric Range;Gas Plumbed
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1991
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Michael Minson
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-09-09T20:48:17.000+0000
days_on_market__c, 313
dom__c, 32
ffd_description_pb, Fully remodeled, sophisticated, stylish penthouse with exclusive roof deck and views. Spanning the full top floor of a boutique 4-unit building, this completely updated top-floor residence is at the crossroads of Bernal Heights, the Mission and Noe Valley. Enter the unit into a bright, open floor plan with wide-plank hardwood floors and modern lighting. Two bay windows fill the great room with natural light and a breakfast bar is perfect for casual dining and late-nite entertaining. The open kitchen features quartz countertops and high-end, new appliances. Each full bath is beautifully remodeled, with one en-suite to the generously sized primary bedroom. Have epic nights and fabulous days on your private, secluded roof deck with views of Twin Peaks, Bernal Hill and the Bay. Garage includes large, deeded parking space, shared laundry and exclusive use storage. Easy access to commutes, shops, restaurants, 24th St BART station, CPMC Mission Bernal Campus.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Insurance on Structure,Maintenance Exterior
pba__hoafees__c, 281
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T17:36:43.000+0000
pba__latitude_pb__c, 37.747941
pba__latitude_property__c, 37.747941
laundry_features__c, In Garage
listed_date__c, 2022-08-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Danielle
pba__listing_agent_lastname__c, Lazier
listing_agent_mls_id__c, 803117
ffd_listingagentname, Danielle Lazier
listing_agent_number__c, 803117
listing_co_agent_mls_id__c, 808482
listing_co_agent_number__c, 1035858
listing_co_office_mls_id__c, KWADVSF
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 28861
listing_office_mls_id__c, VIVRE
listing_office_name__c, Vivre Real Estate
listing_office_number__c, 28694
pba__listingprice_pb__c, 1298000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.418839
lower_level__c, Dining Room,Kitchen,Living Room
mls_id__c, 422687144
main_level__c, Full Bath(s);Bedroom(s)
master_property__c, a0O1I00000AO1CLUA1
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-09
original_price__c, 1298000
overall_days_on_market__c, -81335
parking_access__c, Independent
parking_features__c, Garage Door Opener,Garage Facing Front,Interior Access,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Roof Deck;Uncovered Deck
pba__pendingdate__c, 2022-10-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 882.56
pba__propertytype__c, Condominium
ListingId, a0E8W00000YZJzeUAH
road_surface_type__c, Paved
roof__c, Bitumen
sale_date__c, 2022-11-04
sale_price__c, 1240000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
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, 1405
size__c, 1405
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Cesar Chavez
subdist__c, Bernal Heights
ffd_name, 3415 Cesar Chavez Street #C, San Francisco, CA, 94110
view__c, City;Panoramic;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Twin Peaks;Hills;Sutro Tower
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Bay Window(s)
pba__yearbuilt_pb__c, 1991
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530521495-1.jpg