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, 199 Tiffany Avenue #209, San Francisco, CA, 94110
ffd_mls_id, 507662
ffd_salesforce_id, a0E1I00000TjY25UAF
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 33
address2__c, 199 Tiffany Avenue #209, San Francisco, CA, 94110
pba__address_pb__c, 199 Tiffany Avenue #209, San Francisco, CA, 94110
agent_only_remarks__c, Back on market - no fault of seller/property. Newly updated and staged (after 2/12). Call/text LA at 415-349-0592 to schedule showings. Pre-escrow opened w/ Mia McDowell, ORTC.
appliances__c, Dishwasher;Microwave
bath_features__c, Tub w/Shower Over;Shower Stall(s);Jetted Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2004
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-11-28T16:46:12.000+0000
days_on_market__c, 1000
dom__c, 118
ffd_description_pb, Price Improvement! Updated & Staged! This spacious & bright 2BR-2BA condo w/TWO car parking is located at the intersection of the Bernal Heights, Mission, and Noe Valley neighborhoods. The open-concept living room w/ gas fireplace, dining area, an office nook, & kitchen equipped w/ s/s appliances & breakfast bar are perfect for entertaining. Enjoy great lighting throughout the day from the south-facing wall of windows. The unit has 2 large bedrooms located at the back, quiet side of the unit. The main bedroom boasts a spa-like en-suite bath w/ double vanity, marble tiled shower stall and jetted tub. TWO PARKING SPACES, in-unit laundry, and storage closet complete this home. Enjoy some of the warmest weather the City has to offer in the large common courtyard w/ lush landscaping - several separate areas make the space feel like your own private oasis. Easy commute to downtown & the Peninsula; walk to Tech Shuttles, BART, & MUNI, & easy freeway acces
199 Tiffany Avenue #209, San Francisco, CA, 94110 - Property Description
Price Improvement! Updated & Staged! This spacious & bright 2BR-2BA condo w/TWO car parking is located at the intersection of the Bernal Heights, Mission, and Noe Valley neighborhoods. The open-concept living room w/ gas fireplace, dining area, an office nook, & kitchen equipped w/ s/s appliances & breakfast bar are perfect for entertaining. Enjoy great lighting throughout the day from the south-facing wall of windows. The unit has 2 large bedrooms located at the back, quiet side of the unit. The main bedroom boasts a spa-like en-suite bath w/ double vanity, marble tiled shower stall and jetted tub. TWO PARKING SPACES, in-unit laundry, and storage closet complete this home. Enjoy some of the warmest weather the City has to offer in the large common courtyard w/ lush landscaping - several separate areas make the space feel like your own private oasis. Easy commute to downtown & the Peninsula; walk to Tech Shuttles, BART, & MUNI, & easy freeway acces
