Water Views - Master on Main
871 Squire Oaks Drive Villa Hills, KY
$ 690,000
Property Attributes
  • MLS#543761
  • TypeSingle Family
  • CountyKENTON
  • CityVilla Hills
  • AreaCr Sp-Cr Pk-Ft Wr-Kent Hi-Park Hi-Villa Hi
  • NeighborhoodCountry Squire Estates
  • Zip41017
  • StyleTraditional
  • Price$ 690,000
  • Bedrooms4
  • Full Bathrooms3
  • Half Bathrooms0
  • Sqr Footage4014
  • Lot Size0.79 Acres
Listing Provided Courtesy Of:
Culbertson Real Estate Group - 859-384-6000
Property Description

Welcome to the prestigious Country Squire Estates. Custom built 4/5 bedrm/3 full bath's/full brick home situated on a private wooded .79 acre lake view lot. 1st & 2nd flr owners master suites great for multi generation living, Open 2nd flr master suite w/marble fpl, 2nd flr private bedroom suite w/adjoining living rm/study for bedrooms 3 & 4. Elegant 2 story living rm w/beautiful chiseled stone fpl w/lg planked wd flrs & wet bar. Grand staircase, 1st flr jacuzzi/solarium, grand open foyer, full walk out basement w/full bath & fireplace rough in. 2nd flr unfinished 25x22 5th bed/storage rm.

Elementary School Middle School High School
River Ridge Elementary Turkey Foot Middle School Dixie Heights High
Price History
11/13/2020 Listed $690,000

General Features

Appliances Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator
Architectural Style Traditional
Attached Garage Yes
Construction Materials Brick
Cooling Central Air
Elementary School River Ridge Elementary
Elementary School District Kenton Co Public
Exterior Features Deck, Sprinkler/Irrigation, Landscape Lights, Porch
Flooring Vinyl
Garage Spaces 2
Garage Y/N Yes
Heating Gas
High School Dixie Heights High
High School District Kenton Co Public
Interior Features Atrium, Attic, Beamed Ceilings, Ceiling Fan(s), Crown Molding, Eat-in Kitchen, French Door(s)/Atrium Door(s), Handicap Access, High Ceilings, Laundry Chute, Loft, Main Level Master, Pantry, Recessed Lighting
Levels Two
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
Parking Features Attached, Driveway, Garage, Oversized, Rear/Side/Off Street, On Street, Garage Door Opener
Patio/Porch Features Deck, Porch
Pets Allowed Yes
Property SubType Single Family Residence
Property Type Residential
Roof Shingle
Security Features Security System, Smoke Detector(s)
Sewer Public Sewer
Stories 2
Subdivision Name Country Squire Estates
Terms Cash, Conventional, FHA, VA Loan
Utilities Natural Gas Available
View Lake, Trees/Woods
Zoning Description Residential

Interior Features

Air Conditioning Y/N Yes
Basement Full, Bath/Stubbed, Unfinished, Walk-Out Access
Fireplace Features Gas, Marble, Stone, Wood Burning
Fireplace Y/N Yes
Full Baths 3
Heating Y/N Yes
Laundry Features Main Level, Laundry Chute
Living Area 4014
Total Baths 3
Total Bedrooms 4
Total Fireplaces 2
Total Rooms 12
Window Features Bay Window(s), Casement Window(s), Display Window(s), Wood Frames, Window Treatments

Exterior Features

Door Features French Doors, Panel Doors
Foundation Details Poured, Concrete Perimeter
Lot Dimensions 175x172
Lot Features 1/2 to 1 Acre Lot, Wooded
Lot Size Acres 0.79
Lot Size Square Feet 34412
View Y/N Yes
Water Source Public

Room Details

Room Dimensions Level Flooring Details
Bathroom 2 Second
Bathroom 3 First
Bedroom 2 19x14 Second
Bedroom 3 18x13 Second
Bedroom 4 15x12 Second
Bonus Room 13x13 First
Dining Room 15x13 First Carpet
Entry/Foyer 12x10 First
Family Room 15x12 First Carpet
Kitchen 18x14 First
Laundry 12x9 First
Living Room 27x19 First Wood
Loft 19x7 Second
Master Bathroom First
Master Bedroom 19x14 First
Other 25x22 Second
Recreation 13x13 First
Sauna 13x13 First
Study 21x8 Second


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

Property vs Zip Code Average in 41017

AVG $540K
AVG 43
Year Built
AVG 1972

Looking for a more comfortable experience?

Download our mobile app for a personalized browsing experience.