Skip main navigation
Off market
Street View
  • $247,900

    5690 Stiles Rd, New Haven, KY 40051

    4beds
    3,245sqft
    Single Family Residence
    Built in 1998
    8.84 Acres Lot
    $-- Zestimate®
    $76/sqft
    $2,257 Estimated rent

    Home value

    Not available

    Estimated sales range

    Not available

    $2,257/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $2,257/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,257/mo

    Rent Zestimate®

    Refinance and save

    $1,213/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $1,213/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Nestled on 9+/- serene, picturesque acres, this charming 4-bedroom, 2-bath, 3245 sq. ft. Cape Cod offers a blend of comfort, efficiency and versatility. The main level features Bruce hardwood flooring, while the fully finished walk-out basement boasts elegant travertine stone flooring throughout. Built with energy efficiency in mind, the home is equipped with spray foam insulation and 2 x 6 exterior and attic walls, a high-efficiency heat pump, as well as 2 pellet stoves providing toasty warmth on cold evenings. New windows and vinyl siding were installed in 2015 and a new roof was installed in 2022. The property is designed with both convenience and functionality in mind. An underground pet fence spans the entire yard, along with a 20x30 outdoor dog kennel that offers access to the oversized, climate controlled 2-car garage. Just beyond the garage is a mammoth 4,000 sq ft insulated, climate- controlled shop/warehouse with four automatic garage doors, water, electric, and a separate septic system offering a multitude of possibilities. Additional features include an industrial diesel generator that is fully automatic to power the entire home, a cistern for collecting and storing rainwater under the front porch, ample leveled/cleared outdoor space for outdoor activities from corn-hole to a game of catch. The amenities of this gorgeous property are too many to mention. Call this piece of paradise home today! 2025-01-27

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Zillow last checked: 23 hours ago

    Source: Semonin Realtors,MLS#: 1671163MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 2
    • Full bathrooms: 2
    Features
    • Basement: Yes
    Interior area
    • Total structure area: 3,245
    • Total interior livable area: 3,245 sqft

    Property

    Parking
    • Total spaces: 2
    Lot
    • Size: 8.84 Acres
    Details
    • Parcel number: 28A000003001

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Cape Cod
    • Property subtype: Single Family Residence
    Materials
    • Vinyl
    Condition
    • Year built: 1998

    Community & neighborhood

    Location
    • Region: New Haven
    • Subdivision: NONE

    Price history

    DateEventPrice
    1/29/2026Listing removed--
    Source: Owner Report a problem
    10/31/2025Price change$491,000-3.7%$151/sqft
    Source: Owner Report a problem
    9/11/2025Price change$510,000-4.7%$157/sqft
    Source: Owner Report a problem
    8/12/2025Listed for sale$535,000-2.7%$165/sqft
    Source: Owner Report a problem
    7/9/2025Listing removed$549,900$169/sqft
    Source: GLARMLS #1683803 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2023$2,630 +45.3%$247,900 +50.2%
    2022$1,810 -1.3%$165,000
    2021$1,833 +0.2%$165,000

    Find assessor info on the county website

    Neighborhood: 40051

    Nearby schools

    GreatSchools rating
    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.