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

2932 Skylight Drive
Kingman, AZ 86401

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $739,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2100
Agency: Dirt Road Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 36 acre(s)
Property Type: Residential
Year Built: 2008
Notes: Motivated Seller, Custom Home, FRESH PAINT, Lots of luxuries in the perfect rural setting, 3/2/4 Large home, wrap around deck, lots of patio with a Jacuzzi built into the deck, Patio has Sauna, large fire pit, barbecue kitchen area, gazebo with lights and shades.Huge steel garage with luxurious executive office and very modern alternative communication systems, weather monitoring etc. RV pad w full hookups. Additional Shed on the property for out of the way storage. Stargazers paradise on the top of the hill with unlimited views. Additional covered parking for tractor and a government Humvee, RV hookups. This 2100 sq foot SanteFe home has been significantly upgraded, top of the line custom kitchen and bath cabinets throughout in 2018, built in wine fridge and all appliances incl. Travertine Stone flooring in 2019. Addl patio added in 2019, pavers with concrete installed under the pavers. New Quartz countertops throughout make this a spectacular custom kitchen with a double-sized kitchen island (seats 6 easy). Glass front display cabinets face one of the two living rooms, for beverages, glassware displays etc.. Large laundry/pantry area has storage for those once a month grocery shopping adventures. Property is heated and cooled with a traditional forced air HVAC unit. The property is fenced with an automatic open/close ranch gate. This property has a significant amount of hard surface area all around the home and garage, very unusual for a rural property. Concrete sidewalks, paver patios etc. The views from the property are truly breathtaking, a trip to the top of the hill is a remarkable adventure. The property is very secluded, but only two short miles from the paved I-40. There are water hydrants sprinkled throughout the property. The flagpole has significant lighting so your flags can fly after dark! The large steel garage has a climate controlled safe room within it. There are security cameras and cell repeaters/extenders on the property. UPS, FedEx deliver to this home. USPS at the cluster boxes you pass on the way to the property. Private well is located near the garage. There is real power to the home and the garage with a 22kW backup generator. Addl 36ac property available adjacent to this listed separately. Real power could be extended to the other pad and well could be shared.
MlsNumber: 009688


Listing Provided By: Dirt Road Real Estate, original listing
Name: Dirt Road Real Estate
Phone: (928) 897-1364
Office Name: Dirt Road Real Estate
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.


Local Real Estate Expert

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 = 101 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;
Real Estate Expert Photo for Lois Briesemeister
Lois Briesemeister
ASCIIUS Southwest Real Estate Sales & Leasing
Mobile: (928) 201-0267

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App