Title Page Background
DEBUG FN args: Array ( [0] => 195 [1] => [2] => [3] => agent ) BEFORE: Site: 195 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 195 Igate: njhud LocID: 195 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 195 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 195 [1] => [2] => [3] => lender ) BEFORE: Site: 195 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 195 Igate: njhud LocID: 195 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 195 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 195 [1] => [2] => [3] => other ) BEFORE: Site: 195 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 195 Igate: njhud LocID: 195 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 195 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

6650 Evan Hewes Hwy
Winterhaven, CA 92283
DOUGLAS MITCHELL with MITCHELL REALTY CO., original listing - (909) 896-9205

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $12,500,000
Beds: 10
Baths: Full: 7, ½: 4, ¾: 1
Status: Active
SqFt: 11792 Square Feet
Agency: MITCHELL REALTY CO.
Agency Phone: (909) 896-9205

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 401 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: An adventure lover’s paradise that merges high-octane thrills with luxurious comforts. Incredible 400-acre Dune Ranch featuring private runways, hangars, a half-mile racetrack, multiple sand cars, tractors, and more. The fully furnished 8,144 sq. ft. main house includes a 2,100 sq. ft. game room (games included—see photos) plus an attached 1,223 sq. ft. casita. The main house has a 3-car attached garage and an additional 2,034 sq. ft. garage stocked with ten Polaris RZR RS1s (all included). A private bungalow building offers two fully furnished 1-bedroom/1-bath units and a 2,432 sq. ft. garage filled with kid-size Razors, quads, and riding gear(all included). A 2,316 sq. ft. caretaker’s home with a large carport is also on-site.<br /> You’ll find 13 High Performance Sand Cars (all included except the 57 chevy car not included) housed in a 7,115 sq. ft. garage with an attached 3,461 sq. ft. covered carport. There’s more: a 7,200 sq. ft. shop, a 3,240 sq. ft. man cave, a 4,800 sq. ft. hangar, and a 13,700 sq. ft. container building. Numerous tractors (Caterpillar, Massey, John Deere, Case, etc.), water trucks, Kubota utility vehicles, Kawasaki Mules, and other equipment are included (some items excluded in pictures). Water is supplied by Two 350 GPM wells. The property comprises multiple parcels, offering direct access to the Glamis dunes. Perfect for corporate retreats or large gatherings with Friends/Families. For a tour or a complete list of included items, contact Dug Mitchell Realty Co Covina Calif
MlsNumber: --
ListingId: CV25025492


Listing Provided By: MITCHELL REALTY CO., original listing
Phone: (909) 896-9205
Office Phone: (909) 896-9205
Agent Name: DOUGLAS MITCHELL
Disclaimer: Copyright © 2025 California Regional Multiple Listing Service, Inc. 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