Active

247 Lear Street

Columbus, OH 43206
Mark as Favorite
Bed 4

Bed

Bath 4

Bath

SqFt2,683

Sqft

Acres0.14

Acre(Lot)

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 foo tage 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.

Read More Expand

Detail Ic Property Details

Property Type : Residential

Price : $824,900

AD Id : 89260124

MLS Id : 226029899

Beds : 4

Lot Size : 0.14 Acre

Living Area Size : 2,683

Year Built : 1860

County : Franklin

  • Map Map

Map

Map What's Nearby

Map Nearby Areas

Feature Features

  • Bedroom Information

    Total beds: 4

    Bathroom Information

    Total Baths: 4 Full Baths: 3 Half Baths: 1

    Room Information

    Has Basement: Yes Basement: Walk-Out Access, Full
  • Flooring Information

    Ceramic Tile, Wood
  • Interior Features

    Eat-in Kitchen Appliances: Dishwasher, Gas Range, Microwave, Refrigerator Laundry Features: Main Level Window Features: Insulated Windows
  • Heating & Cooling

    Has Heating: Yes Heating: Forced Air, Natural Gas Has Cooling: Yes Cooling: Central Air

  • Building Information

    Year Built: 1860 Building Area Total: 2333 Construction Materials: Brick Patio And Porch Features: Patio Private Pool: No

  • Lot Information

    Main Square Feet: 0.14 Lot Size Acres: 0.14 Lot Size Square Feet: 6098.4

    Property Information

    Subdivision: German Village Source Property Type: Residential Property SubType: Single Family Residence Property Age: 166

  • Listing Price Information

    Listing Price: $824900 FHA, Conventional, VA Loan

  • Tax Information

    Parcel Number: 010-046649 Tax Year: 2025 Annual Tax: $10593

  • Parking Information

    No Garage

  • Location Information

    Direction: GPS WaterSource: Public
Sell a home like this and save $48,995 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Images
Loading, please wait...

Nearby Home Value

Address Estimate Bed Bath Sq. Ft Lot Size
1771 E Sycamore Street, Columbus, OH, 43206 $135,900 2 2 1,000 1,000 SqFt
1633 E Gates Street, Columbus, OH, 43206 $164,900 3 1 912 912 SqFt
1736 E Frankfort Street, Columbus, OH, 43206 $257,500 3 3 1,650 1,650 SqFt
1692 E Kossuth Street, Columbus, OH, 43206 $159,900 3 1 984 984 SqFt
1671 E Whittier Street, Columbus, OH, 43206 $214,000 -- -- --
1644 E Columbus Street, Columbus, OH, 43206 $194,900 3 2 1,250 1,250 SqFt
1086 Seymour Avenue, Columbus, OH, 43206 $200,000 3 1 920 920 SqFt
1306 Seymour Avenue, Columbus, OH, 43206 $165,000 3 1 908 908 SqFt
1558 Forest Street, Columbus, OH, 43206 $319,900 4 2 1,512 1,512 SqFt
1435 E Mithoff Street, Columbus, OH, 43206 $234,500 3 2 1,246 1,246 SqFt

The data relating to real estate for sale on this site comes from the Broker Reciprocity/IDX of Columbus REALTORS®. No warranties, expressed or implied, are provided for the data herein, or for their use or interpretation by the user. Columbus REALTORS® does not create, control or review the property data displayed herein and take no responsibility for the content of such records. Federal law prohibits discrimination on the basis of race, color, religion, sex, handicap, familial status or national origin in the sale, rental or financing of housing. IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Information deemed reliable but not guaranteed. Copyright © 2026 Columbus REALTORS®. All rights reserved.

ByOwner last updated this listing 08/09/2026 @ 01:59

MLS: 226029899 LISTED BY: Brittany Stockdale, The Brokerage House 614-500-7870 SOURCE: Columbus and Central Ohio Regional MLS

Homes around $824,900

Selling? Save $48,995 when you sell a home like this

Tour with a ByOwner Agent