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;

2950 Twin Harbors View Drive
Rancho Palos Verdes, CA 90275

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $7,990,000
Beds: 6
Baths: 10
Status: Active
SqFt: 7669
Agency: Keller Williams Palos Verdes Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 22,088 sqft
Property Type: Residential
Year Built: 2005
Notes: Ocean front home prominently situated on a beautiful cul-de-sac street is perched in Los Angeles’ most desirable community. Providing views of the down the coastline of California and Catalina. Originally constructed as the model home for The Estates at Trump National. This home of unparalleled design, comfort, and quality,<br /> emphasizes functionality as well as the luxuries of a quintessential California lifestyle. Featuring spacious interiors and exquisite details, this home is designed to perfectly accommodate resort style oceanfront living. From Viking and Miele appliances to CAT5 wiring, it has been appointed with only the finest of materials and finishes.<br /> Upstairs enjoy the gourmet kitchen, ocean view living room, dining room, wet bar and parlor, as well as dual luxury primary suites with his and her closets, dual shower and fireplaces, library office. Downstairs entertain by way of the wine cellar, game room with billiard, movie theater and two additional bedrooms with suite baths round out this space. Outside you will find a separate suite with bathroom and separate entrance. The backyard seamlessly integrates the indoor-outdoor lifestyle and features with outdoor fireplace and outdoor kitchen, gardens, a Koi Pond with waterfall, spa and pool with ocean and Catalina View.<br /> The Estates at Trump National is located in the beautiful Palos Verdes, adjacent to World Renown 18 HOLE TRUMP NATIONAL GOLF COURSE and the two highly rated restaurants at the clubhouse, with access to the beach, hiking trails, nature preserves nearby, in a great neighborhood with 24-hour security patrol. Too many features to list. Visit this sprawling, sophisticated dream home to experience all it has to offer!
MlsNumber: PV23179089


Listing Provided By: Keller Williams Palos Verdes Realty, original listing
Name: Keller Williams Palos Verdes Realty
Phone: (310) 544-6100
Office Name: Keller Williams Palos Verdes
Office Phone: (310) 544-6100
Agent Name: Yanjing Chu
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