Water Views - Primary on Main
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) - 167 - KY
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

Appliances Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator
Architectural Style Contemporary
Basement Full, Finished, Walk-Out Access
Construction Materials Stone, Stick Built
Cooling Central Air
Electric 220 Volts
Elementary School River Ridge Elementary
Elementary School District Kenton Co Public
Exterior Features Deck, Landscape Lights, Pool, Porch, Patio
Flooring Wood
Garage Spaces 7
Garage Y/N Yes
Heating Forced Air, Gas
High School Dixie Heights High
High School District Kenton Co Public
Interior Features Eat-in Kitchen, Elevator, Granite Counters, Gourmet Kitchen, High Ceilings, Hot Tub/Spa, Kitchen Island, Main Level Master, Pantry, Stone Counters, Sauna, Cable TV, Walk Out, Wood Cabinets
Levels Two
Lot Size Square Feet 143748
MLS Area Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
Middle/Junior High School Turkey Foot Middle School
Middle/Junior School District Kenton Co Public
Mlsareaminor Villa Hills
Other Structures Guest House
Patio/Porch Features Deck, Enclosed, Patio, Porch
Pool Features In Ground
Private Pool Yes
Property Sub Type Additional Single Family Residence
Property SubType Single Family Residence
Property Type Residential
Roof Shingle
Security Features Security System, Smoke Detector(s)
Sewer Public Sewer
Status Active
Stories 2
Subdivision Name Country Squire Estates
Total Rooms 14
Utilities Natural Gas Available
View Lake
Virtual Tour https://vimeo.com/569433855/dd8b509264
Zoning Description Residential

Interior Features

Air Conditioning Y/N Yes
Fireplace Features Gas, Marble, Basement
Fireplace Y/N Yes
Full Baths 4
Half Baths 3
Heating Y/N Yes
Laundry Features Main Level
Total Baths 7
Total Bedrooms 4
Total Fireplaces 3
Window Features Casement Window(s), Insulated Windows

Exterior Features

Foundation Details Poured
Lot Dimensions 3.3
Lot Features 1 to 5 Acres, Flag Lot
Lot Size Acres 3.3
Parking Features Attached, Driveway, Heated Garage, Oversized, Rear/Side/Off Street, Garage Door Opener
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 $860K
$2.95M
Visits
AVG 71
221
Year Built
AVG 1979
1984

Looking for a more comfortable experience?

Download our mobile app for a personalized browsing experience.