247 Lear St, Columbus, OH

Name: 247 Lear St, For Sale in Columbus - Zoocasa
Brand: The Brokerage House
SKU: 226029899
Price: 824900 USD

House

For Sale

Listed price in listed location currency (USD).

$824,900

440

MLS® 226029899

Open House

Sun Aug 9, 1:00-3:00 PM EDT

Overview

Key Facts

Type Single Family Residence

Levels Residential

Size 2683 sqft

Garage

Taxes $10,593

Days Active 1

Lot Size 0.14 Acres

Approx. Age 1860

Avg. Price Per Sqft $307

MLS® Number 226029899

Property Address: 247 Lear St, Columbus, OH, 43206-1222

Average square foot calculated using Size range provided by listing agent.

Description

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.

MLS® Number226029899

Laundry Level

Central VacNo

FireplaceYes

Acreage

Exterior

Garage

Approx. Age1860

BasementFull, Walk-Out Access

Driveway

Garage Spaces

HeatForced Air

A/CCentral Air

Extras

How Much House Can I Afford?

Home Estimate Zoopraisal®

This property is estimated to sell between: $824,000 and $1,079,000.

Similar properties in this area sold on average for: $994,183

Expected to sell in 24 days. Similar properties sold in 25 days. This home has been on Zoocasa for 1 day.

The estimated sale price does not take into account many variables such as recent renovations, type of appliances, school district etc. To get a more accurate estimate please contact agent.

Map

Like what you see?

Complete the form and we'll be in touch. No login necessary.

Add a Comment

I want to view this property

Yes, I'd like to receive free weekly market insights and buying and selling tips. Unsubscribe at any time.

By pressing "Take a Tour", I confirm that I have read and agree to the eXp Privacy Policy, and Terms of Use.

By pressing "Take a Tour", I am electronically signing and consenting to receive marketing comms about real estate brokerage and mortgage lending services, delivered via email, phone and/or text (using "automated technology" such as an automatic telephone dialing system, and/or an artificial or prerecorded voice), from eXp Realty® and its independent contractor real estate professionals and their affiliate SUCCESS® Lending using the contact information I provided. Your consent is not a condition of purchase and you may revoke it at any time by replying "STOP" to any texts. Text HELP for more info. Message and data rates may apply. You may also contact us directly at 1-844-683-4664.

Similar Listings

Comparable Properties

The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA.

eXp Realty holds real estate brokerage licenses in multiple states. Zoocasa (Canada), Inc. holds real estate brokerage licenses in multiple provinces. For information on licenses please contact us at [email protected]

For listings in Canada, the trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.

MLS® Compliance Statements
Tony King – Designated Managing Broker, Broker Operations – TX.
Texas Real Estate Commission information about brokerage services
Texas Real Estate Commission Consumer Protection Notice

eXp Realty® is committed to adhering to the guidelines of The New York State Fair Housing Regulations. The Fair Housing Notice→

*Standardized Operating Procedure for Purchasers of Real Estate Pursuant to Real Property Law 442-H. Learn More→

eXp Realty of California, Inc. | CA DRE# 01878277 | Deborah Penny – Designated Broker
eXp Realty of Southern California, Inc. | CA DRE# 02187306 | Gina Saad – Designated Broker
eXp Realty of Greater Los Angeles, Inc. | CA DRE# 02188471 | Anita Cruz – Designated Broker
eXp Realty of Northern California, Inc. | CA DRE# 01951343 | Ryan Rosas Penny – Designated Broker
Fair Housing and Reasonable Accommodations
DMCA Notice

2026 AODA Compliance Report
Feedback can be submitted through our standard communication channels such as our internal chat platform, email, phone etc., and accommodations are available upon request. Zoocasa reviews all feedback received, acknowledges concerns, and works to respond in a timely manner. Feedback is assessed and addressed appropriately to support continuous improvement of our services and accessibility practices.