238 28th Avenue, San Francisco, CA, 94121 - Property Description

_yoast_indexnow_last_ping,1725976322

ffd_listing_title,540 El Camino Del Mar Street, San Francisco, CA, 94121

ffd_mls_id,424062136

ffd_salesforce_id,a0EUd0000034762MAA

num_of_fireplaces__c,3

num_of_rooms__c,20

of_units__c,0

address2__c,540 El Camino Del Mar Street, San Francisco, CA, 94121

pba__address_pb__c,540 El Camino Del Mar Street, San Francisco, CA, 94121

agent_only_remarks__c,For additional information or questions, please text or call Steven at (415)999-1113

appliances__c,Dishwasher;Gas Water Heater;Free Standing Gas Oven;Ice Maker;Built-In Refrigerator;Gas Cook Top;Gas Plumbed

architectural_style__c,Mediterranean;See Remarks

bath_features__c,Shower Stall(s);Tub;Window;Jack & Jill;Steam

pba__fullbathrooms_pb__c,5

pba__bedrooms_pb__c,6

year_build_text__c,1926

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-09-09T19:48:58.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Magnificently positioned on San Francisco's western edge, 540 El Camino Del Mar offers an extraordinary blend of prominence, privacy, and utility. Situated on a flat and level corner parcel measuring 17,149 sq.ft. (per tax records), the fully walled and gated 1926 Italian Renaissance Villa majestically spans 10,961 sq. ft.(per draftsperson), boasting approximately 20+ rooms spread across three floors, including a secure 4+ car garage behind the estate's gates. Combining aesthetic beauty with grandeur and prestige, vast dramatic views stretch from the mouth of the Pacific Ocean to the Marin Headlands, the San Francisco Bay, the Golden Gate Bridge, to the cliffs and beaches of Park Presidio. Multiple indoor/outdoor living vignettes and the surrounding enchanting gardens complement the city's Mediterranean climate, providing both formal and casual entertaining opportunities for year round gatherings. This is one of San Francisco's most remarkable estate properties designed by celebrated architect, Earle B. Bertz, one that truly balances period elegance and luxurious scale with modern sensibilities, joy and playfulness. And after more than three decades of loving stewardship, it is now ready for its next chapter of devotion, happiness, celebrations and dreams.

district__c,SF District 1

driveway_sidewalks__c,Gated,Paved Driveway,Paved Sidewalk

entry_level__c,0

exterior_features__c,Balcony;Uncovered Courtyard;Entry Gate

external_listing__c,1

fencing__c,Fenced;Full

fireplace_features__c,Living Room;Wood Burning;Gas Piped;Family Room;Gas Log

pba__floortype_pb__c,Carpet;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,3

pba__heatingtype_pb__c,Radiant

interior_features__c,Formal Entry;Storage Area(s);Wet Bar

ffd_lastmodifieddate,2024-09-10T13:47:26.000+0000

pba__latitude_pb__c,37.7878757

pba__latitude_property__c,37.7878757

laundry_features__c,Inside Room;Inside Area;Washer Included;Dryer Included;Cabinets;Sink;Chute

listed_date__c,2024-09-02

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Steven

pba__listing_agent_lastname__c,Mavromihalis

listing_agent_mls_id__c,197832

ffd_listingagentname,Steven Mavromihalis

listing_agent_number__c,197832

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

pba__listingtype__c,Sale

pba__listing_website__c,http://www.540ElCaminoDelMar.com/

pba__longitude_pb__c,-122.4894001

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

mls_id__c,424062136

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

master_bathroom_features__c,Shower Stall(s);Tub;Double Sinks;Bidet;Walk-In Closet;Jetted Tub

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,4

on_market_date__c,2024-09-09

open_house_end__c,2024-09-10T13:00:00.000+0000

open_house_start__c,2024-09-10T11:00:00.000+0000

original_price__c,20000000

overall_days_on_market__c,-82066

parking_access__c,Side by Side

parking_features__c,Attached,Garage Door Opener,Garage Facing Rear,Interior Access,Side-by-Side,Tandem Garage

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Back Porch;Uncovered Deck;Uncovered Patio;Covered 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,1824.65

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000034762MAA

road_surface_type__c,Paved

roof__c,Tile

room_type__c,Storage;Office;Kitchen;Library;Living Room;Guest Quarters;Dining Room;Family Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security Gate;Security System Owned

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

size__c,10961

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,El Camino Del Mar

subdist__c,Sea Cliff

ffd_name,540 El Camino Del Mar Street, San Francisco, CA, 94121

view__c,Ocean;Bay;Water;Golden Gate Bridge

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1926

pba__postalcode_pb__c,94121

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726224939

ffd_listing_title,54 Sea View Terrace, San Francisco, CA, 94121

ffd_mls_id,424060532

ffd_salesforce_id,a0EUd0000030VyAMAU

num_of_fireplaces__c,0

num_of_rooms__c,12

of_units__c,0

address2__c,54 Sea View Terrace, San Francisco, CA, 94121

pba__address_pb__c,54 Sea View Terrace, San Francisco, CA, 94121

pba__fullbathrooms_pb__c,6

pba__bedrooms_pb__c,6

year_build_text__c,1926

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Elizabeth M Roeder

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-02T18:46:40.000+0000

days_on_market__c,11

dom__c,11

