_yoast_indexnow_last_ping,1714611594
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,13
dom__c,13
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-05-02T00:46:58.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
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