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] => 2021-12-01 18:49:28
[post_modified_gmt] => 2021-12-02 02:49:28
[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
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E8W00000Wif9LUAR
pba__address_pb__c 257 Crescent Avenue, San Francisco, CA, 94110
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 3
pba__bedrooms_pb__c 4
days_on_market__c 53
mls_id__c 422656198
pba__totalarea_pb__c 2734
pba__latitude_pb__c 37.7351967
pba__longitude_pb__c -122.4192053
pba__state_pb__c CA
pba__status__c Closed
pba__street_pb__c Crescent
listed_date__c 2022-05-06
sale_date__c 2022-06-21
pba__propertytype__c Single Family Residence
pba__listingprice_pb__c 1995000
pba__listingtype__c Sale
sale_price__c 2510000
address2__c 257 Crescent Avenue, San Francisco, CA, 94110
pba__listing_agent_firstname__c Jeffrey
pba__listing_agent_lastname__c Salgado
view__c City Lights;Hills
pba__halfbathrooms_pb__c 0
parkingspaces__c 2
pba__postalcode_pb__c 94110
year_build_text__c 1906
size__c 2734
subdist__c Bernal Heights
listing_agent_mls_id__c 805001
selling_agent_mls_id__c 804736
listing_co_office_number__c 0
listing_office_number__c 28751
listing_office_name__c Compass
listing_office_mls_id__c COMP7
of_units__c 0
district__c SF District 9
selling_co_office_name__c Vanguard Properties
selling_co_agent_mls_id__c 817103
selling_co_office_mls_id__c VANG02
selling_agent_number__c 166014407
selling_co_agent_number__c 1076005
selling_co_office_number__c 166013449
overall_days_on_market__c -81209
dom__c 23
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 918.07
selling_office_name__c Vanguard Properties
parking_type__c On Site (Single Family Only)
original_price__c 1995000
agent_only_remarks__c The disclosure packet is accessible on homelight/IO and here is the link: https://app.disclosures.io/link/257-Crescent-Avenue-dwn3v7h0 Please email the listing agent to schedule appointments and follow advised health safety protocols.
Fabulous four-bedroom, three-bath fully remodeled home with the winning combination of modern flair, warmth, fine details and an ideal Bernal Heights location! Behind the contemporary faade is an inviting entryway that unfolds to a dramatic open living space, gorgeous floors, dining area, and a spectacular gourmet eat-in kitchen with high-end appliances and tastefully appointed designer finishes all awash with natural light. The main level has two bedrooms, one with a skylight and the other that overlooks the garden, a bathroom, and a conveniently located laundry area. The upper-level leads to a majestic master bedroom suite complete with a balcony, captivating views, skylights, walk-in closets, and a luxurious bathroom with spa-like finishes. There is a fourth bedroom, bathroom, storage room, and entertainment room that continues the tenor of luxury and warmth on the bottom level. A garage with car charger, and interior access completes this special home that is close to everything!
