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

2246 Harbor Way
Lake Havasu City, AZ 86406
A Team with Coldwell Banker Realty, original listing - (928) 486-9946

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,250,000
Beds: 7
Baths: Full: 4, ¾: 3
Status: Active
SqFt: 5111 Square Feet
Agency: Coldwell Banker Realty
Agency Phone: (928) 486-9946

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Experience elevated desert living in this exceptional 5,111 square foot custom estate, designed with the perfect blend of luxury, functionality, and panoramic lake views. With six spacious bedrooms—including two opulent primary suites and three generously sized junior suites—this residence offers unparalleled comfort and privacy for family and guests alike.<br /> <br /> From the moment you step inside, you're welcomed by an expansive living room filled with natural light, anchored by a cozy fireplace and enhanced with surround sound speakers for a seamless entertainment experience. A dedicated office space offers a quiet retreat for work or creative pursuits, all within the comfort of home.<br /> <br /> At the heart of the home lies a chef's kitchen worthy of the most discerning cook. Outfitted with a top-of-the-line SubZero refrigerator and freezer, dual Wolf ovens, a Wolf cooktop and microwave, and an oversized island, this space is as functional as it is stunning. The breakfast bar invites casual dining and conversation, all framed by sweeping lake views.<br /> <br /> The dual primary suites are a true sanctuary, each featuring spa-inspired bathrooms complete with Jacuzzi tubs, rain showers, and toilets. Mini splits and ceiling fans throughout ensure optimal comfort in every room, while carefully curated finishes add sophistication at every turn.<br /> <br /> Step outside and discover a resort-style oasis. The upper deck is designed for entertaining, with a full outdoor kitchen and built-in BBQ perfect for al fresco dining against a backdrop of the shimmering lake. Take a dip in the pool, unwind on the private lower patio, or simply soak in the serene beauty of your surroundings.<br /> <br /> The home also features a 52-foot boat-deep garage on the lower level, complete with epoxy floors and climate control via mini splitsideal for housing watercraft or toys with care. An additional upper-level garage also features epoxy flooring and temperature control, while a paver driveway and beautifully executed desert landscaping complete the picture of desert elegance.<br /> <br /> This is more than a homeit's a lifestyle. With luxury finishes, unmatched lake views, and thoughtfully designed living spaces both inside and out, this one-of-a-kind property is your personal retreat in the heart of the desert.
MlsNumber: --
ListingId: 1034989


Listing Provided By: Coldwell Banker Realty, original listing
Phone: (928) 486-9946
Office Phone: (928) 486-9946
Agent Name: A Team
Disclaimer: Copyright © 2025 Lake Havasu Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 3137 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;
Real Estate Expert Photo for Rachelle Pattison
Rachelle Pattison
ASCIIRE/MAX by the Lake
Call Today!: (928) 733-0020

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App