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;

609 Grass Valley Road
Lake Arrowhead, CA 92352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $685,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2160 Square Feet
Agency: KELLER WILLIAMS COVINA
Agency Phone: (626) 966-3641

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1981
Notes: Welcome to your dream home in the heart of Lake Arrowhead! This charming two-story residence, built in 1981, offers over 2,000 square feet of living space and is perfect for those who love comfort and style. Featuring 4 spacious bedrooms and 3 bathrooms, this home is designed to accommodate your family's needs. First level is main entry and can be rented separately for extra income. 2nd level has separate entry to the main floor. Main floor boasts Luxurious Grand Antler chandeliers - A must have. Enjoy cozy evenings by the two fireplaces, entertain guests at the built-in bar, or bask in the natural light streaming through the abundant windows. The kitchen nook is perfect for casual meals, while the two decks provide ample space for outdoor relaxation and entertainment. Located minutes from Lake Arrowhead Village, you'll have easy access to a variety of amenities. Spend summer nights enjoying free concerts, Fourth of July fireworks, and an array of water activities including swimming, fishing, and boating on the lake. For the golf enthusiasts, a golf course is just a quarter mile away, and nature lovers will appreciate the nearby hiking trails. The property also boasts two beautiful apple trees, adding a touch of nature to your backyard. During the winter, experience the magic of a white Christmas in this picturesque setting. Restaurants, stores, and shopping are conveniently located in the village, making this home a perfect blend of tranquility and accessibility. Don't miss out on this beautiful and clean home, ready to offer you a perfect blend of comfort, convenience, and natural beauty. Perfect for short term rental! Check with city for short term rental verification. Schedule a viewing today and make this Lake Arrowhead gem your own! Call Fernando 626.388.5518 or Sylvia 909.200.7924
MlsNumber: --
ListingId: CV24099723


Listing Provided By: KELLER WILLIAMS COVINA, original listing
Phone: (626) 388-5518
Office Phone: (626) 966-3641
Agent Name: Fernando Reza
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