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;

21038 S Cheyenne Road
Yucca, AZ 86438

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $777,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3006
Agency: Realty ONE Group Mountain Desert

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2007
Notes: Amazing Ranch Home in Yucca, Arizona, this Desert Stone Ranch off grid, is a spacious 4 bedroom, 3 bathroom home spanning 3006 ft. With an extra room you can make it whatever you would like, Office etc. This Abode features 10-12 foot high ceilings, ceiling fans throughout, concrete stained floors, and a great room with a dual fireplace connecting the kitchen and living room. Safe in home stays. Refrigerator, dishwasher, garbage disposal, Stove-Gas, Microwave and Washer all stays with the home. The kitchen boasts modern appliances, granite countertops, and upgraded doorhandles. The Primary suite offers a walk-in shower and Jacuzzi with dual sinks and a generously sized water closet. Telescopic high-lights in primary closet. Tile in bathrooms and carpet in bedrooms. 3 new water efficient toilets and new faucets throughout the house. A spacious 4-car garage and an ADT alarm system, security and conveniences are top notch. Water sprinklers throughout home. One stand out feature is the owned solar system with movable trackers, valued around $75,000 than a regular solar system. Complemented by 16 new batteries which are 1 1/2 year old and a new inverter, also 20 new solar panels, this system ensures energy efficiency throughout the home. Additional highlights includes a -year old hot water heater and a well that is 3 - 4 years old. The house is equipped with double pane windows and a back up generator. 2 Mini-splits. Lights over windows in garage. Fireplace is gas. Outdoor amenities. Include two patio fans, an outdoor closet and shower, chicken coop, a garden/shed with fruit trees, a solar shed, a large fire pit, 2500 gallon water tank, and 750 gallons propane tanks total. Fencing is around home. The tiled roof is 2007, the home is built with Rofa blocks, which keeps the home naturally cooler by 10 to 15 degrees. Alamo Road is adding additional pavement at least 8 miles. Future could hold more improvements of this well traveled road. ZERO paid for utilities, only what propane you use. All this set on a picturesque 10 acre parcel, this property offers an opportunity to create your own homestead in a safe and serene environment. Absolutely breathtaking views. Zoning is AR/8A Agriculture-Residential-8 acre minumum.
MlsNumber: 007074


Listing Provided By: Realty ONE Group Mountain Desert, original listing
Name: Realty ONE Group Mountain Desert
Phone: (928) 753-0430
Office Name: Realty ONE Group Mountain Desert
Office Phone: (928) 753-0430
Agent Name: Roxann Amundson
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App