247 Lear St, Columbus, OH 43206
Property image
Property image
SOLD
SEP 3, 2026

$836,000

Trulia Estimate
  • 4 Beds
  • 3.5 Baths
  • 2,683 sqft

247 Lear St, Columbus, OH 43206

German Village
Est. Refi. Payment $5,647/mo*
Refinance Your Home
Currently Off Market - Sold Sep 3, 2026 for $840,000 (2% above list price)

Home Value

Trulia Estimate
$836K
Since last month
Decreased$3K (-0.3%)
Since last year
Decreased$8K (-1%)
Since last sale
Decreased$3K (-0.4%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +44% in the last 10 years
MonthEstimated value
2026
October 2026$837K
September 2026$840K
August 2026$835K
July 2026$891K
June 2026$893K
May 2026$908K
April 2026$881K
March 2026$886K
February 2026$859K
January 2026$871K
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
242 E Sycamore St, Columbus, OH
0.02
Single-Family Home
$995,000
04/03/26
3
3
2,353
714 S 6th St, Columbus, OH
0.10
Single-Family Home
$879,500
02/20/26
4
2.5
2,375
266 E Sycamore St, Columbus, OH
0.04
Single-Family Home
$925,000
11/14/25
3
2.5
2,216
544 S 6th St, Columbus, OH
0.16
Single-Family Home
$1,283,050
05/29/26
3
2.5
2,508
359 Jackson St, Columbus, OH
0.18
Single-Family Home
$842,000
10/02/26
3
2.5
1,973
161 Jackson St, Columbus, OH
0.19
Single-Family Home
$647,000
06/18/26
4
3.5
2,846
291 E Beck St, Columbus, OH
0.07
Single-Family Home
$1,601,000
05/01/26
3
2.5
3,269
255 E Beck St, Columbus, OH
0.05
Single-Family Home
$1,425,000
11/21/25
3
3.5
3,102

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
246 E Sycamore St, Columbus, OH 43206
0.01
$1,837,100
3
4
900
Off Market
651 S 6th St, Columbus, OH 43206
0.01
$559,900
2
2.5
1,486
Off Market
643 S 6th St, Columbus, OH 43206
0.02
$404,600
2
3
1,248
Off Market
643 S 6th St, Columbus, OH 43206
0.02
$414,900
2
3
624
Off Market
250 E Sycamore St, Columbus, OH 43206
0.02
$1,220,100
3
4
2,613
Off Market
242 E Sycamore St, Columbus, OH 43206
0.02
$995,000
3
3
2,353
Recently Sold
671 S 6th St, Columbus, OH 43206
0.03
-
2
2
1,226
Off Market
254 E Sycamore St, Columbus, OH 43206
0.03
$631,600
2
1
1,175
Off Market
633 S 6th St, Columbus, OH 43206
0.03
$446,500
2
2
1,416
Off Market
225 Lear St, Columbus, OH 43206
0.03
$845,200
2
2.5
2,036
Off Market
257 Lear St, Columbus, OH 43206
0.03
$305,800
2
2
1,260
Off Market
257 Lear St #9, Columbus, OH 43206
0.03
-
-
-
-
Off Market
259 Lear St, Columbus, OH 43206
0.03
$293,300
2
2
1,188
Off Market
261 Lear St #17, Columbus, OH 43206
0.03
-
-
-
-
Off Market
255 Lear St, Columbus, OH 43206
0.03
$227,000
1
1
834
Off Market
263 Lear St, Columbus, OH 43206
0.03
$210,700
1
1
834
Off Market
263 Lear St #5, Columbus, OH 43206
0.03
-
-
-
-
Off Market
242 Lear St, Columbus, OH 43206
0.04
-
-
-
-
Off Market
223 Lear St, Columbus, OH 43206
0.04
$745,100
1
3
195
Off Market
220 E Sycamore St, Columbus, OH 43206
0.04
$1,153,000
3
2.5
2,980
Off Market

Local Information

  • Map ViewExplore the area around 247 Lear St.
  • Schools1 Preschool School1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Single-Family Home
Built in 1860
2,683 sqft
$313/sqft

About this House

What's unique:Light-filled family roomTimeless architectural detailsRare front lawnWelcoming foyerSpacious primary suiteSoaring cathedral ceilings
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.
247 Lear St, Columbus, OH 43206 is a 4 bedroom, 4 bathroom, 2,683 sqft single-family home in German Village, built in 1860. It last sold for $840,000 on Sep 3, 2026 (2% above the $824,900 asking price). This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate is $836,000, with a rent estimate of $4,633/month.
Last check for updates: about 6 hours ago
Listed by Brittany E Stockdale, (614) 302-0030
The Brokerage House
Bought with: Aria Alaudini, (614) 561-0696, Mid Ohio Real Estate, LLC.
Source: Columbus and Central Ohio Regional MLS , MLS#226029899

Home Details for 247 Lear St

Interior Features

Interior Details
Basement: Walk-Out Access,Full
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 4Number of Bathrooms (full): 3Number of Bathrooms (half): 1
Dimensions and Layout
Living Area: 2683 Square Feet
Appliances & Utilities
Appliances: Dishwasher, Gas Range, Microwave, RefrigeratorDishwasherMicrowaveRefrigerator
Heating & Cooling
Heating: Forced AirHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Forced Air
Fireplace & Spa
Number of Fireplaces: 1Fireplace: One, DecorativeHas a Fireplace
Windows, Doors, Floors & Walls
Window: Insulated WindowsFlooring: Wood, Ceramic/PorcelainCommon Walls: No Common Walls
Levels, Entrance, & Accessibility
Floors: Wood, Ceramic Porcelain

Exterior Features

Exterior Home Features
Patio / Porch: PatioFencing: FencedFoundation: Block, StoneNo Private Pool
Parking & Garage
No CarportNo Garage
Frontage
Not on Waterfront
Water & Sewer
Sewer: Public Sewer

Property Information

Year Built
Year Built: 1860
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Farmhouse
Building
Not a New Construction
Property Information
Parcel Number: 010046649

Price & Status

Price
List Price: $824,900Price Per Sqft: $313/sqft
Status Change & Dates
Off Market Date: Mon Aug 10 2026

Active Status

MLS Status: Closed

Location

Direction & Address
City: ColumbusCommunity: German Village
School Information
High School District: COLUMBUS CSD 2503 FRA CO.

Building

Building Area
Building Area: 2333 Square Feet

HOA

No HOA

Lot Information

Lot Area: 6098.4 sqft

Offer

Listing Terms: VA Loan, FHA, Conventional

Miscellaneous

BasementMls Number: 226029899

Price and Tax history

DateEventPrice
Sep 3, 2026
Source: Columbus and Central Ohio Regional MLS #226029899
Sold
$840,000
Aug 10, 2026
Source: Columbus and Central Ohio Regional MLS #226029899
Pending
$824,900
Aug 7, 2026
Source: Columbus and Central Ohio Regional MLS #226029899
Listed For Sale
$824,900
Dec 7, 2020
Source: N/A
Sold
$515,000
Aug 5, 2004
Source: N/A
Sold
$469,400

Market trends in Columbus

Last updated September 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$248K
$6KMoM
Sale-to-List Price
100.0%
Price per sq ft
$188
$1MoM
Available listings
2474
75MoM
Sourced by Trulia Market Trends

Around this home

Neighborhood Overview

German Village
See Local Highlights
Neighborhood stats provided by third party data sources.

What Locals Say about German Village

This October

Trick-or-Treat Score

Built from what locals say about German Village.
  • 98% say there are sidewalks
  • 76% say there's holiday spirit
  • 75% say neighbors are friendly
Trulia Trick or TreatStart Ghost Hunt
At least 95 Trulia users voted on each feature.

  • 99 % Say it's dog friendly

  • 99 % Say it's walkable to restaurants

  • 98 % Say there are sidewalks

  • 85 % Say it's walkable to grocery stores

  • 84 % Say parking is easy

  • 77 % Say yards are well-kept

  • 76 % Say there's holiday spirit

  • 75 % Say neighbors are friendly

  • 65 % Say people would walk alone at night

  • 63 % Say car is needed

  • 60 % Say streets are well-lit

  • 58 % Say it's quiet

  • 57 % Say there are community events

  • 53 % Say they plan to stay for at least 5 years

  • 39 % Say kids play outside

  • 36 % Say there's wildlife

Sourced by Trulia users. Learn more about our methodology.
  • Lauren T.
    "Schiller Park is a great local park for families or to walk your dog. There are a ton of great restaurants and bars. "
    1
    Flag
  • Craig.allen.keller
    "Easy and quick commute downtown. Access to major interstates nearby. Close to airport and major stadiums and attractions."
    0
    Flag
  • Katie F.
    "Village Lights at Christmas, Haus and Garten tour, Annual Neighborhood Yard Sale, Art Crawl, Shakespeare in the Park"
    0
    Flag
  • Victoriabasinski
    "Holiday light show, garden parties and house tours! It’s the best area to walk around and go to amazing restaurants! I highly recommend this area "
    0
    Flag
  • Andrew
    "Great. You can get anywhere in Columbus within 35mins. Rush hour is relative. Easy to get around by car at almost all times of the day. "
    0
    Flag
  • Kari l.
    "Dogs are spoiled here! Schiller park is a great place for them to play. Many business place water bowls out, and give treats. Also poo disposal bags are available on most phone poles and other various places. "
    0
    Flag
  • Andreina
    "Perfect European life in Ohio. The most romantic and walkable area. It’s a magical place, a lot of restaurants, bakery and yoga studios "
    4
    Flag
  • Eschirack23
    "I love German village! So many dog friendly people out and about and love being able to walk to so many neat places. Lots of neighborhood gems "
    6
    Flag

LGBTQ Local Legal Protections

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Frequently asked questions about 247 Lear St

  • What is 247 Lear St estimated to be worth?
    Trulia's estimated value for 247 Lear St in Columbus, OH is $836,000.
  • What is the price history for 247 Lear St?
    247 Lear St in Columbus, OH last sold for $840,000 in September 2026.
  • Is Columbus a buyer's or seller's market?
    Columbus is currently a buyer's market, based on recent for-sale activity.
  • What's the median sale price in Columbus?
    The median sale price in Columbus is $248K. That is down $6K from the prior month.
  • Does 247 Lear St have air conditioning?
    Yes, 247 Lear St in Columbus, OH has air conditioning.
  • Does 247 Lear St have a yard?
    Yes, 247 Lear St in Columbus, OH has a yard.

Explore by feature - Pet Friendly

1896 pet-friendly rentals in Columbus, OH

Explore by feature - Garage

645 rentals with a garage in Columbus, OH

Explore by feature - Air Conditioning

1850 rentals with air conditioning in Columbus, OH

Explore by feature - Pool

315 homes with a pool in Columbus, OH

Explore by feature - Washer/dryer

1996 rentals with a washer/dryer in Columbus, OH

Explore by feature - Outdoor Space

372 rentals with an outdoor space in Columbus, OH

Apartments for Rent

Skip to last item
Skip to first item

Off Market Homes Near 247 Lear St

Skip to last item
Skip to first item

Homes for sale near 247 Lear St

Skip to last item
Skip to first item
Skip to last item
  • Results are loading
Skip to first item