NOT LISTED FOR SALE

3313 Turkeyfoot Rd Edgewood, KY 41017

Estimated Value: $2,975,000 - $3,992,000

6 Beds
8 Baths
975 Sq Ft
$3,633/Sq Ft Est. Value

Last Sold November 13, 2023

Last sale price $3,836,000 $3,934 Per Sq Ft

Est. 8% decrease in value since last sale

Current estimated payment $23,045/month

71 Days on Market

Highlights

  • Guest House
  • Pool House
  • Lake View
  • Hinsdale Elementary School Rated A-
  • Eat-In Gourmet Kitchen
  • Waterfront

About This Home

As of November 2023

TRULY ABSOLUTE AUCTION, WITHOUT RESERVE by DeCaro Auctions International on Saturday, October 14, 2023 at 11AM Local
Time. This live, on-site, No Reserve Absolute Auction will be sold to the highest bidder. Previews by APPOINTMENT ONLY will begin Saturday, September 23, 2023 and will continue every Saturday & Sunday from 1-4PM until the Auction. Broker participation is invited, 2%. Private showings are available during the week by appointment. Phenomenal Work of Art Perfectly Appointed on 7+ Stunning ACRES! Breathtaking 15,000 SQ FT French Chateau-Themed Masterpiece
Built by Tim Burks/Gorgeous, Infinity Pool, Hot Tub, & Pool Home w/Living Quarters/Enjoy the Unparalleled Luxury this Extraordinary 6 BDRM, 8 Bath, 4 Car
Garage Mansion can Provide/Gourmet KIT/Sitting RM Off Owner's Suite/Magnificent Theatre RM/5 Fireplaces/Intricate Design/Elaborate Millwork/Goldleaf &
Copperleaf Accents/Unbelievable Quality & Workmanship/Handcrafted Appointments/+MUCH MORE! Dramatic European Architecture Abounds this Truly One of a Kind Exquisite Gem!

Last Listed By

Jane Ashcraft-West

RE/MAX Victory + Affiliates License #187308 Listed on: 08/03/2023

RE/MAX Victory + Affiliates

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $39,319

Year Built

  • Built in 2013

Lot Details

  • 7.05 Acre Lot
  • Waterfront
  • Private Entrance
  • Wooded Lot

Parking

  • 4 Car Garage
  • Side Facing Garage
  • Driveway
  • Off-Street Parking

Property Views

  • Lake
  • Pond
  • Woods

Home Design

  • Transitional Architecture
  • Poured Concrete
  • Slate Roof
  • Block And Beam Construction

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Wired For Sound
  • Wired For Data
  • Built-In Features
  • Bookcases
  • Woodwork
  • Crown Molding
  • Beamed Ceilings
  • Tray Ceiling
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Wood Burning Fireplace
  • Marble Fireplace
  • Stone Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • Bay Window
  • Wood Frame Window
  • Casement Windows
  • Aluminum Window Frames
  • Double Door Entry
  • French Doors
  • Panel Doors
  • Family Room with Fireplace
  • 5 Fireplaces
  • Family Room with entrance to outdoor space
  • Living Room with Fireplace
  • Sitting Room
  • Breakfast Room
  • Formal Dining Room
  • Library
  • Loft
  • Bonus Room
  • Game Room

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island
  • Solid Surface Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Carpet
  • Concrete
  • Marble

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Fireplace in Primary Bedroom
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Dressing Area
  • Granite Bathroom Countertops
  • Dual Vanity Sinks in Primary Bathroom
  • Jetted Soaking Tub in Primary Bathroom
  • Primary Bathroom Bathtub Only
  • Soaking Tub
  • Primary Bathroom includes a Walk-In Shower

Laundry

  • Laundry Room
  • Laundry on main level

Basement

  • Walk-Out Basement
  • Stubbed For A Bathroom
  • Rough-In Basement Bathroom

Home Security

  • Home Security System
  • Fire and Smoke Detector

Pool

  • Pool House
  • In Ground Pool
  • Spa

Outdoor Features

  • Balcony
  • Deck
  • Enclosed patio or porch
  • Water Fountains
  • Exterior Lighting
  • Gazebo
  • Outdoor Grill

Additional Homes

  • Guest House

Schools

  • R.C. Hinsdale Elementary School
  • Turkey Foot Middle School
  • Dixie Heights High School

Utilities

  • Forced Air Heating and Cooling System
  • Geothermal Heating and Cooling
  • 220 Volts
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 016-30-09-010.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$39,319

Year Built

Built in 2013

Lot Details

0

Parking

4

