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

495 Holy Cross Road
Loretto, KY 40037
Charles Lancaster, Jr with The Lancaster Agency Inc, original listing - (270) 692-6748

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $369,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2865 Square Feet
Agency: The Lancaster Agency Inc
Agency Phone: (270) 692-6748

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: Welcome to this beautiful home nestled on a 2.09-acre (+/-) spread of land in the gorgeous and highly desired Loretto Area! The tour begins in the airy living room showcasing glowing hardwood floors and accentuated by a charming arched window paired with a cathedral-style ceiling. Flowing from the living room is a fabulous kitchen sporting more of that gleaming hardwood. The kitchen is furnished with a large horseshoe counter that wraps into an adorable breakfast bar and topped with sleek granite. Then equipped in the kitchen is an exquisite selection of hardy cabinetry and first-class appliances that include a dishwasher and stainless-steel refrigerator, stove, & microwave! Rounding out the kitchen is a handy pantry closet and sizable dining area... and when it's time to just sit back and relax... make your way to the lovely sunroom surrounded by elegant colonial-style windows that filter soft natural light into the room. The sunroom is also laid with a soothing tile floor and enhanced with an exposed brick wall to make it your go to spot for some peace and quiet. The first-floor features a spacious primary bedroom elevated with a decorative tray ceiling, a delightful arched window, and ensuite bath. The ensuite bath is souped-up with a stylish vanity (w/ dressing table) accompanied by a relaxing whirlpool tub plus a large walk-in closet! Completing the first-floor is a convenient 1/2 bath, an awesome attached 2-car garage, and a nice laundry room fitted with handy cabinetry and a nifty sink. The upstairs has another full bath and hosts 3 more generously sized bedrooms plus a bonus room for the opportunity of a 5th bedroom! These extra rooms offer great options as they could be utilized as office space, rec/play areas for the kids, or that always needed storage space. Speaking of which... the upstairs provides tons of storage space as there is even attic storage that spans across the home! Outside... you will love being able to spread out across the open yard that offers unobstructed views of the scenic countryside, a quaint pond, shaded patio, and a 16' X 20' storage building. Plus... you can almost stand in the crawl space which is also lined with lights to make underneath access of the home a breeze and being a testament to the quality of construction. Quality never goes out of style and call JESSI VAUGHN to see the quality first-hand today! ***NOTE: WE DO NOT PAY COMMISSION ON SELLER PAID CLOSING COSTS AND PRE-PAID ITEMS***
MlsNumber: --
ListingId: 11486592


Listing Provided By: The Lancaster Agency Inc, original listing
Phone: (270) 692-7270
Office Phone: (270) 692-6748
Agent Name: Charles Lancaster, Jr
Disclaimer: Copyright © 2025 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1072 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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;
Adrienne Gilbert
ASCIIUnited Real Estate Louisville - Elizabethtown
Call Today!: (270) 283-8856

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App