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;

6184 Scottsville Navilleton Road
Floyds Knobs, IN 47119

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,000
Beds: 5
Baths: 4
Status: Active
SqFt: 4220
Agency: Purple Door IN KY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2002
Notes: THIS CUSTOM-BUILT 1 OWNER HOME HAS A TON OF WELL THOUGHT OUT DETAILS AND IS SITUATED ON 2.241 ACRES OF PICTURESQUE VIEWS. THIS FRONT PORCH IS SOMETHING DREAMS ARE MADE OF AND PERFECT FOR WATCHING THE SUN SET WITH A GLASS OF SWEET TEA! THE FIRST FLOOR HAS SOARING CEILINGS THROUGHOUT, HARDWOOD FLOORS, OPEN KITCHEN WITH A WALK IN PANTRY, GRANITE COUNTERTOPS, DOUBLE SIDED FIREPLACE, 1ST FLOOR PRIMARY SUITE, LARGE LAUNDRY ROOM WITH A SINK, LARGE DECK ON THE REAR OF THE HOUSE, A HUGE 3 SEASON SUN ROOM FOR ENTERTAINING, A FORMAL DINING ROOM AND AN OFFICE THAT HAS A PERFECT VIEW. THE 2ND FLOOR HAS 4 BEDROOMS (THERE IS A 5th NON-CONFORMING Bedroom WITH A SHARED CLOSET) AND A LARGE HALL BATH THAT HAS 2 SINKS. THE WALKOUT BASEMENT FEATURES A LARGE FAMILY ROOM, A KITCHENETTE WITH A SINK AND MINI FRIDGE, A FULL BATHROOM WITH A SHOWER, STORAGE, A LARGE UNFINSHED AREA THAT COULD BE FINSIHED OUT FURTHER IF DESIRED, AND A UTILITY GARAGE AREA. OUTSIDE THERES A LARGE WELL LANDSCAPED PATIO AREA WITH A FIREPIT AREA THAT WOULD BE PERFECT FOR OUTDOOR ENTERTAINING.
MlsNumber: 202407048


Listing Provided By: Purple Door IN KY, original listing
Name: Purple Door IN KY
Phone: (502) 345-2291
Office Name: 1% Lists Purple Door IN KY
Office Phone: (502) 345-2291
Agent Name: Michelle Schnell-Gammons
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