247 Lear St
Columbus, OH 43206
German Village
4 Beds
3.5 Baths
2,683 sqft
4 Beds
3.5 Baths
2,683 sqft
Home Highlights
Outdoor
Patio
Climate Control
Heating & Cooling
Price/Sqft
$307
Listed
8 days ago
Local Information
- Map ViewExplore the area around 247 Lear St.
- Schools1 Preschool School1 Elementary School1 Middle School1 High School
- Shop & Eat
-- mins to
About this House
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.
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.
Home Details for 247 Lear St
|
|---|
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 Home Features Patio / Porch: PatioFencing: FencedFoundation: Block, StoneNo Private Pool |
Parking & Garage No CarportNo Garage |
Frontage Not on Waterfront |
Water & Sewer Sewer: Public Sewer |
|
|---|
Days on Market: 8 |
|
|---|
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 List Price: $824,900Price Per Sqft: $307 |
Status Change & Dates Off Market Date: Mon Aug 10 2026 |
|
|---|
MLS Status: Pending |
|
|---|
Direction & Address City: ColumbusCommunity: German Village |
School Information High School District: COLUMBUS CSD 2503 FRA CO. |
|
|---|
Listing Agent Listing ID: 226029899 |
|
|---|
Building Area Building Area: 2333 Square Feet |
|
|---|
No HOA |
|
|---|
Lot Area: 6098.4 sqft |
|
|---|
Listing Terms: VA Loan, FHA, Conventional |
|
|---|
BasementMls Number: 226029899 |
Last check for updates: about 5 hours ago
Listing courtesy of Brittany E Stockdale, (614) 302-0030
The Brokerage House
Source: Columbus and Central Ohio Regional MLS , MLS#226029899
Also Listed on Columbus and Central Ohio Regional MLS .
Market trends in Columbus
Last updated July 2026
Avg. sale price
$253K
$5.08KMoM
Sale-to-List Price
100.0%
0.2%MoM
Price per sq ft
$190
$3MoM
Available listings
2517
128MoM
Price and Tax history
| Date | Event | Price |
|---|---|---|
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 |
| Year | Property tax | Tax assessment |
|---|---|---|
| 2024 | $10,561 | $672,300 |
Home facts updated by county records
Similar Homes You May Like
OPEN SAT, 11-1PMRegan M Lowe, The Brokerage House
0.27 ACRESMichael P Porchetti, RE/MAX Impact
Veronica Ann Merkle, Berkshire Hathaway HS Calhoon
0.34 ACRESMerilee R Luka, Keller Williams Greater Cols
Jennifer L Bertagna, Coldwell Banker Realty
0.36 ACRESSteven W Cotter, Coldwell Banker Realty
Seth J Janitzki, Cam Taylor Co. Ltd., Realtors
OPEN SUN, 2-4PMRuth H Porteus, Keller Williams Capital Ptnrs
OPEN SAT, 12-2PMSam Cooper, Howard Hanna Real Estate Svcs
Christina R Miller, Coldwell Banker Realty
0.63 ACRESMichael Downey, Brokers & Associates, LLC
OPEN SUN, 1-3PMRoger E Willcut, Keller Williams Consultants
Kyle D Widder, Coldwell Banker Realty
0.93 ACRESDeLena Ciamacco, RE/MAX Connection
Deborah J McKnight Saczawa, Cutler Real Estate
OPEN SAT, 1-3PM0.51 ACRESCarole Greenzalis, Keller Williams Capital Ptnrs
0.49 ACRESRichard J Sanford, RE/MAX Achievers
0.29 ACRESScott Ringer, Keller Williams Consultants
0.26 ACRESPaula Koontz Gilmour, KW Classic Properties Realty
0.36 ACRESJacob S Mercer, Berkshire Hathaway HS Pro Rlty
OPEN SUN, 2-4PMTroy A Marsh, Keller Williams Consultants
0.35 ACRESMichael L Jones, Coldwell Banker Realty
Andrea R Kaper, Keller Williams Consultants
Sandra Binning, Coldwell Banker Realty
OPEN SAT, 2-4PMAshley Gale, Keller Williams Consultants
0.27 ACRESSusie L Pattison, Cutler Real Estate
0.42 ACRESMisha Jobin, Coldwell Banker Realty
0.28 ACRESEric W Gledhill, Cutler Real Estate
OPEN SAT, 2-4PMKatie R Shepard, RE/MAX Partners
OPEN SUN, 1-4PM1.14 ACRESJeff Gongwer, RE/MAX Affiliates, Inc.
Cristina M Romanelli, Keller Williams Greater Cols
0.3 ACRESWilliam C Wickom, USA-1 Real Estate Corp.
See more homes for sale inColumbus
New Listings near 247 Lear St
NEWOPEN SUN, 1-3PMWilliam J Ruffner, Red 1 Realty
COMING SOONAnthony J Bennett, Red 1 Realty
Matthew T Schirtzinger, RE/MAX Premier Choice
0.37 ACRESJason Heidenescher, H Real Estate
OPEN SUN, 12-2PMCathy Fleischmann, Cutler Real Estate
OPEN SAT, 1-3PMJames D Meyer, Cutler Real Estate- OPEN SAT, 12-2PMSam Cooper, Howard Hanna Real Estate Svcs
NEW - 1 DAY AGOAaron J McDaniel, Mainstream Realty Pros
OPEN SUN, 11-1PMJohn D Lubinsky, RE/MAX Affiliates, Inc.- See more homes for sale inColumbus
Home Value
Trulia Estimate
$831KSince last month
Decreased$60K (-6.8%)Since last year
Decreased$29K (-3.4%)Since last sale
Increased$318K (+61.7%)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 +37% in the last 10 years
| Month | Estimated value |
|---|---|
2026 | |
| August 2026 | $833K |
| 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 |
|---|---|---|---|---|---|---|---|
0.02 | Single-Family Home | $995,000 | 04/03/26 | 3 | 3 | 2,353 | |
0.19 | Single-Family Home | $647,000 | 06/18/26 | 4 | 3.5 | 2,846 | |
0.10 | Single-Family Home | $879,500 | 02/20/26 | 4 | 2.5 | 2,375 | |
0.04 | Single-Family Home | $925,000 | 11/14/25 | 3 | 2.5 | 2,216 | |
0.28 | Single-Family Home | $725,000 | 12/15/25 | 3 | 2.5 | 2,240 | |
0.08 | Single-Family Home | $735,000 | 08/06/26 | 3 | 3.5 | 1,603 | |
0.16 | Single-Family Home | $1,283,050 | 05/29/26 | 3 | 2.5 | 2,508 | |
0.07 | Single-Family Home | $1,601,000 | 05/01/26 | 3 | 2.5 | 3,269 | |
0.10 | Single-Family Home | $645,000 | 06/15/26 | 2 | 3 | 1,664 | |
0.28 | Single-Family Home | $679,000 | 08/18/25 | 4 | 2.5 | 3,216 |
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 |
|---|---|---|---|---|---|---|
0.04 | $649,900 | Studio | - | - | For Sale | |
0.06 | $2,426,000 | 3 | 2.5 | 3,369 | Off Market | |
0.01 | $565,600 | 2 | 2.5 | 1,486 | Off Market | |
0.06 | $775,000 | Studio | - | - | For Sale | |
0.04 | $283,400 | 2 | 1.5 | 1,260 | Off Market | |
0.05 | $1,425,000 | 3 | 3.5 | 3,102 | Recently Sold | |
0.04 | $189,500 | 1 | 1 | 870 | Recently Sold | |
0.07 | $1,601,000 | 3 | 2.5 | 3,269 | Recently Sold | |
0.04 | $299,500 | 1 | 1 | 834 | For Sale | |
0.04 | $232,200 | 1 | 1 | 834 | Off Market | |
0.05 | $259,200 | 1 | 1 | 834 | Off Market | |
0.05 | $262,800 | 2 | 1.5 | 1,188 | Off Market |
Around this home
Neighborhood Overview
Neighborhood stats provided by third party data sources.
What Locals Say about German Village
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.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Frequently asked questions about 247 Lear St
- What is the estimated monthly payment for 247 Lear St?Based on a $824,900 list price with 20% down at today's rates, the estimated monthly payment for 247 Lear St in Columbus, OH is approximately $5,355 (about $4,311 principal & interest, $969 property taxes, and $75 homeowner's insurance). This is an estimate. Actual payment depends on your loan terms.
- How does the list price for 247 Lear St compare to homes in Columbus?247 Lear St in Columbus, OH is listed at $824,900, about 226% above the $253K median sale price in Columbus.
- What do residents say about the German Village neighborhood?Residents describe the German Village neighborhood in Columbus, OH as dog-friendly, walkable to restaurants, and pedestrian-friendly. See homes for sale in German Village, Columbus.
- What are the closest schools to 247 Lear St?The closest schools to 247 Lear St in Columbus, OH are Siebert Elementary School (Pre-K, rated 4/10), South High School (Middle, rated 3/10).
- 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.
Brittany E Stockdale, The Brokerage House
Agent Phone: (614) 302-0030
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.
247 Lear St, Columbus, OH 43206 is a 4 bedroom, 4 bathroom, 2,683 sqft single-family home built in 1860. 247 Lear St is located in German Village, Columbus. This property is currently available for sale and was listed by Columbus and Central Ohio Regional MLS on Aug 7, 2026. The MLS # for this home is MLS# 226029899.