Skip main navigation
Pending
    • $599,900

    623 Bur Oak Ct W, Lafayette, IN 47909

    4beds
    3,290sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1995
    0.49 Acres Lot
    $576,500 Zestimate®
    $--/sqft
    $-- HOA

    What's special

    Firepit areaOpen patioCovered porchFull metal fenceEnormous upstairs bonus roomLarge double vanitiesStunning living spaces
    Custom. Custom. Custom. This spectacular one-owner ranch home in the desirable Red Oaks Subdivision offers an exceptional blend of quality, thoughtful design, and timeless craftsmanship. Featuring stunning living spaces, large bedrooms, an office with built-in desk and cabinetry, 2 full baths, 2 half baths, and an enormous upstairs bonus room, this home was built with details rarely found in today’s market. From the moment you enter, the quality is evident. Features include an ICF poured insulated concrete foundation, Pella casement windows with Low-E glass and built-in slim shades, an 8-foot double front door, solid core doors, an extra-wide hallway, crown molding, custom maple cabinetry throughout, and closets with organizational systems and automatic lighting. The primary suite is truly a retreat of its own, offering generous space, a stunning 12x23 custom maple wood closet that you must see to believe, large double vanities, and a spacious walk-in shower with rainfall effect. The updates are extensive, including a new roof in 2023, geothermal HVAC within the past 15 years, new cement board siding in 2025 with a 15-year factory warranty, LG washer/dryer in 2024, Kinetico water softener with whole-house filter and reverse osmosis drinking water system in 2024, tankless water heater with recirculating hot water lines in 2023, and much more. Step out back through the 8-foot French doors and discover a private backyard oasis, just waiting for social gatherings or peaceful afternoons. Enjoy the covered porch, open patio, firepit area, grilling space, full metal fence, irrigation system, and a tranquil waterfall feature controlled from inside the home. The heated garage is equally impressive with built-in storage and safe, a 220V outlet, and access to the extra-deep 40-inch crawlspace with lighting and clean space lining. Every inch of this home reflects pride of ownership, high-end custom finishes, and luxury details designed for comfort, function, and beauty. This is not just a home... it is a rare opportunity!
    23 days
    |
    2,055
    |
    80
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Jill L Davis Cell:765-414-0579,

    BerkshireHathaway HS IN Realty

    Source: IRMLS,MLS#: 202625710MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 4
      • Full bathrooms: 2
      • 1/2 bathrooms: 2
      • Main level bedrooms: 3
      Bedroom 1
      • Level: Main
      Bedroom 2
      • Level: Main
      Dining room
      • Level: Main
      • Area: 132
      • Dimensions: 11 x 12
      Kitchen
      • Level: Main
      • Area: 224
      • Dimensions: 14 x 16
      Living room
      • Level: Main
      • Area: 384
      • Dimensions: 24 x 16
      Office
      • Level: Main
      • Area: 165
      • Dimensions: 15 x 11
      Heating
      • Geothermal, Heat Pump, Geo Heat (Closed Loop)
      Cooling
      • Geothermal, Geothermal Hvac
      Appliances
      • Included: Disposal, Dishwasher, Microwave, Refrigerator, Washer, Dryer-Gas, Electric Range, Trash Compactor, Water Filtration System, Tankless Water Heater, Water Softener Owned
      • Laundry: Sink, Main Level
      Features
      • Breakfast Bar, Bookcases, Built-in Desk, Ceiling-9+, Tray Ceiling(s), Walk-In Closet(s), Stone Counters, Crown Molding, Eat-in Kitchen, Entrance Foyer, Natural Woodwork, Pantry, Double Vanity, Stand Up Shower, Main Level Bedroom Suite, Formal Dining Room, Custom Cabinetry
      • Flooring: Carpet, Vinyl, Ceramic Tile
      • Windows: Skylight(s), Window Treatments, Blinds
      • Basement: Crawl Space,Concrete
      • Number of fireplaces: 1
      • Fireplace features: Living Room, Gas Log
      Interior area
      • Total structure area: 3,290
      • Total interior livable area: 3,290 sqft
      • Finished area above ground: 3,290
      • Finished area below ground: 0
      Video & virtual tour

      Property

      Parking
      • Total spaces: 3
      • Parking features: Attached, Garage Door Opener, Heated Garage, Concrete
      • Attached garage spaces: 3
      • Has uncovered spaces: Yes
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Patio, Porch Covered
      • Exterior features: Fire Pit, Irrigation System
      • Fencing: Full,Metal
      Lot
      • Size: 0.49 Acres
      • Dimensions: 101x210
      • Features: Level, 0-2.9999, City/Town/Suburb, Landscaped
      Details
      • Parcel number: 791117401026.000031
      • Other equipment: Built-In Entertainment Ct

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Ranch
      • Property subtype: Single Family Residence
      Materials
      • Stone, Cement Board
      • Roof: Asphalt,Shingle
      Condition
      • New construction: No
      • Year built: 1995

      Utilities & green energy

      • Electric: REMC
      • Gas: CenterPoint Energy
      • Sewer: City
      • Water: City
      Green energy
      • Energy efficient items: HVAC, Insulation, Water Heater, Windows

      Community & HOA

      Community
      • Features: Sidewalks
      • Security: Security System, Carbon Monoxide Detector(s), Smoke Detector(s)
      • Subdivision: Red Oaks
      Location
      • Region: Lafayette

      Financial & listing details

      • Tax assessed value: $390,700
      • Annual tax amount: $2,653
      • Date on market: 6/29/2026
      • Listing terms: Cash,Conventional,FHA,VA Loan

        Estimated market value

        $576,500

        $548,000 - $605,000

        $2,633/mo

        Price history

        DateEventPrice
        7/13/2026Pending sale$599,900
        Source: IRMLS #202625710 Report a problem
        6/29/2026Listed for sale$599,900
        Source: IRMLS #202625710 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$2,642 +8.5%$390,700 +13.3%
        2024$2,434 +4.6%$344,800 +6.7%
        2023$2,327 +12.2%$323,100 +8.3%
        2022$2,074 +7.9%$298,400 +11%
        2021$1,922 +12.3%$268,900
        2020$1,711 +6.4%--
        2019$1,608 +22.9%$242,600 +3.5%
        2018$1,308 +3%$234,400 +19%
        2017$1,270 $197,000 +1.4%
        2016$1,270 +2.4%$194,200 +4.5%
        2014$1,240 +2%$185,900 -0.1%
        2013$1,216 $186,100
        2012-- $186,100 -6.4%
        2011-- $198,800 -13.4%
        2010-- $229,600 +3.3%
        2009$3,033 +102.7%$222,300 +5.1%
        2008$1,496 -28.3%$211,500 +3.7%
        2007$2,086 +4.5%$204,000 +3.9%
        2006$1,997 -5.3%$196,300
        2005$2,108 +10%$196,300
        2004$1,916 +3.1%$196,300
        2003$1,859 -1.6%$196,300 +62.8%
        2002$1,889 $120,600
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 47909

        Getting around

        2 / 100
        Car-Dependent
        0 / 100
        No Nearby Transit
        25 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Wea Ridge
        • Middle: Wea Ridge
        • High: Mc Cutcheon
        • District: Tippecanoe School Corp.

        Source: IRMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes

            Nearby cities

            Nearby neighborhoods

            Nearby zip codes

            Other Lafayette Topics

              Search
              Updates
              Favorites
              Plan
              Inbox