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 = 3132 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 = 3132 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 = 3132 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;

8524 La Sierra Avenue
Whittier, CA 90605
Joann Luft with Coldwell Banker Alliance, original listing - (562) 945-2221

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,999,999
Beds: 5
Baths: Full: 2, ½: 1, ¾: 2
Status: Active
SqFt: 7272 Square Feet
Agency: Coldwell Banker Alliance
Agency Phone: (562) 945-2221

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: This traditional Spanish Style Estate is nestled in the heart of Friendly Hills. Behind private gates, this gem is like coming home to you own private resort. It is surrounded by luxury lush green lawns, social spaces and relaxed retreats. It showcases the finest features. It has been built with exquisite materials and craftmanship. The entry has a domed ceiling, hand painted, custom iron and glass door, beautiful light fixtures and the floor has porcelain medallion. It features 10 ft.ceilings, solid wood 8 ft. doors, base boards and crown molding, Italian Monocibec porcelain floors, and beautiful arches on the main floor. It has 5 bedrooms and 5 1/2 baths.The main suite is private with a tray ceiling with mood lighting,walk-in-closet balcony, bath has jacuzzi tub, arched custom shower, natural stone and dual sinks .2nd ensuite has walk-in-closetThe living area with living room and dining room has an open floor plan with wood beams and hand painted niche. A separate family room has a stone fireplace, builtins, wood blinds and the windows over look the rose garden. The gourmet island kitchen has top-of-the-line stainless steel appliances with a Viking 8 burner stove that has 2 ovens one full and 1/2. Also has Viking hood, a wall oven, Viking double refrigerator and a bronze pot filler. It has wonderful custom made knotty elder wood cabinets with Brazilian granite.The office has Pella double doors and wood blinds. The spiral staircase is travertine with wrought iron railing and custom curved wood paneling. It leads to the bar/pool table room with curved bar and Mexican ceramic sink and has a balcony. Other features includes 3 full ac/heating units and 2 mini split units, recessed lighting, intercom, ceiling fanes, over sized windows,
MlsNumber: --
ListingId: PW24111907


Listing Provided By: Coldwell Banker Alliance, original listing
Phone: (562) 577-9961
Office Phone: (562) 945-2221
Agent Name: Joann Luft
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