meta_query='key:subdist__c;value:Sea Cliff|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338332' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70654
[post_author] => 4
[post_date] => 2018-11-30 20:30:27
[post_date_gmt] => 2018-11-30 20:30:27
[post_content] => No joke, Robin Williams once called the neighborhood home. Sea Cliff is synonymous with stately estates on larger lots. Land's End Park is at your doorstep. Panoramic vistas of the Pacific Ocean, Marin Headlands, and the Golden Gate Bridge.
[post_title] => Sea Cliff
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => sea-cliff
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-22 10:42:58
[post_modified_gmt] => 2023-06-22 17:42:58
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70654
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 710 El Camino del Mar Street, San Francisco, CA, 94121
ffd_mls_id, 423907090
ffd_salesforce_id, a0E8W00000dSNDcUAO
num_of_fireplaces__c, 4
num_of_rooms__c, 12
of_units__c, 0
address2__c, 710 El Camino del Mar Street, San Francisco, CA, 94121
pba__address_pb__c, 710 El Camino del Mar Street, San Francisco, CA, 94121
agent_only_remarks__c, According to the tax records, the lot is approximately 15,000 square feet and is 109 wide by 174 deep by 56 feet; one of the largest usable lots in Sea Cliff. There is a very private, mature garden in front of the house protected by a stucco wall, enhancing the mystique and romance of the home. A side driveway leads down the east side of the property onto an expansive parking pad and the garage entrances. This area can accommodate a number of guest cars and is a perfect basketball/sports court. The garden beyond the parking pad boasts lovely trees and exotic greenery. Even the marine views from this level of the house are mesmerizing.
appliances__c, Dishwasher;Built-In Gas Oven;Ice Maker;Built-In Refrigerator;Gas Cook Top;Built-In Freezer
architectural_style__c, Spanish
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 6
year_build_text__c, 1928
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Georgina McInerney
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-09-12T10:47:13.000+0000
days_on_market__c, 0
dom__c, 0
ffd_description_pb, 710 El Camino del Mar is one of the best-preserved examples of our native'' California architectural styles, reflecting the splendor of a bygone era. Perched on an ocean cove overlooking the wonders of the Bay Area, this is truly one of San Francisco's finest family homes. The main level of the house consists of magnificent public rooms with vaulted ceilings, a family kitchen with a breakfast room adjacent to a lovely dining room with a barrel ceiling. There is also a cozy library, an office, a mud room, and two half-baths. The scale and detail throughout this level of the home are classic Mediterranean, airy, and serene, with amazing views up the Northern Coast, the Marin Headlands, and the Golden Gate Bridge. The upper-level features 6 bedrooms, a grand primary suite, three full baths, and one split bath. There are two enclosed lanai terraces perfect for whale watching, dolphin counting, and observing maritime shipping traffic sailing in and out of the bay. The lower level comprises various flex spaces, storage, and a wine cellar. This area of the house, consisting of approximately 1,800 square feet, can easily be developed into a number of uses. The garage level can accommodate four full-sized cars and has an additional adjacent storage area for various sports equipment.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Front Yard;Full;Metal
fireplace_features__c, Living Room;Family Room;Primary Bedroom
pba__floortype_pb__c, Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-09-13T01:46:40.000+0000
pba__latitude_pb__c, 37.786535
pba__latitude_property__c, 37.786535
laundry_features__c, Upper Floor;Washer Included;Dryer Included
listed_date__c, 2023-09-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Stephen
pba__listing_agent_lastname__c, Gomez
listing_agent_mls_id__c, 163982
ffd_listingagentname, Stephen K Gomez
listing_agent_number__c, 163982
listing_co_agent_mls_id__c, 809013
listing_co_agent_number__c, 1039719
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, 12900000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.490872
lower_level__c, Family Room,Garage
mls_id__c, 423907090
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 4
on_market_date__c, 2023-09-12
original_price__c, 12900000
overall_days_on_market__c, -81703
parking_access__c, Side by Side
parking_features__c, Attached,Covered,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-09-11T11:31:37.000+0000
price_per_square_foot__c, 1882.11
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dSNDcUAO
roof__c, Spanish Tile
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector;Window Security Bars
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, 6854
size__c, 6854
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, El Camino del Mar
subdist__c, Sea Cliff
ffd_name, 710 El Camino del Mar Street, San Francisco, CA, 94121
view__c, Bay;Golden Gate Bridge;Mountains
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1928
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530671742-1.jpg