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

14819 U.s. 41 Alternate
Corydon, KY 42406
Wendy Mattingly with REMAX Professional Realty Group, original listing - (270) 844-8181

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Pending
SqFt: 2955 Square Feet
Agency: REMAX Professional Realty Group
Agency Phone: (270) 844-8181

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: WOWZA!! This home checks ALL THE BOXES! Comes with all the bells and whistles! This beautifully updated brick home is elegance at its finest and is seated on 2 acres offering country living with no city taxes! At first sight you'll notice the gorgeous sunroom at the front of the home. Offers 4 spacious bedrooms, with the primary on the main level with its own en-suite tiled bathroom with newly tiled shower, double sinks and bidet. Includes walk-in closet. The 2nd bedroom on the main level has its own ensuite bathroom (new shower, vanity and toilet) and is accessible from the hallway for convenience. Each of the 4 bedrooms have their own walk-in closets. There are closets for days; so much extra storage space (even in the floored attic!) There is another half bath located on the main level for added convenience. Includes 2 more large bedrooms upstairs with a Game Room that could easily make for the 5th bedroom. Luxury vinyl flooring all throughout the home with carpeting upstairs. Large gourmet kitchen includes all new stainless steel appliances and brand new quartz countertops, island and a cute corner coffee bar. Home has new HVAC upstairs and downstairs, all new windows, new tankless water heater, new 3 dimensional Owens Corning roof (2023); seller will warrant roof for another 3 years! Home has new 6 inch gutters, blown insulation and spray foam in attic to minimize those utility bills! Home includes a natural gas Generac generator that runs the entire house - great for those unexpected emergencies! Newly constructed outdoor entertainment and family area that includes a huge stone patio with an awesome fireplace, covered pergola, stone open grilling pit and a hot tub! In addition to this backyard oasis, is a fully stocked 1/4 acre lake with your very own sandy beach area and a new Trex deck over lake. Home includes new landscaping and new decorative landscaping rocks and the newer greenhouse conveys with the property! Hold on...there's more! Includes a new 42x60 climate controlled building/pole barn with an upstairs loft for storage and a brand new oversized garage door on the lake side. Building has been insulated with spray foam as well. All new garage doors with access codes on home and building. Property includes an invisible dog fence to protect those fur babies! All extra wide "plantation blinds" and window treatments are included. This home and property boasts of all of this and more, too much to list! EVERYTHING ON THE PROPERTY IS 4 YEARS OR NEWER! This home is a MUST SEE! Make your appointment to see this one today!
MlsNumber: --
ListingId: 250053


Listing Provided By: REMAX Professional Realty Group, original listing
Phone: (270) 855-0263
Office Phone: (270) 844-8181
Agent Name: Wendy Mattingly
Disclaimer: Copyright © 2025 Henderson Audubon Board of Realtors. 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