Title Page Background
DEBUG FN args: Array ( [0] => 1293 [1] => [2] => [3] => agent ) BEFORE: Site: 1293 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1293 Igate: njhud LocID: 1293 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1293 AND i.igate IN ('mihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1293 [1] => [2] => [3] => lender ) BEFORE: Site: 1293 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1293 Igate: njhud LocID: 1293 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1293 AND i.igate IN ('mihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1293 [1] => [2] => [3] => other ) BEFORE: Site: 1293 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1293 Igate: njhud LocID: 1293 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1293 AND i.igate IN ('mihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

17321 Gillette Street
Overland Park, KS 66221

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $869,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3233 Square Feet
Agency: Weichert, Realtors Welch & Com
Agency Phone: (913) 647-5700

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Garbage Disposer
Architectural Style: Contemporary
Construction Materials: Stone, Frame, Stone Veneer
Flooring: Carpet, Tile, Wood
Heating: Central Furnace
Interior Features: Custom Cabinets, Kitchen Island, Pantry, Wet Bar, Vaulted Ceiling, Walk-in Closet, Painted Cabinets
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Property Condition: New Construction
Roof: Composition

Neighborhood/Schools

Elementary School/District: Timber Sage/Spring Hill
Middle/Junior High School/District: /Spring Hill
High School/District: Spring Hill
Subvidision Name: Chapel Hill

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: You will instantly fall in love with a brand new reverse 1.5 Story by Doyle Construction. Introducing The Jacobsen! NEW and UPDATED REVERSE floor plan on LOT 430. This floor plan features a completely open Concept, Reception Front Foyer with a grand staircase with a wall of windows & landing. The first thing you will notice is a myriad of custom touches. The trim details will knock you out! A chefs delight kitchen with Island, a HUGE walk-in pantry prep area, waterfall edge on the island & custom cabinets to the ceiling. The Primary Suite is a retreat where you can relax that features a shower/free-standing tub area, full wall double vanity with extra storage & trim designs with a TO DIE FOR closet. This closet is better than closets seen in million dollar homes. The Laundry Room connects conveniently to the closet. A cabinet style boot bench is off the garage. To keep you organized there is also a drop zone cabinet. The 2nd bedroom on the main level also enjoys amazing trim details. The stairs take you down to the walk out lower level. A large entertainment area with a wet bar, Television wall & space for a game table. All of the Bedrooms have private baths! You can watch the sunrise on the covered deck. The home is at finishing stage. Chapel Hill amenities include 2 swimming pools (one competition sized), Clubroom/Clubhouse, Pickleball Court, tot lot, walking trails and more. Chapel Hill is immediately adjacent to the 1200 Acre Heritage Park Complex featuring a recreational lake with marina and sand beach, 18 hole golf course, Off Leash dog park, athletic fields, picnic shelters, walking trails and More! Estimate completion of this home less than 60 days.
MlsNumber: --
ListingId: 2449731


Listing Provided By: Weichert, Realtors Welch & Com, original listing
Phone: (913) 406-5055
Office Phone: (913) 647-5700
Agent Name: Bill Gerue
Disclaimer: Copyright © 2024 Heartland Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App