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;

7015 Dylan (lot 417) Circle
Georgetown, IN 47122

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $454,900
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2620 Square Feet
Agency: Schuler Bauer Real Estate Services ERA Powered (N
Agency Phone: (812) 948-2888

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: 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!<br /> WALK TO NEW FLOYD COUNTY REGIONAL PARK/ NATURE PRESERVE w/4.2 Miles Walking Trails. THE ASHLEY PLAN, Split floor plan, OPEN LIVING, 4 Beds/3 FULL Baths, FINISHED WALKOUT (HUGE DEEP LOT) 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, 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 + Utility Garage. Lrg Backyard, Energy Star, Rated, Delta Fixtures, INSULATED Garage doors, Keyless Entry, 2-10 Home Warranty at closing! BUY NOW to make selections!<br /> Very close to schools, Highlander Point, HYR, ballpark, only 15 minutes to downtown Louisville! BUY NOW TO MAKE SELECTIONS, Estimated Completion April 2025) options to build on other lots too!
MlsNumber: --
ListingId: 2024012708


Listing Provided By: Schuler Bauer Real Estate Services ERA Powered (N, original listing
Phone: (502) 931-5657
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