Movoto Real Estate
Sold on 09/03/2026
  • Exterior
  • Entry Way
  • Kitchen
  • Dining
  • Other
  • Living
  • Bedroom
  • Bath

247 Lear St, Columbus, OH 43206

$840,000

Last sold 09/03/2026 after 27 Days

  • 4

    bed

  • 4

    bath

  • 2,683

    Sqft ($313/Sqft)

House not for sale

About 247 Lear St

Property type House
Neighborhood
Year built 1860
HOA fee $0/month
Lot size 6,098 Sqft
Rental estimate
Property 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.
Listed by
Listing Agent - Brittany E Stockdale
Listing Agent Contact: 614-500-7870
Listing Office - The Brokerage House
Source: Columbus and Central Ohio Regional MLS mls logo
MLS#226029899 • last updated 1 month ago
Movoto checked Columbus and Central Ohio Regional MLS for data 6 minutes ago
Overview
Cooling/AC Central Air
Heating Forced Air
Levels/Style Farmhouse
MLS # 226029899
Status Closed
SubType Single Family Residence
Living Area 2683
Lot Size (SqFt) 6098.4
Lot Size (Acres) 0.14
Property Tax 10593
Year Built 1860
Interior
# of Full Baths 3
Total # of Bathrooms 4
# of Half Baths 1
Total # of Bedrooms 4
Flooring Wood, Ceramic/Porcelain
Interior Features Garden/Soak Tub
Fireplace One, Decorative
Exterior
Foundation Block, Stone
Amenities / Utilities
Water Source Public
Location
Subdivision German Village
High School District COLUMBUS CSD 2503 FRA CO.
APN 010-046649
Directions GPS
We are not permitted to show value estimates for this property.
  • Sep 2026
    mls logo MLS # 226029899
  • Sep 3, 2026 Sold
    $840,000 (+1.8%)
  • Aug 10, 2026 Pending
    —
  • Aug 7, 2026 Listed
    $824,900
  • Year Property taxes Tax assessment
  • 2024
    $10,593 +0.3%
    $235,310
  • 2023
    $10,561 -6.9%
    $235,310 +7.57%
  • 2022
    $11,346 -0.2%
    $218,760
  • 2021
    $11,366 -2.6%
    $218,760
  • 2020
    $11,664 -2.2%
    $218,760 +14.07%
  • 2019
    $11,925 +0.2%
    $191,770
  • 2018
    $11,904 -0.1%
    $191,770
  • 2017
    $11,922 +24.9%
    $191,770 +36.53%
  • 2016
    $9,543 +9.8%
    $140,460
  • 2015
    $8,688 -0.2%
    $140,460
  • 2014
    $8,709
    —
  • 247 Lear St
    $840K
  • German Village
    $650K -13% y/y
  • 43206
    $299K -8% y/y
  • Columbus
    $269K -3% y/y
No chart available
Statistics calculated by Movoto
Est. value Bed/bath Sqft mi
651 S 6th St, Columbus, OH 43206 $627,000 2/2 1,248 0.02
643 S 6th St, Columbus, OH 43206 $506,000 2/2 1,248 0.02
633 S 6th St, Columbus, OH 43206 $551,000 2/2 1,416 0.03
242 E Sycamore St, Columbus, OH 43206 $975,000 3/3 2,353 0.03
246 E Sycamore St, Columbus, OH 43206 $1,758,000 3/3 4,739 0.03
225 Lear St, Columbus, OH 43206 $886,000 3/2 2,036 0.03
234 Lear St, Columbus, OH 43206 $650,000 2/1 1,412 0.03
250 E Sycamore St, Columbus, OH 43206 $945,000 3/3 2,613 0.03

Estimated values are based on public record data and automated valuation models. Values are not guaranteed and may not reflect current market conditions.

Thinking of selling? Get a Cash Offer.

  • A smooth, fast sale
  • Skip staging and repairs
  • No strings attached
5/10
3/10
Source: GreatSchools.org © 2026. All rights reserved.

Around German Village

Explore everything this neighborhood has to offer. Learn more about German Village.
By entering my info and clicking Ask a Question below, I am providing my e-signature and express written consent to receive marketing emails, calls, and texts (including via automatic telephone dialing systems, AI generative, artificial or pre-recorded voice technology) relating to my inquiry from Movoto (and parties calling/messaging on their behalf) even if my number appears on the company, state, or national Do Not Call Registry. You also agree to ourTerms and Conditions and Privacy Policy. Consent not required to receive services (call 1-844-420-1270 to be connected without providing consent).

Nearby recently sold homes in Columbus, OH

Nearby homes for sale in Columbus, OH

Newest listings in 43206

  • Real Estate
  • OH
  • Franklin County
  • Columbus
  • 43206
  • German Village
  • 247 Lear St
Meet with a real estate agent today (844) 430-0869
The multiple listing information is provided by Columbus REALTORS®. IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Buyer to verify all information. The information provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listing information updated every 15 minutes. Terms of use & Privacy Policy, California Privacy Info. Copyright © 2005 - 2026 Movoto, Inc. All rights reserved. Equal Housing Opportunity CalDRE CalDRE #01517281
Movoto Real Estate is committed to ensuring accessibility for individuals with disabilities. We are continuously working to improve the accessibility of our web experience for everyone. We welcome feedback and accommodation requests, please submit them here.
MLS Information deemed reliable but not guaranteed. Information is provided exclusively for consumers' personal, non-commercial use; the information is to not be used in any other manner aside from identifying prospective properties for consumers.

Copyright: 2026 by Columbus REALTORS®.
Requests for information regarding mortgage products will be directed to Movoto.com affiliate, Lower, LLC - a licensed Mortgage Lender (NMLS #1124061), or, based on your location, may be redirected to a participating mortgage marketing partner that may pay Lower, LLC for any consumer contact information provided through this site.