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;

9841 S Dike Road
Mohave Valley, AZ 86440

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,250,000
Beds: 6
Baths: 5
Status: Active
SqFt: 4459
Agency: Colorado River Top Producers Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1998
Notes: WELCOME TO 9841 & 9843 S DIKE ROAD!! 1.27 ACRE LUXURIOUS RIVER FRONT RETREAT LOCATED DIRECTLY ON THE SANDY BEACHES OF THE COLORADO RIVER. GARAGES GALORE! THE PARADISE IS MADE UP OF TWO PARCELS WITH SEPARATE CONCRETED BOAT LAUNCHES. ON WELL AND SOLAR FOR LOW UTILITY BILLS. RESORT LIKE LIVING WITH OUTDOOR KITCHEN WITH GRILL, MISTING SYSTEM, SHADY PALAPAS. MAIN HOME FEATURES UPPER LEVEL LIVING WITH GOURMET STYLE KITCHEN WITH GRANITE COUNTERS, BREAKFAST BAR SITTING, CASUAL DINING...ALL WITH AWE INSPIRING VIEWS OF THE RIVER AND MOUNTAINS. SPACIOUS LIVING ROOM WITH FIREPLACE. BALOCONY PATIO IS PARTIALLY ENCLOSED WITH GLASS FOR YEAR ROUND ENJOYMENT WITHOUT BLOCKING YOUR VIEWS. MASTER SUITE HAS LARGE AND HAS FRENCH DOORS TO BALCONY...LARGE WALK IN CLOSET. MASTER BATHROOM BOASTS WALK IN SHOWER, SOAKER TUB, DUAL SINK VANITY. MASTER EN SUITE IS PERFECT FOR SITITNG ROOM, LIBRARY, OFFICE, CRAFT ROOM. TWO GOOD SIZED GUEST BEDROOMS AND FULL GUEST BATH WITH TUB/SHOWER COMBO. BOTTOM LEVEL OF HOME BOASTS FULLY FINISHED GARAGE/ REC/ GAME ROOM WITH WET SINK, BAR SEATING. FAMILY ROOM WITH FRENCH DOORS TO SHADY PATIO AND BEACH. NEW AC UNITS AND SOLAR IS PAID IN FULL. GUEST HOUSE / CASITA WAS JUST REMODLED AND FEATURES QUARTZ COUNTERS, SHAKER CABINETS, STAINLESS APPLIANCES. BIG MASTER SUITE. MASTER BATH HAS WALK IN SHOWER AND JETTED TUB. TWO GUEST BEDROOMS AND FULL GUEST BATH. COULD MAKE A GREAT VACATION RENTAL. MASSIVE 1920 SQ FOOT PULL THROUGH RV GARAGE MEASURES 80' DEEP BY 24' WIDE. FREE STANDING FULL FINISHED 8 CAR GARAGE ALONG WITH ANOTHER 3 CAR GARAGE IS PERFECT FOR ALL YOUR TOYS. PROPERTY HAS TWO WELLS (ONE ON EACH PARCEL) AND HAVE BEEN RECENTLY SERVICED/CHECKED. BLOCK WALL FENCED WITH AUTOMATIC GATED ENTRANCES. SELLERS HAVE SPARED NO EXPENSE UPGRADING AND MAINTAINING...TRULY TOO MANY DETAILS TO MENTION. GOLF CART INCLUDED! COMES FULLY FURNISHED! PARCELS 216-06-258 AND 216-06-259 BEING SOLD TOGETHER! buyer to verify all pertinent info including sq footage, flood zones, utilities, etc.
MlsNumber: 001417


Listing Provided By: Colorado River Top Producers Realty LLC, original listing
Name: Colorado River Top Producers Realty LLC
Phone: (928) 727-5929
Office Name: Colorado River Top Producers Realty, LLC
Office Phone: (928) 704-7033
Agent Name: Lisa Fulton
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 Lois Briesemeister
Lois Briesemeister
ASCIIUS Southwest Real Estate Sales & Leasing
Mobile: (928) 201-0267

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App