Listing Details

  • Cooling: Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 7.05
  • Year Built: 2013
  • Lot Size: 7.054 Acres!
  • Directions: I-275 to Turkeyfoot exit. Follow Turkeyfoot South, property is located on left side of street between Colony and Meadowlark.
  • Architectural Style: Transitional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: R.C. Hinsdale Elementary
  • Location Tax Legal Info:Middle or Junior School: Turkey Foot Middle School
  • Location Tax Legal Info:High School: Dixie Heights High
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 3
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: 7.054 Acres!
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities:Natural Gas Available: Yes
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 7.054
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Security Features:Smoke Detector(s): Yes
  • Room Type:Loft3: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 016-30-09-010.00
  • Appliances Refrigerators: Yes
  • Room Type:Living Room4: Yes
  • General Property Description:Fireplaces Total: 5
  • View:TreesWoods: Yes
  • Architecture:Transitional: Yes
  • Room Type:Bonus Room2: Yes
  • Room Type:Game Room: Yes
  • Room Type:Game Room Level: First
  • Room Type:Library: Yes
  • Security Features:Security System: Yes
  • Pool Features:In Ground: Yes
  • View:Pond2: Yes
  • Entry Features:Entrance Foyer: Yes
  • Roof:Slate: Yes
  • Laundry Room Features:Built-in Features6: Yes
  • View:Lake2: Yes
  • Other Structures:Pool House: Yes
  • Entry Features:Private Entry: Yes
  • Other Structures:Gazebo: Yes
  • Other Structures:Guest House: Yes
  • Library Features:Wood Flooring6: Yes
  • Loft Features:High Ceiling(s)5: Yes
  • Bonus Room Features:High Ceiling(s)2: Yes
  • Library Features:Bookcases3: Yes
  • Entry Features:Marble Flooring: Yes
  • Loft Features:Wood Flooring10: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Wet Bar, Walk-In Closet(s), Tray Ceiling(s), Soaking Tub, Pantry, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Chandelier, Breakfast Bar, Built-in Features, 220 Volts, Beamed Ceilings, Cathedral Ceiling(s), Ceiling Fan(s), French Doors, High Ceilings, Multi Panel Doors, Natural Woodwork, Recess Ceiling(s), Recessed Lighting, Vaulted Ceiling(s), Wired for Data, Wired for Sound
  • Basement: Bath/Stubbed, Walk-Out Access
  • Heating: Geothermal, Forced Air
  • Levels: Two
  • Flooring: Concrete
  • Property Type: Residential
  • Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Wine/Beverage Cooler
  • Full Bathrooms: 5
  • Half Bathrooms: 3
  • Total Bedrooms: 6
  • Fireplace Features: Stone, Gas, Marble, Wood Burning
  • Fireplaces: 5
  • Fireplace: Yes
  • Window Features: Aluminum Clad Window(s), Bay Window(s), Bow Window(s), Casement, Insulated Window(s), Vinyl Clad Window(s), Wood Frames
  • Appliances Dishwasher: Yes
  • Interior Features:Built-in Features2: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Entrance Foyer2: Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Interior Features:Wet Bar4: Yes
  • Interior Features:Wired for Data: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Basement:Full Bath Rough In: Yes
  • Basement:Walk-Out Access7: Yes
  • Interior Features:French Doors: Yes
  • Kitchen Features Pantry: Yes
  • Kitchen Features:Wood Cabinets: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Carpet Flooring5: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Living Room Features:Walk-Out Access: Yes
  • Kitchen Features:Walk-Out Access3: Yes
  • Primary Bath Features:Shower: Yes
  • Basement:Concrete Flooring: Yes
  • Interior Features:Natural Woodwork: Yes
  • Fireplace Features:Wood Burning: Yes
  • Interior Features:Crown Molding: Yes
  • Living Room Features:Wood Flooring2: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Family Room Features:Fireplace(s)4: Yes
  • Family Room Features:Walk-Out Access4: Yes
  • Kitchen Features:Wood Flooring4: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Fireplace Features:Gas: Yes
  • Living Room Features:Fireplace(s): Yes
  • Interior Features:Breakfast Bar2: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Interior Features:Chandelier2: Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Dining Room Features:Chandelier: Yes
  • Dining Room Features:Walk-Out Access2: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Primary Bath Features:Soaking Tub2: Yes
  • Kitchen Features:Solid Surface Counters: Yes
  • Primary Bath Features:Granite Countertops2: Yes
  • Primary Bedroom Features:High Ceiling(s)6: Yes
  • Interior Features:Recessed Lighting: Yes
  • Primary Bath Features:Jetted Tub: Yes
  • Interior Features:Soaking Tub: Yes
  • Interior Features:Wired for Sound: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Primary Bedroom Features:Wood Flooring7: Yes
  • Fireplace Features:Stone4: Yes
  • Interior Features:Recess Ceiling(s): Yes
  • Primary Bedroom Features:Recessed Lighting7: Yes
  • Primary Bath Features:Tub: Yes
  • Family Room Features:Wood Flooring5: Yes
  • Primary Bedroom Features:Fireplace(s)6: Yes
  • Interior Features:Beamed Ceilings: Yes
  • Primary Bedroom Features:Sitting Room: Yes
  • Primary Bedroom Features:Dressing Area: Yes
  • Primary Bath Features:Marble Flooring3: Yes
  • Interior Features:Tray Ceiling(s): Yes
  • Kitchen Features:Crown Molding2: Yes
  • Appliances:WineBeverage Cooler: Yes
  • Family Room Features:French Doors3: Yes
  • Dining Room Features:Recessed Lighting8: Yes
  • Fireplace Features:Marble: Yes
  • Dining Room Features:French Doors2: Yes
  • Living Room Features:Wet Bar: Yes

