Mike Parker

Northern Kentucky Area Real Estate Search

875 Squire Oaks
Ft Mitchell, Kentucky KY 41017
$2,950,000 Price
Active Status
4 Bedrooms
4 Full Baths
7 Total Baths
3 Partial Baths
3.300 Acres
550447 Listing ID
STUNNING!!! Absolutely unbelievable home on 3.3 acres with heated pool, hot tub, carriage house, 7 car garage, lake, media room, massage room, exercise room. Kitchen with island, breakfast nook, lots of storage. Impressive 2 story entry. Elevator. First floor master suite with exquisite master bath. Two story study with fireplace, bookshelves, and separate entry. Theater room, Sauna, massage room, Lower level bar area with several walk outs. The tile thru-out this home is amazing. 2300 SF carriage house with elevator, 2 bedrooms,2 full baths. Carriage house is 3 levels with large basement.
Schedule Showing Virtual Tour
Status Active
County Kenton
Subdivision Country Squire Estates
Year Built 1984
Property Type Residential
Property Sub Type Single Family Residence

Primary Features

Half Baths: 3
County: Kenton
Property Sub Type: Single Family Residence
Property Type: Residential
Subdivision: Country Squire Estates
Year Built: 1984


Appliances: Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator
Basement: Full
Cooling: yes
Cooling Type: Central Air
Fireplace: yes
Fireplace Features: Gas, Marble
Fireplaces Total: 3
Heating: yes
Heating Type: Forced Air
Interior Features: 220 Volts, Elevator, High Ceilings, Sauna
Levels: Two
Rooms Total: 14


Architectural Style: Contemporary
Attached Garage: no
Construction Materials: Stone
Exterior Features: Hot Tub, Lighting
Foundation Details: Poured Concrete
Frontage Length: 7
Garage Spaces: 7
Lot Features: Flag Lot
Lot Size Area: 3.3
Lot Size Dimensions: 3.3
Lot Size Square Feet: 143748
Lot Size Units: Acres
New Construction: no
Other Structures: Guest House
Parking Features: Driveway
Patio And Porch Features: Deck, Enclosed, Patio, Porch
Pool Features: In Ground
Property Attached: no
Sewer: Public Sewer
Structure Type: House
Utilities: Cable Available, Natural Gas Available
Water Source: Public
Window Features: Casement, Insulated Window(s)


Association: no
City: Villa Hills
Directions: Buttermilk Pike to Rosewood to Squire Oaks
Elementary School: River Ridge Elementary
High School: Dixie Heights High
High School District: Kenton Co Public
Middle Or Junior School: Turkey Foot Middle School
MLS Area Major: K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
MLS Area Minor: K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
View: yes
View Type: Lake, Pond
Zoning Description: 1


Documents Count: 1


Zoning Info

Contact - Listing ID 550447

Yes* No*

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Mike Parker

60 Cavalier Blvd
Florence, KY 41042
Phone: 859-647-0700

Data services provided by IDX Broker