Array
(
[ID] => 15605
[post_author] => 4
[post_date] => 2018-11-02 02:30:48
[post_date_gmt] => 2018-11-02 02:30:48
[post_content] => Once dismissed as 'south of Noe Valley,' Glen Park is now embraced and adored for an I-280 on-ramp to Silicon Valley and a BART station to everywhere else. Start your day with coffee at a not-a-corporate-copycat coffeehouse in the heart of the village, stroll on to the neighborhood public library branch and then off for a hike/jog/bike/climb through Glen Canyon Park? Yes you can in Glen Park.
[post_title] => Glen Park
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => glen-park-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 13:53:22
[post_modified_gmt] => 2024-03-19 20:53:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15605
[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, 2400 Diamond Street, San Francisco, CA, 94131
ffd_mls_id, 421548125
ffd_salesforce_id, a0E1I00000UTVOFUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 2400 Diamond Street, San Francisco, CA, 94131
pba__address_pb__c, 2400 Diamond Street, San Francisco, CA, 94131
agent_only_remarks__c, Schedule a private showing: https://calendly.com/team-brannigan/botanicaloasis?month=2021-05 Please send the PEAD to [email protected] or sign the PSI upon arrival at the property. No ShowingTime reservations will be considered. For photos and virtual tours, please visit BotanicalOasisSF.com. Disclosures available by 5/22, please email for disclosures.
appliances__c, Dishwasher;Built-In Gas Range;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c, Mid-Century
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1946
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Silvia Zeng
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-05-21T01:48:45.000+0000
days_on_market__c, 790
dom__c, 9
ffd_description_pb, Striking, manicured grounds surround this stunning detached 3BD/3BA home, fenced and landmarked by a stately Redwood which highlights the front courtyard. Rhododendrons, Camelias, and Azaleas color the 5,000+ sqft lot, adding ambiance and privacy while the Mock Oranges add fragrance in the sun. Wisterias, Japanese Maples, many fountains & Ipe decks accent the garden and soothe the soul. The hot tub faces the twinkling city lights & views of the Southern hills. The open floor plan and open beam ceilings are mesmerizing. Floors with radiant heat, a gas fireplace, an adjacent deck, and large windows bring in nature and serenity to the main living area. The comfortable bedrooms are a tranquil resting place. 2-car side-by-side garage + a storage basement below add convenience and workspace. 1/2 Mile to Glen Park Station + Village as well as Glen Canyon Park. Inspiration sparks from every corner of the interior + exterior of this special home!
2400 Diamond Street, San Francisco, CA, 94131 - Property Description
Striking, manicured grounds surround this stunning detached 3BD/3BA home, fenced and landmarked by a stately Redwood which highlights the front courtyard. Rhododendrons, Camelias, and Azaleas color the 5,000+ sqft lot, adding ambiance and privacy while the Mock Oranges add fragrance in the sun. Wisterias, Japanese Maples, many fountains & Ipe decks accent the garden and soothe the soul. The hot tub faces the twinkling city lights & views of the Southern hills. The open floor plan and open beam ceilings are mesmerizing. Floors with radiant heat, a gas fireplace, an adjacent deck, and large windows bring in nature and serenity to the main living area. The comfortable bedrooms are a tranquil resting place. 2-car side-by-side garage + a storage basement below add convenience and workspace. 1/2 Mile to Glen Park Station + Village as well as Glen Canyon Park. Inspiration sparks from every corner of the interior + exterior of this special home!
