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;

40 County Rd 5064
Concho, AZ 85924
Sean Geary with Realty Executives Arizona Territory, original listing - (928) 537-1145

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $469,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2494 Square Feet
Agency: Realty Executives Arizona Territory
Agency Phone: (928) 537-1145

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1991
Notes: Discover this unique property offering the best of both worlds: a serene, spacious environment with over 2 acres of land and in town. This charming residence is built for efficiency & durability, featuring sturdy concrete walls, a long-lasting metal roof and a owned SOLAR SYSTEM. Designed with both comfort and function in mind, it's an ideal home for those seeking a balance between nature and practicality.<br /> The property is surrounded by mature trees, including several fruit trees, creating a lush, private oasis for your enjoyment. Whether you're a gardening enthusiast or just love the idea of fresh fruit right from your backyard, this space offers plenty of potential to expand on the natural beauty that's already thriving here. Beyond the trees, the expansive lot holds great potential for residential or commercial development, making it a versatile investment opportunity for the future.<br /> Step outside to the large, fenced backyard, perfect for your furry friends to roam safely. Within the yard, you'll find a beautifully designed gazebo, providing a peaceful spot for relaxing, entertaining guests, or enjoying your morning coffee while soaking in the tranquil surroundings.<br /> For those with multiple vehicles or hobbies that require extra storage, the oversized three-car garage is a standout feature. In addition to the garage, there's an attached shed, perfect for tools, lawn equipment, or even a workshop space. And if you love to travel, the RV hookups make this property ideal for RV owners who want the convenience of parking and staying right at home base. Accessibility has been thoughtfully incorporated, with a handicap-accessible ramp through the back porch, ensuring easy entry for all. This home combines practicality, comfort, and a wealth of opportunity with its blend of modern convenience and outdoor space. In addition, bedroom 2 offers its own full bathroom, the primary bedroom offers a sitting area or office (not pictured) and off the living room leads to the Arizona room that has access to the covered patio. Whether you're looking for a peaceful residence, a potential development site, or both, this property is a rare find with endless possibilities.
MlsNumber: --
ListingId: 252930


Listing Provided By: Realty Executives Arizona Territory, original listing
Phone: (480) 220-0127
Office Phone: (928) 537-1145
Agent Name: Sean Geary
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