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;

4661 S Lindero Drive
Fort Mohave, AZ 86426

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $595,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2100
Agency: Colorado River Top Producers Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: AN OASIS IN THE DESERT! SPECTACULAR 3 BEDROOM, 3 BATH CUSTOM HOME NESTLED ON AN 18,731 SQUARE FOOT DOUBLE LOT. LOCATED IN THE UPSCALE AND DESIRABLE GATED COMMUNITY IN THE VILLAS AT DESERT HORIZON 55+ COMMUNITY. THIS IMMACULATE HOME FEATURES FULL SOLAR (PAID FOR), BACK UP BATTERY THAT COVERS 100% OF THE ELECTRIC BILL. METICULOUSLY MAINTAINED WITH UPGRADES GALORE! WALK THROUGH YOUR PRIVATE COURTYARD INTO THE MAIN ENTRACE OF THE HOME AND BE GREETED WITH AN OPEN FLOOR PLAN FEATURING UPGRADED PORCELIAN TILE, 9' CEILINGS, PLANTATION SHUTTERS, CAN LIGHTING, UPGRADED CEILING FANS. GOURMET STYLE KITCHEN WITH STAINLESS STEEL APPLIANCES, BEAUTIFUL GRANITE COUNTERS, CHERRY WOOD CABINETS. CENTER ISLAND WITH VEGETABLE SINK, AS WELL AS BREAKFAST BAR DINING. CASUAL DINING AREA WITH PICTURE PERFECT WINDOWS. GIANT WALK-IN PANTRY WITH DEDICATED PLUG FOR A FREEZER. IMPRESSIVE GREAT ROOM WITH SLIDING GLASS DOORS TO BACK COVERED PATIO. OVER-SIZED PRIMARY SUITE CAN ACCOMMODATE EVEN THE LARGEST OF BEDROOM FURNISHINGS. PRIMARY BATHROOM BOASTS AMAZING WALK-IN TILED SHOWER, DUAL SINK VANITY. LARGE LINEN AND WALK-IN CLOSET IS PERFECT TO KEEP YOU ORGAINIZED! SPLIT FLOOR PLAN FOR PRIVACY WITH TWO LARGE GUEST BEDROOMS AND FULL GUEST BATH WITH TUB/SHOWER COMBO. HUGE BONUS ROOM WITH TONS OF STORAGE CABINETS COULD DOUBLE AS AN OFFICE, DEN, EXERCISE ROOM, OR HOBBY ROOM. LAUNDRY ROOM WITH SINK. TWO GARAGES WITH EXPOY FLOORS, FOUR CARS EACH, WITH 8' INSULATED GARAGE DOORS, BOTH AIR CONDITIONED. GARAGE ONE IS 35' DEEP WITH BOTH 110 & 220 VOLT OUTLETS, HALF BATH, AND WOOD BURNING STOVE FOR FUN! SECOND GARAGE MEASURES 39' DEEP WITH 40 AMP OUTLET FOR CHARGING ELECTRIC VEHICLES PLUS 400 AMP SERVICE. RV PARKING WITH BIG DOUBLE GATE...FULL RV HOOK-UPS WITH 50 AMP SERVICE, WATER, AND SEWER DUMP. AMAZING PARK-LIKE BACKYARD THAT SITS ON A SEPARATE BUILDABLE LOT. RELAX UNDER YOUR SHADY COVERED BACK PATIO AND ENJOY THE RESORT-LIKE FEEL RIGHT AT HOME. SELLERS HAVE SPARED NO EXPENSE WHEN BUILDING AND HAVE UPGRADED THE INSULATION, ADDED AN ON-DEMAND WATER HEATER, WATER SOFTENER, SECURITY CAMERAS. ALL CONCRETE WORK HAS BEEN STEEL REINFORCED AND SEALED TO PROTECT FROM THE ELIMENTS. FULL BLOCK WALL. 3 SEPARATE A/C & HEAT PUMP UNITS. TOO MANY DETAILS TO LIST SO VISIT THIS GORGEOUS HOME AND COME APPRECIATE ALL IT HAS TO OFFER! COMMUNITY ALSO FEATURES CLUBHOUSE AND POOL FOR YOUR ENJOYMENT!
MlsNumber: 012920


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