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;

3158 Crownview Drive
Rancho Palos Verdes, CA 90275

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,150,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 2632
Agency: Palm Realty Boutique

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20,314 sqft
Property Type: Residential
Year Built: 1972
Notes: Beautiful and private gated single story home that offers spectacular 180 degree views from the ocean, harbor, Vincent Thomas Bridge, downtown LA and mountains from nearly every room in the home. This home features over 2,600 sq ft of living spaces and sits on an over 20,000 sq ft lot. The 3 bedrooms, 3 bath home has both a formal living room, family room, formal dining, breakfast nook area, and laundry room. A spacious Master suite enjoys vaulted ceiling and ocean view that opens to a sunny south exposure private patio with a view of the ocean and beautiful hill side. This home features a second master with ocean view and private updated bathroom. The kitchen has beautiful custom wood cabinets, Brazilian granite, Viking range with double oven and a breakfast bar. The ocean and city view family room boasts vaulted ceilings, fireplace, built-in entertainment unit, dry bar and informal eating area which opens to a back yard. The court yard boasts beautiful Spanish tile and fountain that is perfect for entertaining. Ample parking in the newly redone driveway with parking for 4 or more cars plus an oversized 2 car garage. Ultimate entertainers’ backyard with built-in BBQ, sprawling artificial lawn and more amazing views from ocean to downtown LA. There is also an upper patio area that looks over the home with a tranquil feel and more amazing views. Truly a must see!!<br /> * Second house from the street set behind private gate.
MlsNumber: SB23130108


Listing Provided By: Palm Realty Boutique, original listing
Name: Palm Realty Boutique
Phone: (310) 545-2490
Office Name: Palm Realty Boutique, Inc.
Office Phone: (310) 702-6999
Agent Name: Kristen DeLuca
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