452 Corbett Avenue, San Francisco, CA, 94114 - Property Description

_yoast_indexnow_last_ping,1713581827

ffd_listing_title,150 Glenbrook Avenue, San Francisco, CA, 94114

ffd_mls_id,424018017

ffd_salesforce_id,a0EUd000001mNszMAE

num_of_fireplaces__c,2

num_of_rooms__c,0

of_units__c,0

address2__c,150 Glenbrook Avenue, San Francisco, CA, 94114

pba__address_pb__c,150 Glenbrook Avenue, San Francisco, CA, 94114

agent_only_remarks__c,By Appointment Only. Escrow open with Michelle Patterson at WFG National Title Insurance Company. Home is shown by appointment only. Please call Frank Nolan for more information or to preview home. Buyer to verify sqft. Full inspections on file in disclosure package. Small fee for private 24/7 neighborhood security patrol.

appliances__c,Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Built-In Gas Range;Tankless Water Heater;Built-In Gas Oven;Built-In BBQ;Wine Refrigerator;Built-In Refrigerator;Plumbed For Ice Maker;Gas Plumbed

architectural_style__c,Modern/High Tech

bath_features__c,Tub;Low-Flow Toilet(s);Dual Flush Toilet;Stone

pba__fullbathrooms_pb__c,6

pba__bedrooms_pb__c,6

year_build_text__c,2018

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Room Air,See Remarks

ffd_createddate,2024-04-18T21:47:37.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,150 Glenbrook Avenue is an architectural masterpiece located on the peak of the Clarendon Heights neighborhood that showcases an exclusive collection of homes at the highest point above sea level in San Francisco. The home was designed by the famed John Maniscalco Architecture firm in 2018 and built by Cook Construction with gardens by Terra Ferma Landscapes Design. This six bedroom, six full and two half bath, four level residence set on a 5,721 square foot lot captures the most powerful and commanding views of the entire city from bridge to bridge and everything in between. The homes open floor plan with floor to ceiling windows on all levels allows the full grandeur of its setting to be realized through the world class vistas it looks upon. The residence is complete with four en-suite bedrooms on the upper level, multiple panoramic view terraces, a guest suite with private entrance, steam room, cedar sauna, two additional large entertaining rooms with immediate access to the mature garden with firepit and an outdoor spa.

district__c,SF District 5

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

electric__c,220 Volts,Battery Backup,Photovoltaics Seller Owned,See Remarks

entry_level__c,0

exterior_features__c,Balcony;Fire Pit

external_listing__c,1

fencing__c,Back Yard;Wood;Fenced;Full;Other

fireplace_features__c,Living Room;Gas Piped;Family Room

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,2

pba__heatingtype_pb__c,Radiant Floor

interior_features__c,Formal Entry

ffd_lastmodifieddate,2024-04-20T02:47:11.000+0000

pba__latitude_pb__c,37.7569466

pba__latitude_property__c,37.7569466

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2024-03-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Frank

pba__listing_agent_lastname__c,Nolan

listing_agent_mls_id__c,803037

ffd_listingagentname,Frank A Nolan

listing_agent_number__c,803037

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,VANG02

listing_office_name__c,Vanguard Properties

listing_office_number__c,166013449

pba__listingprice_pb__c,19950000

pba__listingtype__c,Sale

pba__listing_website__c,http://GlenbrookView.com

pba__longitude_pb__c,-122.4510857

lower_level__c,Full Bath(s),Retreat

mls_id__c,424018017

main_level__c,Partial Bath(s);Kitchen;Garage;Living Room;Dining Room;Family Room;Street Entrance

master_bathroom_features__c,Shower Stall(s);Low-Flow Toilet(s);Double Sinks;Tile;Soaking Tub;Low-Flow Shower(s);Radiant Heat;Dual Flush Toilet

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-04-18

open_house_end__c,2024-04-23T14:00:00.000+0000

open_house_start__c,2024-04-23T12:00:00.000+0000

original_price__c,19950000

overall_days_on_market__c,-81922

parking_access__c,Side by Side

parking_features__c,EV Charging,Garage Door Opener,Interior Access,Side-by-Side

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Roof Deck;Uncovered Deck;Enclosed Patio;Uncovered Patio

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,2681.45

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001mNszMAE

roof__c,Bitumen

room_type__c,Office;Library;Guest Quarters;Dining Room;Family Room;Great Room;Wine Storage Area;Temp Controlled Room;Primary Bedroom;Primary Bedroom 2+

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Fire Alarm;Fire Suppression System;Carbon Mon Detector;Video System;Security System Owned;Security Patrol

selling_agent_number__c,0

selling_co_agent_number__c,0

selling_co_office_number__c,0

pba__status__c,Active

pba__totalarea_pb__c,7440

size__c,7440

spa__c,1

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,Glenbrook

subdist__c,Clarendon Heights

ffd_name,150 Glenbrook Avenue, San Francisco, CA, 94114

view__c,City;Panoramic;City Lights;Bay;Bay Bridge;San Francisco;Golden Gate Bridge;Mt Diablo;Mt Tamalpais;Bridges

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Low E Glass Partial

pba__yearbuilt_pb__c,2018

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530751333-1.jpg