111 Middlefield Drive, San Francisco, CA, 94132 - Property Description

_yoast_indexnow_last_ping,1737599001

ffd_listing_title,96 Huntington Drive, San Francisco, CA, 94132

ffd_mls_id,425000249

ffd_salesforce_id,a0EUd0000044c61MAA

num_of_fireplaces__c,0

num_of_rooms__c,9

of_units__c,0

pba__address_pb__c,96 Huntington Drive, San Francisco, CA, 94132

address2__c,96 Huntington Drive, San Francisco, CA, 94132

agent_only_remarks__c,There are NOVs and NOD on the property. Please call/text Peter at 415-606-8210 for more information on the property. Offer date is Monday, 1/27, by 11am. Disclosures: https://app.disclosures.io/link/96-Huntington-Drive-ag78t3o5

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,6

year_build_text__c,1953

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-01-16T23:47:06.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,Fantastic opportunity to own a large and fully detached home in a sought after part of Lakeshore. This 6 bedroom, 4 bathroom home is ready for its new owner. Perfect for a large family or multi-generational living. Large backyard. Conveniently located to shopping and restaurants. Enjoy the great outdoors with Lake Merced and Ocean Beach as your backyard.

district__c,SF District 3

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2025-01-23T01:47:10.000+0000

pba__latitude_pb__c,37.7315527

pba__latitude_property__c,37.7315527

listed_date__c,2025-01-02

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Peter

pba__listing_agent_lastname__c,Tham

listing_agent_mls_id__c,810739

ffd_listingagentname,Peter C Tham

listing_agent_number__c,1047728

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4964504

mls_id__c,425000249

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-01-16

open_house_end__c,2025-01-24T18:00:00.000+0000

open_house_start__c,2025-01-24T16:00:00.000+0000

original_price__c,1598000

overall_days_on_market__c,-82195

parking_access__c,Independent

parking_features__c,Enclosed,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,753.77

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000044c61MAA

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

size__c,2120

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Huntington

subdist__c,Lakeshore

ffd_name,96 Huntington Drive, San Francisco, CA, 94132

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1953

pba__postalcode_pb__c,94132

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1737634676

ffd_listing_title,255 Gellert Drive, San Francisco, CA, 94132

ffd_mls_id,424079592

ffd_salesforce_id,a0EUd000003euRsMAI

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,255 Gellert Drive, San Francisco, CA, 94132

pba__address_pb__c,255 Gellert Drive, San Francisco, CA, 94132

agent_only_remarks__c,NEW PRICE! https://app.disclosures.io/link/255-Gellert-Drive-k2kvbgli Easy to show Call or text Julie at 415-317-2073 Please use ORTC Maria Smith escrow #0216040102. Agent has ownership interest. Credits to buyer agent as well. Great opportunity to acquire brand new construction. Offers as they come.

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,5

year_build_text__c,2024

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-11-20T23:18:06.000+0000

days_on_market__c,70

dom__c,70

ffd_description_pb,Lakeshore Luxury New Construction Detached 5BR/3BA Residence PLUS a 1BR/1BA ADU. The Main home offers a spacious open floor with beautiful oak hardwood floors,9-foot ceilings & Recessed lighting thru out. All-electric chef's kitchen showcases Fisher & Paykel appliances, stunning custom Eclipse cabinetry, gorgeous porcelain countertops & center island. Completing this level are 2 bedrooms, a full bath &laundry closet.Upstairs is a Spacious Primary en-suite,withfree-standing soaking tub, dual vanities, custom walk-in closet & deck. Two additional bedrooms with custom closets, a step out deck & full bath complete this level. This amazing home offers a Large Rooftop deck with Spectacular Lake Merced & Golf Course Views!Perfect for relaxing entertaining or simply taking in the scenery. In addition, a 1BR/1BA ADU (accessory dwelling unit) with Private entrance and separately metered utilities. A Lovely landscaped yard,perfect for extended family, guests or potential income.Fabulous neighborhood Location.Walking distance to many amenities, Lakeshore shopping,Stonestown Gallery, Wholefoods, West Portal. Nearby prominent public & private schools.Enjoy golf at Lake Merced Golf Club or dine at the club house. Close to public transportation and easy freeway access.

district__c,SF District 3

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Heat Pump;Central;MultiZone;Solar w/Backup

ffd_lastmodifieddate,2025-01-23T11:46:39.000+0000

pba__latitude_pb__c,37.7293133

pba__latitude_property__c,37.7293133

laundry_features__c,Laundry Closet;Washer Included;Dryer Included

listed_date__c,2024-11-10

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Julie

pba__listing_agent_lastname__c,Keith

listing_agent_mls_id__c,800437

ffd_listingagentname,Julie M Keith

listing_agent_number__c,800437

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COLD03

listing_office_name__c,Coldwell Banker Realty

listing_office_number__c,875

pba__listingprice_pb__c,2780000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.youtube.com/watch?v=GMu8zlMLGbY

pba__longitude_pb__c,-122.4926986

mls_id__c,424079592

master_bathroom_features__c,Double Sinks;Tile

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-11-14

open_house_end__c,2025-01-25T16:00:00.000+0000

open_house_start__c,2025-01-25T14:00:00.000+0000

original_price__c,2950000

overall_days_on_market__c,-82132

parking_access__c,Independent

parking_features__c,Attached,EV Charging,Garage Door Opener

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Roof Deck

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,2025-01-22T12:41:25.000+0000

price_per_square_foot__c,1009.07

price_reduced__c,1

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000003euRsMAI

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;Secured Access;Security System Prewired;Double Strapped Water Heater

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

size__c,2755

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Gellert

subdist__c,Lakeshore

ffd_name,255 Gellert Drive, San Francisco, CA, 94132

view__c,Golf Course;San Francisco;Lake

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2024

pba__postalcode_pb__c,94132

ffd_media,Array

ffd_media_tags,Array

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