247 Lear Street, Columbus, OH 43206 (MLS # 226029899)

Brought to you by RE/Max Consultant Group
Save to Favorites
Print
Share
PRICE $840,000 dsIDX morgage calculator
BEDS 4
BATHS 4
HOME SIZE 2,333 sqft
LOT SIZE 6,099 sqft

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.

DAYS ON MARKET 27 LAST UPDATED 9/3/2026
TRACT German Village YEAR BUILT 1860
COUNTY Franklin STATUS Sold
PROPERTY TYPE(S) Single Family


ADDITIONAL DETAILS
AIR Central Air
AIR CONDITIONING Yes
APPLIANCES Dishwasher, Gas Range, Microwave, Refrigerator
BASEMENT Full, Walk-Out Access, Yes
CONSTRUCTION Brick
FIREPLACE Yes
GARAGE Yes
HEAT Forced Air, Natural Gas
INTERIOR Eat-in Kitchen
LOT 6098 sq ft
PARKING No Garage
SEWER Public Sewer
STYLE Farmhouse
SUBDIVISION German Village
TAXES 10593
WATER Public
MORTGAGE CALCULATOR
   

TOTAL MONTHLY PAYMENT

0
P
I
*Estimate only

SATELLITE VIEW



 
CONTACT US ABOUT 247 LEAR STREET
We respect your online privacy and will never spam you. By submitting this form with your telephone number you are consenting for The Village Partners to contact you even if your name is on a Federal or State "Do not call List".

Listing provided by The Brokerage House, Brittany E Stockdale
Listing information is deemed reliable, but not guaranteed.

This IDX solution is (c) Diverse Solutions 2026.