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

515 Jones Dr
Lake Havasu City, AZ 86406

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,150,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2975
Agency: Keller Williams Arizona Living Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: Nestled within the Residential Estate neighborhood, this exquisite property is being offered for the first time and is a must see! This home boasts 4 bedrooms and 3 baths, offering a turnkey haven of sophistication and comfort. Features include a spacious living area, with a grand fireplace that sets the tone for cozy gatherings. The gourmet kitchen is equipped with top-of-the-line Wolf, Viking, and Subzero appliances and is the perfect set-up for the chef in your family. You will also find granite countertops and knotty alder cabinets and doors throughout the home. The main suite is a haven of indulgence, featuring its own fireplace, Jacuzzi tub, walk-in shower, and dual sinks. The garage has plenty of room for all the toys with 1,861 square feet, epoxy floors, central air, and ample storage for all your needs. Embrace outdoor living at its finest with the expansive backyard oasis, complete with lake views, a sparkling pebble tech pool, spa, open-air casita, fireplace, built-in BBQ, and keg cooler. You will fall in love! Positioned in a highly coveted location, this home offers an unparalleled lifestyle of luxury and refinement.<br /> Additional features include: 3 AC units, heated pool, and a large side yard. The smooth finish stucco, paver driveway and landscaped front yard with water features add a touch of sophistication to this stunning home. <br /> <br /> Safe will not convey. Coke machine in garage will not convey. Seller intends to participate in a 1031 exchange with the sale of this property.
MlsNumber: 1030202


Listing Provided By: Keller Williams Arizona Living Realty, original listing
Name: Keller Williams Arizona Living Realty
Phone: (928) 453-6111
Office Name: Keller Williams Arizona Living Realty
Office Phone: (928) 453-6111
Agent Name: Camilla Deville
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App