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

190 Hazy Downs Road
Raywick, KY 40060
Charles Lancaster, Jr with The Lancaster Agency Inc, original listing - (270) 692-6748

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Here is a gorgeous home offering a splendid living area all on one level and filled with charming touches and ornate designs that starts in the cozy living room brightened by a duo of sun-enticing windows glowing on the beautiful woodgrain laminate floor. The cathedral style ceiling fosters that extra roomy feel to be able to host & entertain comfortably while the adorable archway to the hallway illustrates just one of many charming features in the home. Flowing from the living room is a kitchen that would be the envy of any chef as it is laid with a soothing luxury vinyl plank floor and highlighted by an assortment of custom white cabinetry sporting an elegant design and pairing beautifully with the artisan style backsplash. The accent lighting enhances the tranquil ambiance while the sleek granite countertops add a tasteful pop and includes a cute breakfast bar. The kitchen is also souped-up with state-of-the-art slate GE appliances (refrigerator, dishwasher, stove, & built-in microwave) plus an intimate dining area that filters amazing natural light and offers a nice view of the scenic backyard. Through the kitchen is another darling area featuring a handy 1/2 bath and an adorable laundry room that is elevated by a dazzling light fixture and robust crown molding. The first-class finishes even extend to the attached 2-car garage as it has a decorative ceramic tile floor and more crown molding... not to mention all of the attic storage it provides too! Then follow the lovely archway down the hall that is furnished with storage closets and wainscoting walls for a charming touch. This area of the home features 3 bedrooms... one of which is a spacious primary suite highlighted by ornate ceiling trim, a generously sized walk-in closet, and a private bathroom. The ensuite bath is complete with a fashionable European height twin vanity, a relaxing garden tub, and a refreshing walk-in shower. The 2 spare bedrooms are furnished with large closets while one of the rooms has an enchanting arched window, a delightful cathedral style ceiling, and a nifty nook to also make it a great home office or study. Accompanying these bedrooms is another stylish bathroom highlighted by first-class plumbing and light fixtures. Outside you will enjoy awesome views from either the covered front porch or the rear patio providing evening shade... You will love the custom stamped curbed landscaping all around the home & lots of trees... Plus a nice playset for the kids, a detached 24' X 16' garage/storage building with a lean-to and overhead door & a double asphalt driveway w/ additional parking area... Even the home's foundation is covered by stone for that classy look! As an added bonus... the roof was replaced in the summer of 2023! All you have to do is move in and enjoy all this outstanding home has to offer. Quality never goes out of style and call MIKE SPALDING to view this home as you must see it to truly appreciate the attention to detail. ***NOTE: WE DO NOT PAY COMMISSION ON SELLER PAID CLOSING COSTS AND PRE-PAID ITEMS***
MlsNumber: --
ListingId: 11450864


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','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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