Skip main navigation
Pending
  • $824,900

    247 Lear St, Columbus, OH 43206

    4beds
    2,683sqft
    : 
    $5,975/mo
    Get pre-qualified
    Single Family Residence
    Built in 1860
    6,098 Square Feet Lot
    $-- Zestimate®
    $307/sqft
    $-- HOA

    What's special

    Light-filled family roomTimeless architectural detailsRare front lawnWelcoming foyerSpacious primary suiteSoaring cathedral ceilingsCustom cabinetry
    Tucked away on one of the most private lots in all of German Village, this hidden gem offers a setting unlike anything else in the neighborhood. Set back from the street behind a rare front lawn, the home feels secluded while placing you just steps from the very best of city living--short walk to Sycamore, Beck Tavern, Frank Fetch Park, and Lindey's. Believed to have originated as a historic barn, the home was thoughtfully expanded in the 1990s bringing it to 4 bedrooms and 3.5 bathrooms, creating the perfect blend of old-world character and modern living. Exposed brick, original hardwood floors, and timeless architectural details are complemented by a welcoming foyer, a light-filled family room, a formal dining room (or sitting room), and an expansive kitchen with incredible square footage and endless potential to create your dream culinary space. A convenient drop zone with first-floor laundry and a powder room complete the main level. Upstairs, the spacious primary suite is a true retreat with soaring cathedral ceilings, a generous walk-in closet, and a beautifully renovated spa-inspired bath featuring a soaking tub, walk-in shower, and custom cabinetry. The adjoining bedroom is ideal as a nursery, office, or sitting room and features its own updated ensuite bath. A third bedroom completes the second floor, while the finished third level provides the perfect bonus space for a playroom, home office, or hobby room. One of the home's most unexpected features is the rare finished basement--an exceptional find in German Village--complete with a fourth bedroom, egress, closets, and a beautifully updated full bath. An additional unfinished basement beneath the original home provides abundant storage. Offering unmatched privacy, generous living space, historic character, and one of the most walkable locations in Columbus, this is a truly rare opportunity to own a one-of-a-kind German Village home.
    23 days
    1,242
    61

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Brittany E Stockdale 614-302-0030,

    The Brokerage House

    Source: Columbus and Central Ohio Regional MLS ,MLS#: 226029899MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      Heating
      • Forced Air
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Gas Range, Microwave, Refrigerator
      Features
      • Flooring: Wood, Ceramic/Porcelain
      • Windows: Insulated Windows
      • Basement: Walk-Out Access,Full
      • Number of fireplaces: 1
      • Fireplace features: One, Decorative
      • Common walls with other units/homes: No Common Walls
      Interior area
      • Total structure area: 2,333
      • Total interior livable area: 2,683 sqft

      Property

      Features
      • Patio & porch: Patio
      • Fencing: Fenced
      Lot
      • Size: 6,098 Square Feet
      Details
      • Parcel number: 010046649

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Farmhouse
      • Property subtype: Single Family Residence
      Materials
      • Foundation: Block, Stone
      Condition
      • New construction: No
      • Year built: 1860

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      Community
      • Subdivision: German Village
      HOA
      • Has HOA: No
      Location
      • Region: Columbus

      Financial & listing details

      • Price per square foot: $307/sqft
      • Tax assessed value: $672,300
      • Annual tax amount: $10,593
      • Date on market: 8/7/2026
      • Listing terms: VA Loan,FHA,Conventional

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        8/10/2026Pending sale$824,900$307/sqft
        Source: Columbus and Central Ohio Regional MLS #226029899 Report a problem
        8/7/2026Listed for sale$824,900+60.2%$307/sqft
        Source: Columbus and Central Ohio Regional MLS #226029899 Report a problem
        12/7/2020Sold$515,000+9.7%$192/sqft
        Source: Public Record Report a problem
        8/5/2004Sold$469,400$175/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024$10,561 +1.3%$235,310
        2023$10,426 -8.1%$235,310 +7.6%
        2022$11,346 -0.2%$218,760
        2021$11,366 -2.6%$218,760
        2020$11,664 -2.2%$218,760 +14.1%
        2019$11,925 +0.2%$191,770
        2018$11,904 $191,770
        2017$11,904 +24.8%$191,770 +36.5%
        2016$9,543 +9.8%$140,460
        2015$8,688 $140,460
        2014$8,688 +112.4%$140,460 +5%
        2013$4,091 -48.9%$133,770
        2011$8,004 +14.8%$133,770 +9.2%
        2010$6,974 +5.6%$122,500
        2008$6,603 +19.6%$122,500
        2007$5,520 +0.4%--
        2006$5,501 -20.4%--
        2005$6,908 +32.2%--
        2004$5,223 +23.6%--
        2003$4,227 +0.4%--
        2002$4,211 +14.6%--
        2001$3,676 -0.5%--
        2000$3,694 --
        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.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: German Village

        Getting around

        90 / 100
        Very Walkable
        60 / 100
        Good Transit
        64 / 100
        Bikeable

        Nearby schools

        GreatSchools rating

        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