meta_query='key:subdist__c;value:Sea Cliff|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330181' 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] => 2018-11-30 20:30:27
[post_modified_gmt] => 2018-11-30 20:30:27
[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, 600 El Camino Del Mar, San Francisco, CA, 94121
ffd_mls_id, 423726269
ffd_salesforce_id, a0E8W00000bFyUsUAK
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 600 El Camino Del Mar, San Francisco, CA, 94121
pba__address_pb__c, 600 El Camino Del Mar, San Francisco, CA, 94121
agent_only_remarks__c, AGENT ONLY Preview Weds 3/15, 4-6pm No Buyer Showings until Monday, 3/20/23 Sprawling estate on over 1/4 Acre! Driveway enters from rear of home, allowing 112' street frontage and sunny entry gardens. Elevator permit was not closed out by contractor (who is no longer in business).
architectural_style__c, Traditional;Tudor
bath_features__c, Jetted Tub;Jack & Jill
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 5
year_build_text__c, 1928
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None,Other,See Remarks
ffd_createddate, 2023-03-20T17:48:06.000+0000
days_on_market__c, 33
dom__c, 24
ffd_description_pb, This spacious 9,390 sqft Tudor home, perched above China Beach in idyllic Sea Cliff, offers stunning ocean views and modern lifestyle amenities. The property features classic 1928 architecture and an inviting courtyard with a manicured garden protected by a privacy wall and mature trees. The main level includes a grand formal entry, stately Great Hall with fireplace, formal dining room, large chef's kitchen, and family lounge with outlooks to the garden. The upper levels boast a generous Primary Suite with Ocean Views and dual baths/dressing rooms, 4 additional bedrooms, and a vaulted-ceiling office/library with fireplace & private balcony overlooking the Ocean. The lower levels offer modern amenities such as a theater, gym with full bath, sauna, and one-of-a-kind indoor pool. The property also includes a gated rear driveway and motor court with 2-car s/s garage and is serviced by a modern elevator to all levels. This home offers the utmost privacy with easy access to everything Sea Cliff and San Francisco offer.
district__c, SF District 1
driveway_sidewalks__c, Gated,Paved Driveway
electric__c, 220 Volts in Laundry
entry_level__c, 0
exterior_features__c, Balcony;Uncovered Courtyard;Entry Gate
external_listing__c, 1
fencing__c, Masonry
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Radiant
interior_features__c, Formal Entry;Storage Area(s);Cathedral Ceiling;Wet Bar;Open Beam Ceiling
ffd_lastmodifieddate, 2023-04-22T00:48:44.000+0000
pba__latitude_pb__c, 37.787053
pba__latitude_property__c, 37.787053
laundry_features__c, Inside Room;Ground Floor;Washer Included;Dryer Included
listed_date__c, 2023-03-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Neal
pba__listing_agent_lastname__c, Ward
listing_agent_mls_id__c, 308772
ffd_listingagentname, Neal A Ward
listing_agent_number__c, 308772
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, 14500000
pba__listingtype__c, Sale
pba__listing_website__c, https://nealwardproperties.com/property/600-el-camino-del-mar/
pba__longitude_pb__c, -122.490056
lower_level__c, Garage,Retreat
mls_id__c, 423726269
main_level__c, Partial Bath(s);Living Room;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Walk-In Closet 2+
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-03-20
original_price__c, 14500000
overall_days_on_market__c, -81527
parking_access__c, Side by Side
parking_features__c, Covered,Enclosed,Garage Door Opener,Garage Facing Rear,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Front Porch
pba__pendingdate__c, 2023-04-13
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-04-21T10:58:00.000+0000
price_per_square_foot__c, 1304.58
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bFyUsUAK
roof__c, Tar/Gravel;Composition;Slate
room_type__c, Office;Living Room;Dining Room;Family Room;Wine Storage Area;Home Theater
sale_date__c, 2023-04-21
sale_price__c, 12250000
security_features__c, Security Gate;Security System Owned
selling_agent_mls_id__c, 807780
selling_agent_number__c, 1027326
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 9390
size__c, 9390
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, El Camino Del Mar
subdist__c, Sea Cliff
ffd_name, 600 El Camino Del Mar, San Francisco, CA, 94121
view__c, Ocean;Panoramic;Garden/Greenbelt;Water
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
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/530590321-1.jpg