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

28964 Quail Run Court
Lake Arrowhead, CA 92352
STEVE CERECEDES with KELLER WILLIAMS BBLA, original listing - (909) 359-8030

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,725,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4715 Square Feet
Agency: KELLER WILLIAMS BBLA
Agency Phone: (909) 359-8030

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2010
Notes: Stunning LAKEVIEWS from the majority of living areas in this luxury, French Normandy mountain retreat! Full lake rights to private Lake Arrowhead and located in a quiet cul de sac of prestigious Cedar Ridge Estates. First time on market since the sellers contracted locally renowned master craftsman Ron Dolman. Cedar Ridge is the address of choice for those seeking a tranquil gated community, large parcel estates, close proximity to the Lake Arrowhead Village/Lake Arrowhead shoreline, yet tucked away with a feeling of the Pacific Northwest. Built in 2010, this 4715 sq ft, 4 bedroom/4.5 bathroom property rests on 1.4 acres. The spacious office located over the garage has its own private entry and can serve as a 5th bedroom with closet and full bathroom. Boasting an uber functional floorplan with a master en suite on the main living area and elevator spanning all 3 levels! Master craftsmanship and attention to detail throughout, with custom amenities including: massive hand chiseled open beams, soaring cathedral ceiling, hand cut stone fireplaces, Marvin windows & French doors, oversized baseboards & window casings, iron banister spindles, Rohl & Grohe kitchen & bath fixtures, all appliance Viking kitchen with 2 dishwashers and a wine cooler, Shaws Original farmhouse sink, engineered hickory wood flooring, heated stone flooring in master en suite, knotty alder doors everywhere, sound system that can play throughout the house and the main outdoor deck, 50 year presidential composition roof, 2 A/C units, Generac whole house generator, and oversized 3 car garage. Treat your guests to the amazing ALA July 4th fireworks show from the comforts of your home! A large main level deck perfect for BBQs and soothing sunsets shimmering off Lake Arrowhead. Lower level features 3 guest beds/2 baths and a generous sized family room offering a cozy fireplace and full wet bar with refrigerator. This property is ideal for the most discerning of buyers that appreciate high quality real estate within nature’s utmost serenity! Shown by appointment only.
MlsNumber: --
ListingId: RW24120560


Listing Provided By: KELLER WILLIAMS BBLA, original listing
Phone: (909) 228-1015
Office Phone: (909) 359-8030
Agent Name: STEVE CERECEDES
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