87 Aquavista Way, San Francisco, CA, 94131 - Property Description

_yoast_indexnow_last_ping,1714172686

ffd_listing_title,166 Glenview Drive, San Francisco, CA, 94131

ffd_mls_id,424026828

ffd_salesforce_id,a0EUd000001prkwMAA

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,166 Glenview Drive, San Francisco, CA, 94131

pba__address_pb__c,166 Glenview Drive, San Francisco, CA, 94131

agent_only_remarks__c,Lower primary suite has been staged as a media room.

architectural_style__c,Mid-Century

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1951

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-25T10:47:08.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,On a large, sunny corner of Twin Peaks' south slope, this tastefully updated mid century home offers a quiet retreat. Large windows make the most of the corner lot, drenching the elevated main level in light from three sides and offering peeks of Glen Canyon and the San Bruno Mountains from the rear bedroom. Two additional bedrooms and a fresh bathroom with soaking tub and natural stone tile balance out an open floor plan that makes entertaining easy, with a large kitchen featuring Silestone counters and Viking range, new dishwasher, and access to the yard. The first floor grants the home a great deal of flexibility with a large primary suite that can also double as a media room, guest space or office. It features sliding doors that open to the deep rear yard, covered patio and also has direct access to the street via a garden gate. Both front and rear yards were professionally designed and maintained, and highlight the extra-deep lot, while a long driveway provides easy parking for a second vehicle. Storage, washer and dryer, solar inverter and a Tesla powerwall are tucked into a recently epoxied garage.

district__c,SF District 4

electric__c,Battery Backup,Photovoltaics Third-Party Owned

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-26T22:47:10.000+0000

pba__latitude_pb__c,37.748597

pba__latitude_property__c,37.748597

listed_date__c,2024-02-07

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Ryan

pba__listing_agent_lastname__c,Richard Lenox

listing_agent_mls_id__c,808958

ffd_listingagentname,Ryan Richard Lenox

listing_agent_number__c,1038682

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,1495000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.166Glenview.com

pba__longitude_pb__c,-122.447296

mls_id__c,424026828

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-25

open_house_end__c,2024-04-26T18:00:00.000+0000

open_house_start__c,2024-04-26T17:00:00.000+0000

original_price__c,1495000

overall_days_on_market__c,-81929

parking_access__c,Independent

parking_features__c,Interior Access

parking_type__c,On Site (Single Family Only)

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,986.15

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001prkwMAA

sale_date__c,1800-01-01

sale_price__c,0

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,1516

size__c,1516

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Glenview

subdist__c,Midtown Terrace

ffd_name,166 Glenview Drive, San Francisco, CA, 94131

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1951

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1712660378

ffd_listing_title,39 Gladeview Way, San Francisco, CA, 94131

ffd_mls_id,424022139

ffd_salesforce_id,a0EUd000001flaHMAQ

num_of_fireplaces__c,0

num_of_rooms__c,6

of_units__c,0

address2__c,39 Gladeview Way, San Francisco, CA, 94131

pba__address_pb__c,39 Gladeview Way, San Francisco, CA, 94131

agent_only_remarks__c,Tenant occupied - single person, month to month.

appliances__c,Dishwasher;Disposal;Built-In Gas Range;Built-In Refrigerator

architectural_style__c,Mid-Century

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,0

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-08T01:47:05.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,Best Midtown Terrace location, Mid-Century Modern Architecture, fully detached + large street to street lot. Exceptional views through exceptionally large windows, desirable open floor plan, dreamy wood-burning fireplace, solid oak hardwood floors, ideal gourmet kitchen, two car side-by-side parking and ideal storage space. Excellent opportunity to expand the downstairs area although the home is already spacious. The neighborhood features mid-century modern homes arranged in rows on terraced streets, surrounded by greenbelts, forests, reservoirs, and open space including pretty amazing hiking and biking trails. The land occupied by Midtown Terrace (approximately 150 acres) was once part of Rancho San Miguel, a large 4,400-acre parcel originally granted in 1846 to Don Jose de Jesus Noe, the first mayor of Yerba Buena (the pre-cursor to San Francisco). The land then changed hands several times, with ownership eventually being acquired by Adolph Sutro, a prominent engineer and developer and a San Francisco mayor from 1894 to 1896. To transform its bleak appearance, Adolph Sutro had eucalyptus trees planted on a significant portion of his property, which eventually became Sutro Forest. Midtown Terrace is a rather central San Francisco location.

district__c,SF District 4

entry_level__c,0

exterior_features__c,Fireplace

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

interior_features__c,Storage Area(s)

ffd_lastmodifieddate,2024-04-09T10:48:11.000+0000

pba__latitude_pb__c,37.7508464

pba__latitude_property__c,37.7508464

laundry_features__c,Inside Area

listed_date__c,2024-04-07

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,John

pba__listing_agent_lastname__c,Kirkpatrick

listing_agent_mls_id__c,802848

ffd_listingagentname,John M Kirkpatrick

listing_agent_number__c,802848

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,1395000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4507157

lower_level__c,Bedroom(s),Full Bath(s),Garage

mls_id__c,424022139

main_level__c,Bedroom(s);Kitchen;Dining Room

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-04-07

open_house_end__c,2024-04-14T15:00:00.000+0000

open_house_start__c,2024-04-14T13:00:00.000+0000

original_price__c,1395000

overall_days_on_market__c,-81911

parking_access__c,Side by Side

parking_features__c,Attached,Covered,Enclosed,Garage Door Opener,Interior Access

parking_type__c,On Site (Single Family Only)

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,0

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001flaHMAQ

sale_date__c,1800-01-01

sale_price__c,0

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,0

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Gladeview

subdist__c,Midtown Terrace

ffd_name,39 Gladeview Way, San Francisco, CA, 94131

view__c,Garden/Greenbelt

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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