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;

14995 E Page Road
Wikieup, AZ 85360
Elise Harron with Dirt Road Real Estate, original listing - (928) 897-1364

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $422,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1408 Square Feet
Agency: Dirt Road Real Estate
Agency Phone: (928) 897-1364

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Lushly landscaped resort quality get-a-way or full time serene residence. 3bd 2bath home with 1b 1b guest house suite/bunk house; both residential units have covered patios with landscape exterior. 2 car garage with workshop, lots of additional covered parking. complete functional butcher shop on property - can be converted to additional living space. Main house is extremely well constructed custom home with large rooms, with a wood stove in the great room for added warmth, literally and figuratively. The house has a new Roof. Large windows in every room bring the outdoor in. Covered patios around most of the home adds many square foot of very inviting outdoor livable area. The stone barbecue area and the pit cooking area are located along the patio for ease of use. The shooting deck off the back of the house can be used by the gun enthusiasts or by the bird watchers - it is a very inviting area. Bunk house/guest house is tiny, cute and private self sufficient space, separated from the house by a short walk. There is a small corral behind it that was used by the butcher shop but can have other uses as well. The butcher shop is a professionally set up operation which was routinely inspected by the state of Arizona and was a permitted business in this area. The sellers ran a very well respected shop, not only just in this area but in Northern Arizona in general! This 16+ acre paradise has real power, a very good well (recently replaced), a bird watching or skeet shooting deck on the back of the home, a pit barbecue and a rock barbecue on the property nestled in the landscaping surrounding the home. The property is located less than 1mile off of signal road which is a county maintained road. Easy access from Signal road, 17mile Road, Chicken Springs Rd or Alamo Road all county maintained roadways. 2 hours from Phoenix, 3 hours from Las Vegas, 3 hours from Flagstaff. A 90minute trip to Kingman is your closest shopping, 10miles of gravel 70 minutes of pavement. The landscape on this property is unlike any property I have seen in the rural areas of northern Mohave County ever! The specimen perfect landscaping reminds me of the grounds in and around the Hyatt Regency in Scottsdale or the place they called the Bluffs- the efforts to create this look and feel are monumental and you will only understand once you see and feel this property.
MlsNumber: --
ListingId: 020334


Listing Provided By: Dirt Road Real Estate, original listing
Phone: (702) 806-9990
Office Phone: (928) 897-1364
Agent Name: Elise Harron
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