Skip main navigation
Sold for $840,000
  • $840,000

    247 Lear St, Columbus, OH 43206

    4beds
    2,683sqft
    Single Family Residence
    Built in 1860
    6,098 Square Feet Lot
    $836,000 Zestimate®
    $313/sqft
    $4,633 Estimated rent

    Home value

    $836,000

    $794,000 - $878,000

    $4,633/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,633/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

    $4,633/mo

    Rent Zestimate®

    Refinance and save

    $5,861/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

    $5,861/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

    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.

    Zillow last checked:

    Listing updated:

    Listed by:

    Brittany E Stockdale 614-302-0030,

    The Brokerage House

    Bought with:

    Aria Alaudini, 2012002377

    Mid Ohio Real Estate, LLC.

    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: $313/sqft
    • Tax assessed value: $672,300
    • Annual tax amount: $10,593
    • Date on market: 8/7/2026
    • Listing terms: VA Loan,FHA,Conventional

    Price history

    DateEventPrice
    9/3/2026Sold$840,000+1.8%$313/sqft
    Source: Columbus and Central Ohio Regional MLS #226029899 Report a problem
    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
    2025$10,593 +0.3%$235,310
    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

    Neighborhood: German Village

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $836,000
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $836,000