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

10023 S Dike Road
Mohave Valley, AZ 86440
Wesley Hassell with KG Keller Williams Arizona Living Realty, original listing - (928) 718-6211

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,900,000
Beds: 5
Baths: Full: 2, ½: 2
Status: Active
SqFt: 4674 Square Feet
Agency: KG Keller Williams Arizona Living Realty
Agency Phone: (928) 718-6211

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: The thoughtfully designed split floor plan layout features a Retreat to the luxurious primary suite, which offers a lavish main bathroom with an oversized double shower, a separate toilet and bidet room, and a two-person jetted tub overlooking the river, generous counter space, and an expansive jaw dropping walk-in closet provides abundant space for all your wardrobe needs! On the other side of this spacious home lays 3 bedrooms, two of which share a jack and Jill bathroom and the other is perfect for a spacious office, gym, or playroom, and don't forget the second en-suite off the living room featuring its own river views and separate bathroom. The heart of the home is a chef s dream kitchen, complete with a glass cooktop, over sized sink, stainless steel double oven, prep sink, two microwaves, spacious pantry, and a Sub-Zero fridge and freezer. The open-concept living area is ideal for hosting gatherings, with ample space and a cozy fireplace adding to the inviting ambiance. The formal dining room is perfect for grand feasts and special occasions. Not to forget the in home roomy laundry room leading to the attached 2 car garage. Additional amenities include a 10-car detached garage with all the space for the toys, RV hook ups, and an attached studio with a full bathroom and stand-up shower. This versatile space can serve as a guest suite, office, or creative area. Enjoy riverfront living with two Private boat ramps, your own floating dock, and a sandy beach at your fingertips. The backyard is perfect for entertaining, with plenty of space for outdoor fun. This exceptional home offers endless possibilities, whether you envision it as a primary residence, vacation retreat, or income producing vacation rental. With its luxurious amenities and prime riverfront location, it truly has everything you could ask for and more. Minutes away from Needles Marina, Jack Smith Marina, Pirates Cove Bar/Restraint/Resort, and Topock66 Marina/Restaurant. Call your personal REALTOR today to explore this remarkable home and make it yours!
MlsNumber: --
ListingId: 017697


Listing Provided By: KG Keller Williams Arizona Living Realty, original listing
Phone: (928) 718-6211
Office Phone: (928) 718-6211
Agent Name: Wesley Hassell
Disclaimer: Copyright © 2024 Western Arizona Realtors Data Exchange. 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 = 101 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;
Real Estate Expert Photo for The JWAY Group
The JWAY Group
ASCIIReal Broker
Call Today!: (208) 297-4234

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App