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-11-11 10:53:21
[post_modified_gmt] => 2024-11-11 18:53:21
[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, 628 San Jose Avenue, San Francisco, CA, 94110
ffd_mls_id, 496447
ffd_salesforce_id, a0E1I00000SMaRiUAL
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 3
address2__c, 628 San Jose Avenue, San Francisco, CA, 94110
pba__address_pb__c, 628 San Jose Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Please visit property website (https://628sanjoseavenue.com/) for 3D tour, photos & floorplan. Call/text Cheryl with any questions: 415-999-3450. Disclosures on DIO. Property is informally managed/run with 2 other owners; shared expenses are paid as needed. There is a square footage discrepancy between tax profile/condo map & prior MLS sale. If it's of interest buyers to verify square footage.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1998
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-04-20
ffd_createddate, 2020-03-23T02:45:45.000+0000
days_on_market__c, 1745
dom__c, 43
ffd_description_pb, Multi-level Townhome with Heart and Soul! This spacious home is in the heart of the Bernal, Noe, Mission corridor. You'll be swept away by views of Sutro Tower, Twin Peaks & Bernal Heights. The interior is equally impressive with top of the line finishes. It's the perfect spot to nest in place. In the spacious great room, enjoy widescreen movie viewing as well as listening to your favorite playlists that will stream via in-ceiling Golden Ear speakers. While you are nesting away, you will appreciate fast download speeds & great internet connectivity with a state of the art Ubiquiti network. The zen master suite offers another area to unwind & enjoy the views. Two car garage & home office. Get ready for serious entertaining once the SIP has been lifted! Easy, walkable access to shops & restaurants. Easy access to tech shuttles, Highways 280/101, BART, SFO, Muni & the J-Church streetcar.
628 San Jose Avenue, San Francisco, CA, 94110 - Property Description
Multi-level Townhome with Heart and Soul! This spacious home is in the heart of the Bernal, Noe, Mission corridor. You'll be swept away by views of Sutro Tower, Twin Peaks & Bernal Heights. The interior is equally impressive with top of the line finishes. It's the perfect spot to nest in place. In the spacious great room, enjoy widescreen movie viewing as well as listening to your favorite playlists that will stream via in-ceiling Golden Ear speakers. While you are nesting away, you will appreciate fast download speeds & great internet connectivity with a state of the art Ubiquiti network. The zen master suite offers another area to unwind & enjoy the views. Two car garage & home office. Get ready for serious entertaining once the SIP has been lifted! Easy, walkable access to shops & restaurants. Easy access to tech shuttles, Highways 280/101, BART, SFO, Muni & the J-Church streetcar.