Exterior Features

  • View: Lake, Pond, Trees/Woods
  • Roof: Slate
  • Lot Features: Waterfront, Wooded
  • Pool Features: In Ground
  • View: Yes
  • Construction Type: Block
  • Exterior Features: Balcony, Fountain, Hot Tub, Lighting, Outdoor Grill
  • Foundation Details: Poured Concrete
  • Other Structures: Gazebo, Guest House, Pool House
  • Patio And Porch Features: Covered, Deck, Enclosed, Patio, Porch
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Window Features:Vinyl Clad Window(s): Yes
  • Construction Materials:Block3: Yes
  • Lot Features:Wooded: Yes
  • Window Features:Bay Window(s): Yes
  • Exterior Features:Lighting: Yes
  • Window Features:Aluminum Clad Window(s): Yes
  • Window Features:Wood Frames: Yes
  • Exterior Features:Outdoor Grill: Yes
  • Patio and Porch Features:Enclosed: Yes
  • Window Features:Bow Window(s): Yes
  • Exterior Features:Balcony: Yes
  • Lot Features:Waterfront: Yes
  • Exterior Features:Fountain: Yes
  • Window Features:Casement: Yes
  • Exterior Features:Hot Tub: Yes
  • Entry Features:Double Doors: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Detached, Driveway, Garage Faces Side, Off Street, Oversized
  • General Property Description:Garage Spaces: 4.0
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Off Street2: Yes
  • Parking Features:Detached: Yes
  • Parking Features:Oversized: Yes
  • Parking Features:Garage Faces Side: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Laundry Room, Main Level
  • Security: Security System, Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available
  • Heating:Forced Air: Yes
  • Heating:Geothermal: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: R.C. Hinsdale Elementary
  • Junior High Dist: Kenton Co Public
  • High School: Dixie Heights High
  • Middle Or Junior School: Turkey Foot Middle School

Lot Info

  • Lot Size Sq Ft: 307272.24
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 3, 2023
Closed on
Nov 13, 2023
Sold by
Joseph P Thomas Revocable Trust
Bought by
Mittal Deepak and Mittal Bahar
Seller's Agent
Jane Ashcraft-West
RE/MAX Victory + Affiliates
Buyer's Agent
Outside Agent
Outside Sales
List Price
$6,900,000
Sold Price
$3,836,000
Premium/Discount to List
-$3,064,000
-44.41%
Total Days on Market
71
Views
560
Current Estimated Value
$3,541,740

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$294,260
Avg. Annual Appreciation
-4.58%

Purchase Details

Closed on
Aug 6, 2010
Sold by
Pilgram William D
Bought by
Thomas Joseph P

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Mittal Deepak $3,836,000 Springdale Title
Thomas Joseph P $818,000 Chicago Title Ins Co
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/13/2023 11/13/23 Sold $3,836,000 +12.0% $3,934 / Sq Ft
11/13/2023 11/13/23 Sold $3,425,000 -50.4% $228 / Sq Ft
10/14/2023 10/14/23 Pending -- -- --
10/14/2023 10/14/23 Pending -- -- --
08/03/2023 08/03/23 For Sale $6,900,000 0.0% $7,077 / Sq Ft
06/07/2023 06/07/23 Price Changed $6,900,000 -23.3% $460 / Sq Ft
05/27/2022 05/27/22 For Sale $8,995,000 -- $600 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $39,319 $3,836,000 $818,000 $3,018,000
2023 $73,198 $7,000,000 $818,000 $6,182,000
2022 $34,026 $3,213,000 $818,000 $2,395,000
2021 $34,756 $3,213,000 $818,000 $2,395,000
2020 $32,320 $2,918,000 $818,000 $2,100,000
2019 $32,424 $2,918,000 $818,000 $2,100,000
2018 $32,518 $2,918,000 $818,000 $2,100,000
2017 $31,585 $2,918,000 $818,000 $2,100,000
2015 $30,708 $2,918,000 $818,000 $2,100,000
2014 $30,183 $2,918,000 $818,000 $2,100,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 615870

Northern Kentucky Multiple Listing Service

APN: 016-30-09-010.00