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;

685 Country Club Drive
Kingman, AZ 86401

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $855,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3423
Agency: Frontier Crossroads

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: MAJESTIC VIEWS! COME VIEW THIS EXQUISITE 3,435 SQUARE FOOT, 4 BEDROOM, 4 BATH, 3 CAR GARAGE HOME ON A GIGANTIC 9,100 SQUARE FEET LOT NESTLED IN A SPECTACULAR AREA OF THE GOLF COURSE IN THE MIDDLE OF TOWN CLOSE TO SHOPPING, SCHOOLS, HOSPITAL, ETC. THIS CUSTOM MADE LUXURIOUS HOME HAS MANY UPGRADES AND SPECIAL FEATURES, SHOWCASING A HUGE GREAT ROOM AND OPEN FLOOR PLAN CONCEPT, WITH A GOURMET STYLE KITCHEN, BUILT IN STAINLESS STEEL CUSTOM FRIDGE, STAINLESS STEEL APPLIANCES, GRANITE COUNTERS, RAISED COUNTERS FOR BARSTOOLS, AS WELL AS A BREAKFAST AREA FOR CASUAL DINING. HIGHLIGHTED DECORATIVE BEAMS ARE ALONG THE KITCHEN AND FAMILY ROOM VAULTELD CEILING ABOVE, ALONG THE WALL ARE BUILTIN SHELVES, LARGE SCREEN TV CONSOL AREA ABOVE MAIN FOCAL POINT OF A BRICK FIREPLACE. AN ADDED LIVING SPACE WELCOMES YOU UPON ENTANCE OF HOME THROUGH AN EXTRA TALL WOODEN FRONT DOOR ENTRY, WHICH IS ADJACENT TO THE FORMAL DINING ROOM. AMAZING VIEWS CAN BE SEEN FROM DIFFERENT ANGLES FROM MULTIPLE ROOMS. THE HUGE MASTER BEDROOM HAS A HUGE MASTER BATH WITH A WALKIN SHOWER EMBELLISHED WITH COLORFUL TILES ON THE SHOWER WALLS. REMEMBER TO TAKE A RELAXING BATH IN THE STAND ALONE BATHTUB. THE MASTER INCLUDES A BUILTIN CLOSET ORGANIZER, AND A SECOND FIREPLACE TO HELP YOU KEEP WARM IN THE WINTER. ELONGATED MASTER BEDROOM INCLUDES NOOK AREA FOR ADDED SPACE TO BE USED AS AN EXERCISE ROOM OR WHATEVER YOU PREFER. ADDITIONAL SCENIC BREATHTAKING VIEWS SEEN FROM THE WINDOWS AND GLASS DOOR LEAD TO AN EASY ACCESS TO THE GORGEOUS BACKYARD. CASITA/4TH BEDROOM/NEXT GEN/OFFICE HAS IT'S OWN PRIVATE ENTRANCE SITUATED LEFT OF COVERED COURTYARD, WITH IT'S OWN LIVING AREA, KITCHEN, AND PRIVATE BATHROOM. EXTRA LONG WINDOWS DRAPED WITH EXQUISITE CURTAINS ARE ADORNED THROUGHOUT HOME. ROOMS HAVE EITHER CEILING FANS OR BEAUTIFUL LIGHT FIXTURES. INDOOR LAUNDRY HAS MANY BUILTIN CABINETS AND COUNTERTOP. OTHER AMENITIES INCLUDE ADDED BRAND NEW HVAC SYSTEM, RECENTLY PURCHASED WATER SOFTENER, HI TECH SECURITY SYSTEM, AND ELABORATE AIR PURIFYER UNIT. BOOKSHELVES, DESK AND REMAINING FURNITURE MAY BE PURCHASED IF DESIRED. THIS SERENE QUIET NEIGHBORHOOD HAS NO HOA.
MlsNumber: 012897


Listing Provided By: Frontier Crossroads, original listing
Name: Frontier Crossroads
Phone: (928) 377-2929
Office Name: Frontier Crossroads
Office Phone: (928) 377-2929
Agent Name: Rafat Subhan
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