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 = 979 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 979 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 979 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

1610 N Foliage Dr
Wichita, KS 67206
Eric Locke with ERA Great American Realty, original listing - (316) 686-4111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,570,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 6453 Square Feet
Agency: ERA Great American Realty
Agency Phone: (316) 686-4111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1983
Notes: Come see this highly desired Foliage brick ranch showcasing top end designer upgrades throughout that backs up to the lake! Walk through the Foyer past the feature wall into a step down living area with 1 of 4 gas fireplaces with cannonball inserts. You'll love the panoramic sliding glass wall and gorgeous lake views! There's a formal dining area for family dinners or hosting parties and a 2nd eating area in the kitchen. The gourmet kitchen boasts Taj Mahal Quartzite counters, sub zero Wolf appliances, a custom vent hood with warming lights, a large prep island and eating bar, a 2nd sink in the beverage bar, a coffee bar, a must have pantry, & much more! The laundry room off the 3 car garage is oversized, has concealed appliances, a folding area, & tons of work space. You'll love the oversized master suite showcasing a private walk out deck with lake views, a hidden media wall, a marble faced fireplace, a wood ceiling & a true en suite bath. The en suite boasts marble vanities, a make up bar, heated marble flooring, a garden tub, XXL shower with dual zones, benched seating, and an oversized niche. There's custom chests, cabinets, and tons of his/her space in the wrap around walk in closet. You'll love the adjacent home office, library, or bonus space with it's own fireplace & great lake views to use as you choose. Head down the wrap around live glass atrium staircase into the walk out basement where you'll find an oversized wood burning fireplace cozied inside a step down family area. There's a game area, poker area, & billiards room with a double sided wet bar perfect for entertaining guests. There's also a theater room, mirrored exercise room, and a guest suite with a private bath. Relax on the deck, patio, or garden area in the .6 acre yard that is fenced, well sprinkled, & backs up to the lake with gorgeous views! This is a great find in the highly desired Foliage area that has all the upgrades & is ready for you to make it your home!
MlsNumber: --
ListingId: 647229


Listing Provided By: ERA Great American Realty, original listing
Phone: (316) 640-9274
Office Phone: (316) 686-4111
Agent Name: Eric Locke
Disclaimer: Copyright © 2024 South Central Kansas MLS. 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 = 979 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Kristel Melton
ASCIIElite Real Estate
Call Today!: (316) 680-9809

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App