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 = 105 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 = 105 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 = 105 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;

2780 Point Pleasant Rd
Eminence, KY 40019

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $820,000
Beds: 5
Baths: 5
Status: Active
SqFt: 3605
Agency: KY Homes and Farms Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 23 acre(s)
Property Type: Residential
Year Built: 2008
Notes: Welcome home to 2780 Point Pleasant Rd!! This custom built home is nestled on 23.35 beautifully manicured acres that borders Drennon Creek. Home boasts an open floor plan with 3,605 sq. ft., 3 car attached garage, finished walkout basement, 5 bedrooms and 4 1/2 full baths! Home features large great room with vaulted ceiling & gas fireplace that walks out to the beautiful deck. Perfect spot to look out over the countryside. Adjoining the great room is the beautiful kitchen for the chef in the family with dining area, lots of cabinets, granite counter tops, large pantry, all stainless steel appliances, electric cook top, wall oven, microwave and dishwasher. Just off the kitchen is the dining room that is a perfect spot to host holiday dinners. The laundry room and half bath is conveniently located just off the kitchen, also. Next is the beautiful owner's suite with en-suite bath offers double vanities, whirlpool tub, walk-in shower and walk-in closet. On the 2nd level you have a 3 large bedrooms, one with en-suite bath and another full bath. Make your way to the basement were you have a huge family room which walks out to a large patio with wet bar and full size refrigerator. Just off the family room is a bedroom, full bath, office and media room. Outside you get a 24' X 60' X 10' massive 4 car pole barn with electric, water and concrete. The perfect spot to store your boat, tractor, side by side, classic car and ALL your other toys! The home has 2 heat pump HVAC systems. Easy access to Louisville, Lexington or Cincinnati. Don't miss this opportunity to own this awesome property!
MlsNumber: 1646671


Listing Provided By: KY Homes and Farms Real Estate, original listing
Name: KY Homes and Farms Real Estate
Phone: (502) 845-4400 xx13
Office Name: KY Homes and Farms Real Estate
Office Phone: (502) 845-4400
Agent Name: Steve Woods
Disclaimer: Copyright © 2024 Greater Louisville Association 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