Title Page Background
DEBUG FN args: Array ( [0] => 1053 [1] => [2] => [3] => agent ) BEFORE: Site: 1053 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1053 Igate: njhud LocID: 1053 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1053 AND i.igate IN ('uthud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1053 [1] => [2] => [3] => lender ) BEFORE: Site: 1053 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1053 Igate: njhud LocID: 1053 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1053 AND i.igate IN ('uthud','usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1053 [1] => [2] => [3] => other ) BEFORE: Site: 1053 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1053 Igate: njhud LocID: 1053 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1053 AND i.igate IN ('uthud','usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

13300 River Glades Ln
Prospect, KY 40059

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,777,500
Beds: 5
Baths:
Status: Pending
SqFt: 18500 Square Feet
Agency: Weichert Realtors-H. Barry Smith Co.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 29 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1995
Notes: ESTATE REAL ESTATE AUCTION<br /> <br /> SATURDAY MARCH 2ND 11:00 AM<br /> 18,000 SQUARE FOOT HOME ON 29 ACRES<br /> PROSPECT, KENTUCKY<br /> This secluded mansion of over 18,000 sq ft sits prominently on 3 parcels totaling 29 acres that are mostly wooded for the ultimate private setting. The gated community of River Glades is located in Prospect, KY, sits close to the Ohio River, and has easy access to Louisville or Indiana amenities. The first level of the home has a grand entrance with an amazing staircase. The living and family room area has a wet bar for entertaining guests, a dining room that overlooks the rear of the property, a commercial kitchen, an executive office along with 2 other office/file rooms, a security room, your own hair salon, and numerous other storage rooms. If you don't like steps, no problem, this property has a commercial elevator that can take you to every floor of the home. The upstairs level has the primary suite that boasts beautiful views of the real estate along with a morning room, 18x18 dressing area/ closet area with glass-enclosed closets for your wardrobe, a walk-in shower and tub. There is also a billiards room with projection screen theater area, that leads to the exercise room, locker room, and full bathroom with walk-in shower. The upstairs has 4 additional bedrooms, all with their own bathrooms. The basement is the dream area of the home that has a black onyx indoor pool with a slide, hot tub, and bar area. There is a poker room and bar set up in a large entertaining area along with 2 full bathrooms. The unique area is a 3 lane indoor firing range with a storage room for all of your firearms and ammo. This home has a large mechanical room that gives you easy access to control the whole property along with security features to give you the ultimate feel of safety in your home. <br /> <br /> The property has a 2 bedroom. 1 bath apartment for a caretaker or guests to stay along with a 2-car garage. The main home has a 6-car motor court for your collection or vehicles, three with the attached garage, and three under the caretaker apartment. The exterior grounds of the home include fountains, gardens, and sitting areas for the enjoyment of this one-of-a-kind piece of real estate.
MlsNumber: --


Listing Provided By: Weichert Realtors-H. Barry Smith Co., original listing
Phone: (502) 633-2746
Office Phone: (502) 633-2746
Agent Name: Shawn Willard
Disclaimer: Copyright © 2024 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => jefferson-county [3] => KY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: jefferson-county State: KY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: jefferson-county State: KY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1053 AND i.igate IN ('uthud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Kevin Dickhaut
Kevin Dickhaut
ASCIIKELLER WILLIAMS LOUISVILLE EAST
Call Today!: (502) 475-8117

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App