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.
Pending
$824,900
247 Lear St, Columbus, OH 43206
4beds
2,683sqft
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
- 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#: 226029899
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
| Date | Event | Price |
|---|---|---|
| 8/10/2026 | Pending sale | $824,900$307/sqft |
Source: | ||
| 8/7/2026 | Listed for sale | $824,900+60.2%$307/sqft |
Source: | ||
| 12/7/2020 | Sold | $515,000+9.7%$192/sqft |
Source: Public Record Report a problem | ||
| 8/5/2004 | Sold | $469,400$175/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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






