Water Views
Address
875 Squire Oaks Villa Hills, KY
Price
$ 2,950,000
Property Attributes
  • MLS#550447
  • TypeSingle Family
  • CountyKENTON
  • CityVilla Hills
  • AreaCr Sp-Cr Pk-Ft Wr-Kent Hi-Park Hi-Villa Hi
  • NeighborhoodCountry Squire Estates
  • Zip41017
  • StyleContemporary
  • Price$ 2,950,000
  • Bedrooms4
  • Full Bathrooms4
  • Half Bathrooms3
  • Lot Size3.3 Acres
Listing Provided Courtesy Of:
Huff Realty - Florence - 859-525-7900
Data Source:
Northern Kentucky MLS (NKAR)
Property Description

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.

Elementary School Middle School High School
River Ridge Elementary Turkey Foot Middle School Dixie Heights High
Price History
7/6/2021 Listed $2,950,000

General Features

Architectural Style Contemporary
Association Y/N No
Attached Garage No
Basement Full
Construction Materials Stone
Cooling Central Air
Exterior Features Hot Tub, Lighting
Full Baths 4
Garage Spaces 7.0
Half Baths 3
Heating Forced Air
Interior Features 220 Volts, High Ceilings, Elevator, Sauna
Levels Two
Lot Size Square Feet 143748.0
MLS Area K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
Mlsareaminor K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
New Construction No
Other Structures Guest House
Patio/Porch Features Porch, Enclosed, Patio, Deck
Pool Features In Ground
Property Attached Y/N No
Property SubType Single Family Residence
School District Kenton Co Public
Security Features Smoke Detector(s), Security System
Sewer Public Sewer
Structure Type House
Subdivision Name Country Squire Estates
Total Rooms 14
View Pond, Lake
Zoning Description Residential

Interior Features

Air Conditioning Y/N Yes
Fireplace Features Gas, Marble
Fireplace Y/N Yes
Heater Fuel Type Natural Gas
Heating Y/N Yes
Kitchen Appliances Dishwasher, Disposal, Microwave, Range, Oven, Refrigerator
Total Fireplaces 3
Window Features Casement, Insulated Window(s)

Exterior Features

Foundation Details Poured Concrete
Frontage Length 7
Land Lease Type Fee
Lot Dimensions 3.3
Lot Features Flag Lot
Lot Size Acres 3.3
Lot Size Area 3.3
Lot Size Units Acres
Parking Features Driveway
View Y/N Yes
Water Source Public

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Single Family Average in 41017

Price
AVG $970K
$2.95M
Visits
AVG 110
274
Year Built
AVG 1979
1984
Walkscore
AVG 21
12
Data Provided by Walkscore ® not using MLS data

Looking for a more comfortable experience?

Download our mobile app for a personalized browsing experience.