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

2913 Harrods Crossing Blvd
Crestwood, KY 40014
Joseph Simms with RE/MAX Properties East, original listing - (502) 425-6000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 3
Baths: Full: 3, ½: 2
Status: Active
SqFt: 4668 Square Feet
Agency: RE/MAX Properties East
Agency Phone: (502) 425-6000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Offered for the first time and at $25,000 BELOW APPRAISAL, this custom-built ranch in Harrods Crossing sits on over 2 acres of beautifully balanced open and wooded land, located in the highly desirable Oldham County school district. A tranquil creek, koi pond, and waterfall feature provide a stunning natural backdrop, all visible from the expansive flagstone patio or screened porch. A 3-car garage and a new roof with skylights offer peace of mind, while inside, handcrafted trimwork by the master woodworker/owner lends distinction throughout. A covered front porch welcomes you into the marble-tiled foyer, opening to a stunning formal dining room with a coffered ceiling crafted from copper and Honduran mahogany. Brazilian cherry floors flow through the main living areas, including the vaulted great room with a dramatic wall of windows framing the lush surroundings. The eat-in kitchen features solid maple cabinetry and connects seamlessly to a vaulted hearth room with a striking maple ceilingan ideal layout for entertaining. The spacious primary suite is a private retreat with its own sunroom (highlighted by a cedar ceiling), custom walk-in closet, and a luxurious en suite bath with a whirlpool tub, walk-in shower with Corian ceiling, and double vanity. Two additional bedrooms share a full bath, also with a Corian shower ceiling, and a powder room and laundry complete the main level. With 36" doorways throughout the first floor, the home is designed for accessibility.<br /> The lower level is another standout, offering a large family room and bar area with stone and wood detailing and petrified tree stone countertops (Green Rainforest). One full and one half bath, storage area, and two tankless water heaters add comfort and convenience. Additional features include a whole-house generator and a one-year America's Preferred Home Warranty offered by the seller. A rare opportunity to own a one-of-a-kind, meticulously crafted home in a serene yet convenient setting.
MlsNumber: --
ListingId: 1687185


Listing Provided By: RE/MAX Properties East, original listing
Phone: (502) 425-6000
Office Phone: (502) 425-6000
Agent Name: Joseph Simms
Disclaimer: Copyright © 2025 Greater Louisville Association of REALTORS&#174;. 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 = 1090 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Real Estate Expert Photo for Vicky Taube
Vicky Taube
ASCIIFinish Line Realty
Call Today!: (502) 902-1344

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App