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;

27771 Hamiltair Drive
Lake Arrowhead, CA 92352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,899,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3349
Agency: Keller Williams Big Bear Lake Arrowhead

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10,400 sqft
Property Type: Residential
Year Built: 1966
Notes: HAMILTAIR ESTATES LAKEVIEW REDUCED TO SELL THIS SEASON, the only guard gated community with private beaches, launch ramp, 24 hour security, and even a private tennis-pickle ball court for members. This rare architecturally designed home has been updated to reflect a Less is More attitude which enhances the beautiful indoor/outdoor living lifestyle. Water views from almost every room mingle with picturesque tall pines and dog wood trees meandering to rear yard with the illusion of seclusion. Tons of decking front and back, a potting shed, spa, and a lovely potential meditation area will surely put the pause in you. The floor plan is absolutely fabulous with vaulted ceilings, walls of glass, and specialty custom floors and fixtures. An easy to prep and cook kitchen with stainless appliances is adjacent to bar area with ice maker and wine fridge. 4 potential bedrooms with a primary suite on main level, and 2 en-suite guest rooms on upper level offer ultimate comfortable sleeping quarters for all with an additional bonus/family room also a flexible amenity for family media viewing, game playing, or one big slumber party. Additional Office Space, is also a potential bunkroom! The attached garage has electric charge station, a golf cart, and easy access to another sought after feature, your own private dock slip at marina 4! This home is coming turnkey as you see it, furnished per inventory! If you are motivated to bring your toothbrush and not your paint brush, This is it! Lakeside living in Hamiltair is hugely sought after and especially friendly and safe. Offering annual fishing tournaments, BBQ, and even ponies and camels have made holiday memories for all. Please call for details and showings-List agent is also a Hamiltair property owner.
MlsNumber: EV24106306


Listing Provided By: Keller Williams Big Bear Lake Arrowhead, original listing
Name: Keller Williams Big Bear Lake Arrowhead
Phone: (562) 577-9958
Office Name: KELLER WILLIAMS LAKE ARROWHEAD
Office Phone: (909) 359-8030
Agent Name: CINDY STAHL
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