Start of property details





Property Description
Nestled atop a vast 3.55-acre expanse along the scenic Ohio River, this magnificent estate stands as a pinnacle of luxury living, commanding breathtaking views of the river and the unspoiled beauty of Twelve Mile Island. Expertly designed by the esteemed local architect, Dan Fultz, the estate offers a harmonious blend of grand formal spaces for entertaining and cozy family areas, ideal for daily enjoyment. Across its sprawling layout, the residence features six luxurious bedrooms, including a first-floor primary suite and a fully-equipped carriage house for guests, ensuring ample space for family and visitors alike. The home's architectural centerpiece is a stunningly crafted center staircase, a visual triumph that gracefully connects each level. Further enhancing this extraordinary property are a 5-car garage, a serene pool with a limestone terrace and elegant pool house, a meticulously designed wine cellar, and a rooftop lookout that provides a panoramic vista of the Ohio River valley. Not a detail was missed in the estate's features and layout while using the finest materials and finishes throughout the expansive 15, 000 square foot floor plan. A property of this caliber is a rare offering in our market, presenting a truly exceptional opportunity. It boasts an unparalleled combination of breathtaking views and location, all while being in immaculate, like-new condition and presentation.
Property Highlights
Location
Property Details
Building
Community
Local Schools
Interior Features
Bedrooms and Bathrooms
Rooms and Basement
Area and Spaces
Heating and Cooling
Building Details
Construction
Materials
Taxes
HOA
Heating, Cooling & Utilities
Utilities
Lot
Exterior Features
Parking
Pool Features
Payment Calculator
Property History
Similar Properties
{"property_id":"ky239_1677708","AboveGradeFinishedArea":"10546","AccessibilityFeatures":"","Appliances":"","ArchitecturalStyle":"","AssociationAmenities":"","AssociationFee":"2050.00","AssociationFeeFrequency":"","AssociationFeeIncludes":"","AssociationYN":"1","AttributionContact":"","Basement":"Walkout Finished","BasementYN":"1","BathroomsFull":"6","BathroomsHalf":"5","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"4000","BuilderModel":"","BuilderName":"","BuyerAgentFullName":"","BuyerAgentEmail":"","BuyerAgentDirectPhone":"","BuyerOfficeName":"","CapRate":"0.00","CityRegion":"","CommunityFeatures":"","ComplexName":"","ConstructionMaterials":"Cement Siding, Wood Frame, Stone Veneer","Contingency":"","Cooling":"Central Air","CountyOrParish":"Oldham","CoveredSpaces":"0","DevelopmentName":"","DevelopmentStatus":"","DirectionFaces":"","DoorFeatures":"","Electric":"","ElementarySchool":"","Exclusions":"","ExteriorFeatures":"Sauna\/Steam, Balcony, Hot Tub","Fencing":"Full","FireplaceFeatures":"","FireplaceYN":"1","FireplacesTotal":"4","Flooring":"","FoundationDetails":"Poured Concrete","GarageSpaces":"0.00","GreenBuildingVerificationType":"","GreenEnergyEfficient":"","GreenEnergyGeneration":"","GreenIndoorAirQuality":"","GreenLocation":"","GreenSustainability":"","GreenWaterConservation":"","Heating":"Forced Air, Natural Gas, Geothermal","HighSchool":"","HorseAmenities":"","HorseYN":"0","Inclusions":"","IndoorFeatures":"","InteriorFeatures":"","InternetAddressDisplayYN":"","LaundryFeatures":"","Levels":"","ListingTerms":"","ListAgentFullName":"Jon Mand","LivingArea":"0.00","LotFeatures":"Cul-De-Sac, Covt\/Restr, Cleared, Level","LotSizeArea":"3.66","LotSizeSquareFeet":"159429.60","MainLevelBedrooms":"0","MiddleOrJuniorSchool":"","Model":"","NewConstructionYN":"","NumberOfUnitsTotal":"0","ListOfficeKey":"20131203192904093853000000","OfficePhone":"","OtherParking":"","Ownership":"","ParkingFeatures":"Detached, Attached, Driveway","ParkingTotal":"0","PatioAndPorchFeatures":"Deck, Patio, Porch","PoolFeatures":"In Ground","PoolYN":"","PoolPrivateYN":"","PropertyCondition":"","public_remarks":"Nestled atop a vast 3.55-acre expanse along the scenic Ohio River, this magnificent estate stands as a pinnacle of luxury living, commanding breathtaking views of the river and the unspoiled beauty of Twelve Mile Island. Expertly designed by the esteemed local architect, Dan Fultz, the estate offers a harmonious blend of grand formal spaces for entertaining and cozy family areas, ideal for daily enjoyment. Across its sprawling layout, the residence features six luxurious bedrooms, including a first-floor primary suite and a fully-equipped carriage house for guests, ensuring ample space for family and visitors alike. The home's architectural centerpiece is a stunningly crafted center staircase, a visual triumph that gracefully connects each level. Further enhancing this extraordinary property are a 5-car garage, a serene pool with a limestone terrace and elegant pool house, a meticulously designed wine cellar, and a rooftop lookout that provides a panoramic vista of the Ohio River valley. Not a detail was missed in the estate's features and layout while using the finest materials and finishes throughout the expansive 15, 000 square foot floor plan. A property of this caliber is a rare offering in our market, presenting a truly exceptional opportunity. It boasts an unparalleled combination of breathtaking views and location, all while being in immaculate, like-new condition and presentation.","Roof":"Metal, Shingle","RoomsTotal":"20","SchoolDistrict":"Oldham","SecurityFeatures":"","SeniorCommunityYN":"","Sewer":"Septic Tank","SpaFeatures":"","SpaYN":"0","SpecialListingConditions":"","StandardStatus":"","StateRegion":"","StoriesTotal":"0","StructureType":"","TaxAnnualAmount":"0.00","Utilities":"Electricity Connected, Fuel:Natural","View":"","ViewYN":"0","VirtualTourURLUnbranded":"","WalkScore":"0","WaterBodyName":"","WaterSource":"Public","WaterfrontFeatures":"","WaterfrontYN":"1","WindowFeatures":"","YearBuilt":"2018","Zoning":"","ZoningDescription":"","headline_txt":"","description_txt":"","property_uid":"20250107175051552664000000","listing_status":"active","mls_status":"Active Under Contract","mls_id":"ky239","listing_num":"1677708","acreage":"","acres":"3.66","address":"","address_direction":"","address_flg":"1","address_num":"3602","agent_id":"22523","area":"20-Oldham County N171","baths_total":"11.00","bedrooms_total":"6","car_spaces":"5","city":"Prospect","coseller_id":"","coagent_id":"23484","days_on_market":"0","finished_sqft_total":"14546","geocode_address":"3602 River Ridge Cove","geocode_status":"","lat":"38.372788","lon":"-85.624249","map_flg":"true","office_id":"16403","office_name":"Lenihan Sotheby's International Realty","orig_price":"6995000","photo_count":"51","photo_count_lac":"51","previous_price":"0","price":"6995000","prop_img":"https:\/\/cdn.photos.sparkplatform.com\/lou\/20250107175603215243000000-o.jpg","property_type":"Residential","property_subtype":"Single Family Residence","sqft_total":"10546","state":"KY","street_type":"Cove","street_name":"River Ridge","sub_area":"RIVER GLEN","unit":"","zip_code":"40059","listing_dt":"2025-01-08","undercontract_dt":"0000-00-00","openhouse_dt":null,"price_change_dt":"0000-00-00","seller_id":"","seller_office_id":"","sold_dt":"0000-00-00","sold_price":"0","webapi_update_dt":"2025-09-19 13:12:02","update_dt":"2025-09-19 13:24:06","create_dt":"2025-07-15 17:24:57","marketing_headline_txt":null,"use_marketing_description_txt":null,"banner_flg":null,"banner_headline":null,"banner_location":null,"banner_description":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}