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;

104 N Estes St
Garden Plain, KS 67050
Sharon Taylor with RE/MAX Premier, original listing - (316) 773-2707

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $610,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3003 Square Feet
Agency: RE/MAX Premier
Agency Phone: (316) 773-2707

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Looking for a Zero Entry home? with Built in Equity - Two Appraisals have been completed: Building at $685,000. - Final at $675,000. = minimum $65,000. in sweet equity awaiting you!!! Did I mention this well thought out Beautiful Zero Entry home has over 3000 sqft * FOUR plus garages totaling 1719.5 sqft, pull thru door, Side mount Chamberlain quiet openers * Concrete Storm room * Irrigation Well and Sprinklers covering the 2.23 Acres, note Seller is installing Soaker hoses at the front flower bed and Seeding yard prior to closing * Sidewalk leading to the Covered front porch * Covered Back Porch that's 510sqft for entertaining or a quiet evening while sitting by the builtin Fireplace * Two 96% Energy Efficient HVAC * Two Manifold Plumbing stations, one for each side of the house * Double pane Windows, with Bedroom windows being tinted so you cannot see in * rocked Mail Box at the end of your drive... Let's talk about the ambience: front Foyer screams beauty with the Custom front door * Chefs Kitchen with quartz countertops, Pot Filler, Water connection for a ice machine, Double Ovens, all Kitchen Appliances stay, a ton of easy close Cabinetry, and the large Walk in Pantry will make any Chef excited * Living room having Vaulted Wood beam ceiling, Gas Fireplace with Blower * Dining Room with Tray Ceiling * All rooms in the house including Bedroom's are a wonderful size with walk-in Closets, you'll get the feeling of freedom and not boxed in * Primary Bedroom has lighted Tray Ceiling, its attached bathroom being plenty big for two people to get ready at once, Double Sinks with their own Cabinetry - Water Closet - Soaking Tub - Linen Storage - Shower large enough for two * Ceiling fans thru-out * Drop Zone in the Mud Room off the garages * Laundry room having folding table, wash sink, cubby's for basket organizing, then head upstairs to the spacious Rec/Theater room~ Come enjoy the Subdivision that has Ponds, a Swimming Pool, Trail just north of subdivision to ride your bikes/walks, you get ALL this just 15 minutes from west Wichita. Here in the small town of Garden Plain where everyone is friendly and watches out for each other, plus all three Primary schools are in town! Professionals Photos to come - All information is deemed to be reliable, but not guaranteed - Please verify all information that is important to you.
MlsNumber: --
ListingId: 644952


Listing Provided By: RE/MAX Premier, original listing
Phone: (316) 773-2707
Office Phone: (316) 773-2707
Agent Name: Sharon Taylor
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