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
(
)
)
_yoast_indexnow_last_ping, 1739362679
ffd_listing_title, 199 Tiffany Avenue #211, San Francisco, CA, 94110
ffd_mls_id, 425003657
ffd_salesforce_id, a0EUd0000046cebMAA
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 33
pba__address_pb__c, 199 Tiffany Avenue #211, San Francisco, CA, 94110
address2__c, 199 Tiffany Avenue #211, San Francisco, CA, 94110
agent_only_remarks__c, Home has brand new flooring and new kitchen/laundry appliances. It shows very well. Large SUV fits in garage parking space. There is pending litigation related to cell tower installation on the roof. Roof has been repaired We think qualified buyers can get financing. Pet friendly building. Rentals ok. Ask Laura for details. 415-310-1256. Can show by appointment.
appliances__c, Dishwasher;Microwave;Disposal;Built-In Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Jetted Tub
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 2004
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-01-22T11:48:50.000+0000
days_on_market__c, 21
dom__c, 21
ffd_description_pb, Ideally located on the border of Bernal, Noe Valley & the Mission, this sunny, renovated condo w/new oak wood floors will charm you! Enjoy 2 spacious bedrooms w/new carpeting & large closets and 1 updated bathroom w/jetted soaking tub! The property boasts a wonderful floor plan w/nice separation between the bedrooms and the living space. The spacious, open kitchen/dining room/living room is a fabulous space for entertaining and features a breakfast bar, all brand-new s/s appliances, ample cabinets, granite counters & recessed lighting. This lovely home also enjoys a brand-new in-unit washer/dryer, 1-car garage parking for a large vehicle & shared bike storage. Enjoy the peaceful shared courtyard w/multiple seating areas surrounded by greenery/fruit trees - perfect for relaxing. Elevator building! 199 Tiffany is conveniently situated in a very bike-able & walkable location, boasting a 97 Walk Score! Cafe Seventy8 on the corner & multiple other cafes nearby; Safeway is up the street; Mitchell's ice cream, Four Chairs, Front Porch, Blue Plate & other popular Bernal, Mission & Noe Valley restaurants are within a few blocks! The upper Noe Valley RecCenter/playground is 5 blocks away. Stroll w/your dog up to Bernal Heights Park. Walk to Muni, Bart & tech shuttles. Easy freeway access.
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
fireplace_features__c, Living Room;Decorative Only;Dining Room
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Elevator,Insurance on Structure,Management,Trash,Water
pba__hoafees__c, 814
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Tiffany Gardens Homeowners Association
199 Tiffany Avenue #211, San Francisco, CA, 94110 - Property Description
Ideally located on the border of Bernal, Noe Valley & the Mission, this sunny, renovated condo w/new oak wood floors will charm you! Enjoy 2 spacious bedrooms w/new carpeting & large closets and 1 updated bathroom w/jetted soaking tub! The property boasts a wonderful floor plan w/nice separation between the bedrooms and the living space. The spacious, open kitchen/dining room/living room is a fabulous space for entertaining and features a breakfast bar, all brand-new s/s appliances, ample cabinets, granite counters & recessed lighting. This lovely home also enjoys a brand-new in-unit washer/dryer, 1-car garage parking for a large vehicle & shared bike storage. Enjoy the peaceful shared courtyard w/multiple seating areas surrounded by greenery/fruit trees - perfect for relaxing. Elevator building! 199 Tiffany is conveniently situated in a very bike-able & walkable location, boasting a 97 Walk Score! Cafe Seventy8 on the corner & multiple other cafes nearby; Safeway is up the street; Mitchell's ice cream, Four Chairs, Front Porch, Blue Plate & other popular Bernal, Mission & Noe Valley restaurants are within a few blocks! The upper Noe Valley RecCenter/playground is 5 blocks away. Stroll w/your dog up to Bernal Heights Park. Walk to Muni, Bart & tech shuttles. Easy freeway access.