ffd_description_pb,Video Preview! On the top of the southern ridge of Sea Cliff, near Lands End, The Legion of Honor and Lincoln Park Golf Course with privacy and panoramic views of the Golden Gate is 54 Seaview Terrace. On a wide lot, built in 1926 and completely rebuilt in 2018 on a new foundation this spacious 6 bedroom home is turn-key with air conditioning. Pass the lush front garden up brick stairs to the enclosed front porch​. Enter​ into the central foyer. Elevator, powder room​ and gourmet kitchen​. The Open Dining Room has the view, and leads to the den where it gets better​. The living room with a fireplace looks over the Richmond Up the stair are 4 bedrooms with bath on suite:​ 2 rooms on the front of the house​, a great central living area with beautiful City outlooks, laundry room​, a bedroom suite in the center with the view, and the elevated Primary suite has a breathtaking view of our Golden Gate​. ​Stairs lead down to a large bedroom suite on the front​. The middle bedroom shown as a gym has a steam shower and an office. The huge family room opens to the rear yard terrace on the roof of the garage​. The garage with interior access, and parking pad are accessed from the alley off of 30th Avenue.

district__c,SF District 1

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2024-09-13T10:46:56.000+0000

pba__latitude_pb__c,37.7845134

pba__latitude_property__c,37.7845134

listed_date__c,2024-08-27

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Ted

pba__listing_agent_lastname__c,Bartlett

listing_agent_mls_id__c,801003

ffd_listingagentname,Ted Bartlett

listing_agent_number__c,801003

listing_co_agent_mls_id__c,814230

listing_co_agent_number__c,1065271

listing_co_office_mls_id__c,COMP50

listing_co_office_name__c,Compass

listing_co_office_number__c,28741

listing_office_mls_id__c,COMP50

listing_office_name__c,Compass

listing_office_number__c,28741

pba__listingprice_pb__c,7900000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.bartlettre.com/property/54-Sea-View-Terrace-San-Francisco-Sea-Cliff-223

pba__longitude_pb__c,-122.4914343

mls_id__c,424060532

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-02

open_house_end__c,2024-09-15T16:00:00.000+0000

open_house_start__c,2024-09-15T14:00:00.000+0000

original_price__c,7900000

overall_days_on_market__c,-82059

parking_access__c,Side by Side

parking_features__c,Attached

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000030VyAMAU

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

size__c,5389

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Sea View

subdist__c,Sea Cliff

ffd_name,54 Sea View Terrace, San Francisco, CA, 94121

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1926

pba__postalcode_pb__c,94121

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726537967

ffd_listing_title,226 El Camino Del Mar, San Francisco, CA, 94121

ffd_mls_id,424046324

ffd_salesforce_id,a0EUd000002fZS7MAM

num_of_fireplaces__c,1

num_of_rooms__c,10

of_units__c,0

address2__c,226 El Camino Del Mar, San Francisco, CA, 94121

pba__address_pb__c,226 El Camino Del Mar, San Francisco, CA, 94121

agent_only_remarks__c,SELLERS want action. On Supra. Show and sell please. Easy to show. Any other question, please call/text Listing, Winnie Fok 650.208.9391. Disclosures at https://app.disclosures.io/link/226-El-Camino-Del-Mar-yg59srfp

appliances__c,Dishwasher;Microwave;Built-In Gas Oven;Wine Refrigerator;Built-In Refrigerator

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,1907

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-07-25T19:48:18.000+0000

days_on_market__c,53

dom__c,53

ffd_description_pb,Home with a view! BEST VALUE in Seacliff! The sellers have meticulously maintained and updated this beautiful home since owning this property. The property features a 3+ bd, 3.5 ba, 3,200 sf, sprawling home on El Camino Del Mar in the Seacliff neighborhood. It's one of the rare properties that has bridge views available on all three levels. The top floor incl an oversized ensuite with a walk-in closet. Across from the ensuite, there is an awe-inspiring space with a small wine bar and a wood-burning fireplace. You will be mesmerized by the serene view of the Pacific Ocean coming into the bay and the overwhelming proximity to the Golden Gate Bridge. This has always been a private retreat for the owners and their friends; however, new owners may convert this to be your dream top floor oasis with some adjustments. The main level features a living room, dining room, and kitchen. Of course, you can enjoy the views from any of these areas. A newly remodeled ensuite is located at the front of the property, with a half bath in the foyer for guest use. The lower level is completed with a bedroom, great room, full bath, and a walk-out patio to the manicured backyard. You are next to Baker Beach, Presidio National Park, and have access to lots of nearby transportation

district__c,SF District 1

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fireplace_features__c,Wood Burning

pba__floortype_pb__c,Bamboo;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-09-17T01:47:08.000+0000

pba__latitude_pb__c,37.7877757

pba__latitude_property__c,37.7877757

laundry_features__c,Washer/Dryer Stacked Included

listed_date__c,2024-04-27

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Winnie

pba__listing_agent_lastname__c,Fok

listing_agent_mls_id__c,802330

ffd_listingagentname,Winnie W Fok

listing_agent_number__c,802330

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,STHB4

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,28397

pba__listingprice_pb__c,4495000

pba__listingtype__c,Sale

pba__listing_website__c,https://226elcaminodelmar.com/

pba__longitude_pb__c,-122.4858052

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

mls_id__c,424046324

main_level__c,Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-07-25

open_house_end__c,2024-09-17T16:00:00.000+0000

open_house_start__c,2024-09-17T09:00:00.000+0000

original_price__c,4995000

overall_days_on_market__c,-82020

parking_access__c,Side by Side

parking_features__c,Garage Door Opener

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Back Porch;Covered Patio

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,2024-09-12T17:07:04.000+0000

price_per_square_foot__c,1376.72

price_reduced__c,1

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000002fZS7MAM

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

size__c,3265

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,El Camino Del Mar

subdist__c,Sea Cliff

ffd_name,226 El Camino Del Mar, San Francisco, CA, 94121

view__c,Ocean;City;Bay;Golden Gate Bridge;Bridges

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1907

pba__postalcode_pb__c,94121

ffd_media,Array

ffd_media_tags,Array

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