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

122 County Rd N8521
Concho, AZ 85924
Tony Miller with Keller Williams Arizona Realty, original listing - (480) 767-3000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2560 Square Feet
Agency: Keller Williams Arizona Realty
Agency Phone: (480) 767-3000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 42 acre(s)
Property Type: Residential-Other
Year Built: 2006
Notes: Escape to a world of off-grid serenity and self-sufficiency in the breathtaking landscapes of Apache County. Your dream of harmonious living with nature awaits at this remarkable property, a sanctuary where two walipini greenhouses stand as gateways to a bounty of fresh vegetables, fruit trees, and vibrant flora. <br /> Discover the joy of cultivating your own harvest with two sprawling greenhouses13x52 feet for vegetables and a 20x20 haven for fruit trees and a variety of plants. Surrounding these green paradises are numerous outdoor garden beds.<br /> A shimmering jewel on the property is the expansive deep pond, once home to a diverse aquatic community of 4000 fish, including Bluegill, Crappie, Catfish, Mosquito fish, and crayfish. Whether you are fishing in its tranquil waters or simply basking in its beauty, the pond offers a peaceful retreat for reflection and relaxation.<br /> Prepare to embark on a journey of self-reliance with approximately 10 fenced acres featuring no-climb wire, ensuring the safety and security of your cherished animals. Your water needs are met by your private 330' deep well, allowing you the freedom to draw as much water as required for your oasis.<br /> Powering this idyllic retreat is a cutting-edge solar system boasting a 9,450kw solar array, 240v and impressive 1500 ah lithium battery storage. Enjoy year-round comfort with two minisplits for heating and cooling, two LPG heaters, electric central heating, and the cozy ambiance of two woodstoves.<br /> Step inside the welcoming abode where each of the three bedrooms offers the luxury of an attached or private bathroom. Vinyl dual-pane windows provide insulation, while modern amenities such as an electric fridge, dishwasher, high-rise toilets, washer/dryer units, an upright freezer, and a new refrigerator elevate your living experience.<br /> Enhanced with updates including a new shed with insulation for solar equipment and a backup generator, two Conex containers for ample storage, freshly updated flooring in the third bedroom, new fixtures, and a septic tank, this property offers a perfect blend of comfort and sustainability.<br /> Spread over 42 acres of picturesque land, this property invites you to embrace a life where harmony with nature is not just a dream but a reality. Seize the opportunity to experience off-grid living at its finestcall today to schedule your private showing and embark on the journey to your own slice of paradise.
MlsNumber: --
ListingId: 252390


Listing Provided By: Keller Williams Arizona Realty, original listing
Phone: (928) 242-3502
Office Phone: (480) 767-3000
Agent Name: Tony Miller
Disclaimer: Copyright © 2024 White Mountain Association of Realtors. 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