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, 936 Esmeralda Avenue, San Francisco, CA, 94110
ffd_mls_id, 422632865
ffd_salesforce_id, a0E8W00000VsuKzUAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 936 Esmeralda Avenue, San Francisco, CA, 94110
pba__address_pb__c, 936 Esmeralda Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Offers will be reviewed Thursday 3/3 at 10am. Schedule showings via Calendly - https://calendly.com/droubiteam/936-esmeralda-st
architectural_style__c, Contemporary;Mid-Century
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1968
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-02-24T17:47:34.000+0000
days_on_market__c, 1041
dom__c, 11
ffd_description_pb, 936 Esmeralda is a one-of-a-kind home, a city retreat where serenity meets functionality. The updated and spacious home is flooded with natural light, has an abundance of indoor and outdoor living space, and is situated on a rare, park-like lot spanning 180 feet deep. The heart of the home overlooks stunning views and features a living room w/a gas fireplace & sliding doors to the walkout deck, and an adjoining dining room opening to a modern kitchen. Down the hall are two bright bedrooms, and two full baths. Upstairs features a sun-filled South-facing deck with views of Bernal Hill, and a spectacular primary bedroom with city views, an en-suite bath, and an outfitted walk-in closet. The home doesn't stop there - the lower level hosts a 4th bedroom (or home office), an en-suite bath, and a family room w/a walkout deck. Slide (there's a slide!) down to the sunny garden w/ a vegetable garden and mature trees. A two-car garage completes the home. You will not see another house like this
936 Esmeralda Avenue, San Francisco, CA, 94110 - Property Description
936 Esmeralda is a one-of-a-kind home, a city retreat where serenity meets functionality. The updated and spacious home is flooded with natural light, has an abundance of indoor and outdoor living space, and is situated on a rare, park-like lot spanning 180 feet deep. The heart of the home overlooks stunning views and features a living room w/a gas fireplace & sliding doors to the walkout deck, and an adjoining dining room opening to a modern kitchen. Down the hall are two bright bedrooms, and two full baths. Upstairs features a sun-filled South-facing deck with views of Bernal Hill, and a spectacular primary bedroom with city views, an en-suite bath, and an outfitted walk-in closet. The home doesn't stop there - the lower level hosts a 4th bedroom (or home office), an en-suite bath, and a family room w/a walkout deck. Slide (there's a slide!) down to the sunny garden w/ a vegetable garden and mature trees. A two-car garage completes the home. You will not see another house like this
