875 Squire Oaks Drive $2,500,000

    Close

    875 Squire Oaks Drive Villa Hills, KY 41017

    • 4 Beds
    • 5 Baths
    • Single-Family
    • MLS# 605283
    Favorite Share
    Views: 680 Days On Site: 49

    Go Tour This Listing

    Schedule A Showing

    Property Details

    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.

    • General Features
      • Bathrooms 5
      • Bedrooms 4
      • MLS Major Area K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
      • Pool Features In Ground
      • View Lake, Pond
    • Building Features
      • Appliances Dishwasher, Disposal, Microwave, Refrigerator
      • Architectural Style Contemporary
      • Basement Full
      • Construction Materials Stone
      • Cooling Central Air
      • Cooling Y/N true
      • Exterior Features Hot Tub, Lighting
      • Fireplace Features Gas,Marble
      • Fireplace Total 1
      • Fireplace Y/N true
      • Foundation Details Poured Concrete
      • Full Bathrooms 4
      • Garage Spaces 7.0
      • Half Bathrooms 1
      • Heating Forced Air
      • Heating Y/N true
      • Interior Features 220 Volts, Elevator, High Ceilings, Sauna
      • Window Features Casement,Insulated Window(s)
    • Property Features
      • Lot Features Flag Lot
      • Lot Size Acres 0
      • Parking Features Driveway
      • Patio And Porch Features Deck,Enclosed,Patio,Porch
      • Sewer Public Sewer
      • Utilities Cable Available,Natural Gas Available
    • Schools
      • Elementary School River Ridge Elementary
      • High School Dixie Heights High
      • Middle School Turkey Foot Middle School
      • School District Kenton Co Public

    Contact

    Kristian Connley PSA SRS

    Kristian Connley PSA SRS

    Realtor®

    Florence

    Office Phone: 859-525-5756
    • HSA Home Warranty

    Neighborhood

    41017 (Villa Hills) Demographics

    39 Median Age
    1,847 Population Density (per sq. mile)
    52% College Educated
    $84,360 Estimated Median Income
    11,844 Estimated Total Home Owners
    3,689 Estimated Total Renters
    76% / 24% Estimated Owner / Renter Divide
    3 Estimated Average Household Size
    40,557 Total Population
    Community data courtesy of LiveBy, Inc.

    Market Last 30 Days In This Postal Code

    $256,012 Median Sales Price
    48 Homes Sold
    69 New On Market

    Average Days on Site

      Properties for Sale

        Calculations provided by Reliance Network

        Property History

        Date Event Price Percent Change
        -- Current Price Source: Multiple Listing Service New Value: $2,500,000
        6/22/2022 4:17:00 PM New in Database Source: Multiple Listing Service New Value: $2,500,000

        Payment Calculator

        $0 per month
        Year Fixed, Interest
        Principal and Interest
        $0
        Property Taxes
        Homeowners' Insurance

        Home Price
        Down Payment
        * This payment calculator is intended for educational and planning purposes only.
        ** Assumes 3.5% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information.
        Information is provided in part by the IDX program of the Northern Kentucky Association of REALTORS® MLS. All information provided is deemed reliable but is not guaranteed and should be independently verified.

        Note: All room dimensions, including square footage data, are approximate and must be verified by the buyer. The information contained herein is furnished by the owner to the best of his/her knowledge but is subject to verification by the purchaser, and agent assumes no responsibility for the correctness thereof. The sale offering is made subject to errors, omissions, change of price, prior sale, or withdrawal without notice. In accordance with the Law, this property is offered without respect to race, color, creed, national origin, sex, familial status or disability. This is not intended to solicit property currently listed.