Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3131 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3131 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3131 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

6224 Ocean Terrace Drive
Rancho Palos Verdes, CA 90275

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $8,400,000
Beds: 7
Baths: 9
Status: Active
SqFt: 7848
Agency: Century 21 On Target

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 22,768 sqft
Property Type: Residential
Year Built: 1989
Notes: 6224 Ocean Terrace Drive…. High on the hills with awe inspiring ocean and Catalina Island vistas… Prestigiously set on a private gated lot within the coveted Sea Crest community of Rancho Palos Verdes on the Palos Verdes Peninsula. This absolutely stunning 7 bedroom, 8 1/2 bath home of Starphire and glass walled architectural intrigue and breathtaking visual freedom is truly a Southern California “Dream Home” blending estate like splendor and relaxed coastal living, complete with a sparkling pool and spa, a gym, TWO separate 2-car garages (for a total of 4 garage spaces) plus a motor court that encircles a dramatic reflection pool, and incredible trifold window walls of imported glass imported specially from Germany affording ocean views “second to none”! You feel the artistic energy and embracing natural warmth… even as you’re crossing the reception bridge above the pool… but especially as you enter through the pivoting door to the grand foyer galleria. A disappearing wall of glass opens the living room to the expansive multilevel ocean view terraces. The exquisite ocean view gourmet kitchen with Viking appliances and a butler pantry enjoys a seamless flow with the amazing fireside family room opening to the hidden garden lagoon pool plaza. All of the bedrooms and bathrooms are tastefully detailed… and the primary suite is “FIVE-STAR” in spaciousness and luxury including a walk-in wardrobe room, a resort-like bathroom with a special steam shower, a separate multi-fixture Shower “room” plus a bidet and a private toilet room. A separate additional recreation/ entertainment room with ensuite could also be guest living quarters. Whether you’re throwing a world class party or wedding celebration… or just watching the sun go down… this is Southern California Coastal living at its best!! Terranea is just down the road… but once you’ve escaped to your own piece of paradise… you won’t want to leave home… on Ocean Terrace Drive… at Sea Crest!
MlsNumber: RS24030316


Listing Provided By: Century 21 On Target, original listing
Name: Century 21 On Target
Phone: (562) 431-2011
Office Name: Century 21 On Target
Office Phone: (562) 431-2011
Agent Name: Raquel Cavanaugh
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App