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','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;

301 Riviera Drive
Lake Arrowhead, CA 92352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,895,000
Beds: 6
Baths: 6
Status: Active
SqFt: 4395
Agency: Coldwell Banker Sky Ridge Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8,690 sqft
Property Type: Residential
Year Built: 1989
Notes: Absolutely incredible! The “Arrowhead” home, a true gem, is now available for the first time in almost 25 years and it comes with Lake Rights to Lake Arrowhead—very special. Located in the best part of Lake Arrowhead Country Club, this property boasts the most stunning views right over the ninth tee box and the tenth green. It is phenomenal—really, everyone talks about it. Situated at the end of a very private and quiet cul-de-sac, surrounded by other high-end homes, and guess what? No HOA—no rules, more freedom, you’re going to love it.<br /> <br /> This home features a three-car garage and it’s all level-entry. No steps—just walk right in. Everything you need is on the main floor: an expansive living room with high-beamed ceilings and a beautiful brick fireplace, a kitchen that’s got everything, and a dining area that seats 8-10 easily—perfect for hosting. The master suite? It’s got its own deck, another fireplace, huge walk-in closet, and a luxurious en-suite bathroom.<br /> <br /> Downstairs, there’s a family room set up as a movie projector room—imagine the entertainment! Plus, four large bedrooms, one is even set up as an office now, but easily switches back. The bottom floor is particularly impressive: originally featuring a seventh bedroom, we opened it up to expand the bar area—now it's huge, perfect for hosting the most fantastic gatherings after a round of golf. Additionally, there's a second primary suit on this level with a walk in closet and an en suite bathroom, providing ultimate comfort and privacy.<br /> <br /> We’ve got air conditioning, of course, and a dedicated golf cart area with a direct path to the golf course. And with a generator, you never have to worry about losing power. Folks, this is a rare chance to own one of Lake Arrowhead Country Club’s most talked about homes. It's a fantastic home, in a fantastic location, and it's been taken care of fantastically. Don’t miss out—truly, they don’t make them like this anymore!
MlsNumber: EV24087576


Listing Provided By: Coldwell Banker Sky Ridge Realty, original listing
Name: Coldwell Banker Sky Ridge Realty
Phone: (909) 336-2131
Office Name: COLDWELL BANKER SKY RIDGE RLTY
Office Phone: (909) 336-2131
Agent Name: MEGHAN HARDIN
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