875 Squire Oaks $2,950,000

    Close

    875 Squire Oaks Villa Hills, KY 41017

    • 4 Beds
    • 7 Baths
    • Single-Family
    • MLS# 550447
    Favorite Share
    Views: 2170 Days On Site: 103

    Go Tour This Listing

    Schedule A Showing

    Property Details

    Description Tours

    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
      • Area Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
      • Pool Features In Ground
      • View Lake
      • View Y/N 1
      • Year Built 1984
    • Building Features
      • Appliances Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator
      • Basement Full,Finished,Walk-Out Access
      • Full Bathrooms 4
      • Half Bathrooms 3
      • Cooling Central Air
      • Exterior Features Deck, Landscape Lights, Pool, Porch, Patio
      • Cooling Y/N 1
      • GarageSpaces 7
      • Garage Y/N 1
      • Heating Forced Air, Gas
      • Heating Y/N 1
      • 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
      • Roof Shingle
    • Property Features
      • Lot Features 1 to 5 Acres, Flag Lot
      • Lot Size Acres 3.3
      • Sewer Public Sewer
      • Parking Features Attached, Driveway, Heated Garage, Oversized, Rear/Side/Off Street, Garage Door Opener

    Contact

    Lara Camden

    Lara Camden

    Sales Associate

    Florence

    Cell: 859-240-4362
    • Cinch Home Services
    • HSA Home Warranty

    Neighborhood

    41017 (Villa Hills) Demographics

    38 Median Age
    1,831 Population Density (per sq. mile)
    53% College Educated
    $83,561 Estimated Median Income
    11,305 Estimated Total Home Owners
    3,987 Estimated Total Renters
    74% / 26% Estimated Owner / Renter Divide
    3 Estimated Average Household Size
    40,198 Total Population
    Community data courtesy of LiveBy, Inc.

    Market Last 30 Days In This Postal Code

    $249,900 Median Sales Price
    57 Homes Sold
    73 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,950,000
        7/6/2021 2:52:00 PM New in Database Source: Multiple Listing Service New Value: $2,950,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.