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;

4612 E Desert Trail
Kingman, AZ 86401

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $769,000
Beds: 5
Baths: 3
Status: Active
SqFt: 3455
Agency: RE/MAX Prestige Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential
Year Built: 2000
Notes: Spectacular Sante Fe-Style, With A 2nd Finished Detached Garage (36x30) While Resting On Nearly 8 ACRES With Stunning Views In Every Direction, While Just Moments From Town-All Paved Roads. This Property Is Located On A Private Paved Street With It's Own Private Well. You Will Definitely Want To Check Out The RESORT-STYLE Backyard With A Spacious Covered Patio, Outdoor Custom Shade Screens, Built-In Large BBQ With A Side Burner, Flagstone/Tile Porch, And A Wood Burning Fireplace. There Are Several French Drains Installed Throughout The Property. The Front Has An Enclosed Courtyard With Tiled Walkways Entry And Side Gates. Inside You Will Notice A Nice Sized Entry Foyer, Hugh Storage Closet Underneath the Staircase, Inviting Living Room With A Beehive Fireplace, With Cedar Ceilings, Hand Carved Pine Vigus, Custom Hickory Cabinets, Doors, Staircase, And Baseboards. The Primary Suite Is Located Downstairs & Features A Beehive Fireplace, An Enormous Closet With Shelving, Drawers, Shoe Storage And Doors To Your Own Private Resort. The Primary Bathroom Has A 2 Person Jacuzzi Tub, Separate Shower, & Dual Sinks. There Is Another Bedroom Located Downstairs With A Large Walk-In Closet-Could Be Used For A Media/Hobby Room. The Kitchen Was Updated In 2014 With Kitchen Aid Appliances, Granite Countertops', Pot/Pan Drawers, Lazy Susan, Pull Out Shelving & Temperature Controlled Built-In Wine Holder. Room Off The Kitchen Can Be A TV Room. The Laundry Room Has A Built-In Ironing Board, Lots Of Cabinets; The Washer & Dryer Stay! Upstairs Includes A Cozy Library Nook/Sitting Area, Plus 3 Upstairs Bedrooms: One With An Ensuite Bathroom That Has Dual Sinks. There Are 2 Porches Upstairs-One Enclosed That Over Looks The Back Yard, The Other Faces The Front Yard It's Covered With The Tiled Roof. The Home Has A Newer Water Heater (Oct 22). 3 HVAC Units, 2-Which Were Just Installed Dec 22 . The Attached Garage Has Built In Cabinets and A Utility Sink. The Detached Garage 36x30 Fits An RV With One Room Closed Off With A Door That Could Be Used For An Art Studio Or Wood Working. The Detached Garage Is Wired For High Powered Tools, 2-New 2022-Mini Splits Unit's. There Is Fenced Area With Fruit Trees That Could Be Used For A Dog Run Or Garden. This Is Truly A Mountain Retreat, Sit Back Relax & Enjoy The Neighborhoods Tranquility, Fantastic Mountain Views, Stunning Sunrises & Sunsets!!
MlsNumber: 011129


Listing Provided By: RE/MAX Prestige Properties, original listing
Name: RE/MAX Prestige Properties
Phone: (928) 718-0100
Office Name: RE/MAX Prestige Properties
Office Phone: (928) 718-0100
Agent Name: Mindy Terlesky
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