Array
(
[ID] => 12175
[post_author] => 4
[post_date] => 2018-10-30 00:43:30
[post_date_gmt] => 2018-10-30 00:43:30
[post_content] => Mention Midtown Terrace to many San Franciscans and you’ll be met with a quizzical gaze. Where is it? What is it? It’s a mid-century neighborhood on the west side of Twin Peaks. Think single-family homes, fully detached, with both front and rear yards, lots of green space, and peace and quiet.
[post_title] => Midtown Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => midtown-terrace-2
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-14 03:45:03
[post_modified_gmt] => 2022-12-14 11:45:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12175
[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 200 Glenview Drive, San Francisco, CA, 94131
ffd_mls_id 423716662
ffd_salesforce_id a0E8W00000a7oQKUAY
num_of_fireplaces__c 1
num_of_rooms__c 6
of_units__c 0
address2__c 200 Glenview Drive, San Francisco, CA, 94131
pba__address_pb__c 200 Glenview Drive, San Francisco, CA, 94131
agent_only_remarks__c Limited Time Offer. Show and Sell NOW. EASY TO SHOW ANY TIME. No public open house. Appt Only. Call agent for garage access code. Please use SFAR Purchase contract. Contact agent for disclosures. Thank you!
appliances__c Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c Tub w/Shower Over;Radiant Heat
pba__fullbathrooms_pb__c 3
pba__bedrooms_pb__c 4
year_build_text__c 1958
pba__city_pb__c San Francisco
listing_co_agent_name__c Declan J Hickey
pba__contingentdate__c 1800-01-01
ffd_createddate 2023-01-20T20:45:58.000+0000
days_on_market__c 2
dom__c 1
ffd_description_pb A newly finished to-the-studs renovation in Midtown Terrace with VIEWS. This full-scale renovation is unveiled to reveal precise attention to every detail; 200 Glenview is a perfect place to call home! Approx 2836 sq feet of new permitted construction, to the studs, just completed. Enjoy 4 beds, 3 full baths on 3 levels. Cozy up in front of a new Blaze gas fireplace with new chimney, while entertaining on this home's upper level, enjoying sweeping panoramic views of Mt. Davidson from new large-scale windows on every level. The sun-filled kitchen highlights: Viking stove, Hood, dishwasher, Bosch refrigerator, Quartz countertops. The modern bathrooms include 2 bathtubs plus a spacious primary suite. So many upgrades such as: Extensive new framing throughout, new plumbing, including waste lines, New electrical, new HVAC - with 3 zones, Underfloor heating in bathrooms and basement level, Insulation on all internal and external walls (typical new build is external only), new roof, new internal gutter system, all seismic work completed to engineering specifications of Eng company Ashley & Vance, new exterior siding on back and side, new stucco finish on front, new entry stairs from ground up, new cedar garden fence and new deck at rear, garden level.
A newly finished to-the-studs renovation in Midtown Terrace with VIEWS. This full-scale renovation is unveiled to reveal precise attention to every detail; 200 Glenview is a perfect place to call home! Approx 2836 sq feet of new permitted construction, to the studs, just completed. Enjoy 4 beds, 3 full baths on 3 levels. Cozy up in front of a new Blaze gas fireplace with new chimney, while entertaining on this home's upper level, enjoying sweeping panoramic views of Mt. Davidson from new large-scale windows on every level. The sun-filled kitchen highlights: Viking stove, Hood, dishwasher, Bosch refrigerator, Quartz countertops. The modern bathrooms include 2 bathtubs plus a spacious primary suite. So many upgrades such as: Extensive new framing throughout, new plumbing, including waste lines, New electrical, new HVAC - with 3 zones, Underfloor heating in bathrooms and basement level, Insulation on all internal and external walls (typical new build is external only), new roof, new internal gutter system, all seismic work completed to engineering specifications of Eng company Ashley & Vance, new exterior siding on back and side, new stucco finish on front, new entry stairs from ground up, new cedar garden fence and new deck at rear, garden level.
