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

7011 Dylan Circle
Georgetown, IN 47122

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $444,900
Beds: 4
Baths: 3
Status: Active
SqFt: 2435
Agency: Schuler Bauer Real Estate Services

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: *OPEN SUNDAYS 2-4PM* BRAND NEW Construction in FLOYD COUNTY!!! Exclusively built by Witten Builders, QUALITY BUILT, FANTASTIC LOCATION! Tucked away in Beautiful ESTABLISHED Brookstone on a QUIET Cul de sac, ONLY 22 Lots! AWARD WINNING FLOYD CENTRAL SCHOOLS! USDA 100%, ZERO DOWNPAYMENT available! Easy access to BRAND NEW 200 ACRE NATURE PRESERVE w/OVER 4.2 Miles of Walking Trails. THE ASHLEY PLAN, w/ Modern Flare Split floor plan, OPEN LIVING, 4 Beds/3 FULL Baths, FINISHED WALKOUT AND 3 CAR GARAGE is AMAZING!!!! Gorgeous Stone, HARDIE, Vinyl Exterior and COVERED FRONT PORCH! OVER 2600 Sq ft FINISHED LIVING Space, Smooth Ceilings, High-end Water Proof LUXURY VINYL PLANK Flooring, Lrg Great Room built-ins ELECTRIC FP Lrg Kitchen, GRANITE ISLAND Bar w/Serving/Seating, HUGE WALK-IN PANTRY! Lrg Eat-In Dining. Lrg Owner’s Suite, w/LRG WALK-in Closet, Luxury Bath, Dbl Vanity w/GRANITE, Lrg CUSTOM TILE Shower. Beds 2/3 NICE SIZE! Owner’s Entry w/Built-ins/Drop Zone. LL FINISHED WALKOUT, OPEN REC Space, 4th Bed and FULL 3rd Bath, PLUS utility garage. Lrg Backyard, Energy Star, Rated, Delta Fixtures, Jeld-Wen windows, INSULATED Garage doors, Keyless Entry, 2-10 Home Warranty at closing! BUY NOW to make selections! Very close to schools, HYR, ballpark, only 15 minutes to downtown Louisville! (Estimated Completion Summer 2024) options to build on other lots too!
MlsNumber: 202407072


Listing Provided By: Schuler Bauer Real Estate Services, original listing
Name: Schuler Bauer Real Estate Services
Phone: (812) 948-2888
Office Name: Schuler Bauer Real Estate Services ERA Powere
Office Phone: (812) 948-2888
Agent Name: David B Bauer
Disclaimer: Copyright © 2024 Southern Indiana REALTORS Association. 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