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

28072 Tefir
Mission Viejo, CA 92692
Lynn Ren with Allison James Estates & Homes, original listing - (760) 448-5600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,380,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3866 Square Feet
Agency: Allison James Estates & Homes
Agency Phone: (760) 448-5600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Welcome to your dream waterfront estate on Lake Mission Viejo! This stunning contemporary home offers luxurious lakefront living with breathtaking water views from most living spaces. Lovingly remodeled over four years, this 3,866 sq ft gem features 5 bedrooms, 4 baths, a powder room, and an oversized attic storage space.<br /> <br /> On the main floor, you'll find a convenient bedroom suite. Upstairs, the master suite boasts a high ceiling, walk-in closet, spacious bathroom, and balcony with spectacular lake views. An adjoining office has been transformed into a second bedroom with its own bathroom and a large deck.<br /> <br /> The formal living room features a tall cathedral ceiling and fireplace. The formal dining room opens to the rear patio and yard. The chef's kitchen is a delight with custom cabinetry, an extra-large granite center island and countertops, seamlessly connected to a spacious family room with custom built-ins, a wine cabinet, and a fireplace. Sliding doors open to a perfect entertainment area in the well-maintained backyard, complete with fruit trees, flowers, and a private boat dock with direct lake access.<br /> <br /> The front entrance has been exquisitely remodeled to create a regal and impressive first impression, featuring stately double doors framed by ornate columns and detailed stonework, all set behind an elegant electric-gated entry that welcomes you home in style and security.<br /> <br /> Two A/C units serve upstairs and downstairs separately. A built-in BBQ station is perfect for parties and entertainment. Limestone flooring on the first floor and hardwood upstairs, including the stairway, add elegance. The home includes a 3-car garage and is part of the Lake Mission Viejo Association, providing access to summer concerts, swimming facilities, boating, and holiday activities.<br /> <br /> If you love the water and dream of a waterfront lifestyle, this is your chance to make it a reality.
MlsNumber: --
ListingId: SW24136656


Listing Provided By: Allison James Estates & Homes, original listing
Phone: (760) 448-5600
Office Phone: (760) 448-5600
Agent Name: Lynn Ren
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