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

28441 Teal Drive
Lake Arrowhead, CA 92352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,325,000
Beds: 3
Baths: 4
Status: Pending
SqFt: 2620
Agency: RE/MAX Lakeside

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13,040 sqft
Property Type: Residential
Year Built: 2005
Notes: This amazing listing has it all! Perfect location that is easy walking distance to Tavern Bay Beach Club on private Lake Arrowhead, level lot, abundant parking, and custom touches inside and out. Built by local craftsman and contractor, Matt Brule, and lovingly maintained by it's original owners, this estate will take your breath away from the moment you pull up. A covered front porch welcomes you, then inside the front door the dramatic high ceilings, log beams, huge windows and floor to ceiling stone fireplace will capture your attention. Custom materials were brought in to make this home truly one-of-a-kind. The kitchen is any chef's dream with its huge island, large pantry, abundant cabinet space, and top of the line appliances. There's even a pot filler over the stove for convenience! The main floor of the home holds the luxurious master suite as well, featuring a huge walk in closet, fireplace and beautiful bathroom with jetted tub and walk in shower. Upstairs is a family room with fireplace and two additional bedrooms, each with their own private en-suite bathroom. The lowest level of the home has a large game room/tv room/office to utilize as you choose. An extra special feature of the home is the storage room for the most crafty owner to feel completely organized. The three car attached garage will hold all your toys safely inside and there's additional parking for your guests too. If the power goes out, an automatic generator will kick in to keep things running smoothly. The special location of the home provides a sunny yard and seasonal stream in back. It is located in Arrowhead Woods, providing lake rights. The Tavern Bay neighborhood is quiet, friendly and serene. This special home is unparalleled in quality and ambiance. Do not miss it on your next tour of Lake Arrowhead homes!
MlsNumber: EV24061732


Listing Provided By: RE/MAX Lakeside, original listing
Name: RE/MAX Lakeside
Phone: (909) 307-5665
Office Name: RE/MAX LAKESIDE
Office Phone: (909) 337-9999
Agent Name: AMY SHARROW
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