x
Showing 1 of 0
X
Save

247 Lear Street
Columbus OH 43206 US

$824,900

Pending Listing ID 226029899
bed icon
4 bed
rule icon
2,683 square feet
bath icon
4.00 Bath (3 Full , 1 Half)
lot icon
Lot: 0.14 Acres
home icon
Single Family Residence

$824,900

Pending Listing ID 226029899
Save

247 Lear Street 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.14 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air
  • Floor Covering: Ceramic/porcelain, Wood
  • Heating Fuels: Forced Air
  • Additional Features
  • Basement
  • Fireplace
  • Patio

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 824900
  • unparsedaddress: 247 Lear Street
  • postalcity: Columbus
  • stateorprovince: OH
  • country: US
  • postalcode: 43206
  • bathroomsfull: 3
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.14
  • lotsizeunits: Acres
  • lotsizearea: 0.14
  • livingarea: 2683
  • livingareaunits: Square Feet
  • latitude: 39.949606
  • longitude: -82.991419
  • listagentfullname: Brittany E Stockdale
  • listagentemail: britstockdalerealtor@gmail.com
  • listagentkey: 3yd-CCOMLSOH-658033553
  • listagentmlsid: 658033553
  • listagentpreferredphone: 6143020030
  • listagentofficephone: 6143020030
  • listofficekey: 3yd-CCOMLSOH-c1586
  • listofficemlsid: c1586
  • disclaimer: Copyright © 2026 Columbus and Central Ohio Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: CCOMLSOH
  • yearbuilt: 1860
  • listingcontractdate: 2026-08-07
  • listagenturl: http://www.brokerage-house.com
  • countyorparish: Franklin
  • parcelnumber: 010-046649
  • elementaryschooldistrict: COLUMBUS CSD 2503 FRA CO.
  • middleorjuniorschooldistrict: COLUMBUS CSD 2503 FRA CO.
  • highschooldistrict: COLUMBUS CSD 2503 FRA CO.
  • appliances: Dishwasher, Gas Range, Microwave, Refrigerator
  • cooling: Central Air
  • flooring: Ceramic/porcelain, Wood
  • heating: Forced Air
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • waterfrontyn: False
  • franchiseaffiliation: None
  • interiorfeatures: Garden/Soak Tub
  • architecturalstyle: Other
  • rooms: Bathroom 3, Bathroom 1, Bathroom 4, Bedroom 2, Bedroom 3, Bedroom 1, Basement, Bathroom 2, Bedroom 4, Dining Room
  • patioandporchfeatures: Patio
  • basement: Full, Walk-Out Access
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • fencing: Fenced
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -82.99142, 39.949608
  • openhouse: { "AppointmentRequiredYN": false, "ListingKey": "3yd-CCOMLSOH-226029899", "OpenHouseEndTime": "2026-08-09 15:00:00", "OpenHouseId": "7689601", "OpenHouseRemarks": "Hosted by Molly Lancaster", "OpenHouseStartTime": "2026-08-09 13:00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"The Brokerage House", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"britstockdalerealtor@gmail.com", "ListBrokerageCity":"Columbus", "ListBrokerageCountry":"US", "ListBrokerageEmail":"jamie@brokerage-house.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"The Brokerage House", "ListBrokeragePhone":"(614) 500-7870", "ListBrokeragePostalCode":"43221", "ListBrokerageStateOrProvince":"OH", "ListBrokerageUnitNumber":"STE 200", "ListBrokerageUnparsedAddress":"2041 Riverside Drive", "ListBrokerageWebsiteUrl":"http://www.brokerage-house.com", "ListOfficeAddress1":"2041 RIVERSIDE DR ", "ListOfficeAddress2":"STE 200", "ListOfficeBrokerMlsId":"c1586", "ListOfficeCity":"COLUMBUS", "ListOfficeCountry":"US", "ListOfficeEmail":"cindy@brokerage-house.com", "ListOfficePostalCode":"43221", "ListOfficeStateOrProvince":"OH", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - Other - Columbus, OH", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/247-Lear-St_Columbus_OH_43206_M43041-81859?f=listhub&s=CCOMLSOH&m=226029899&c=rexren", "MLSModificationTimestamp":"2026-08-10 21:52:33", "Neighborhoods":[{"Description":null, "Name":"German Village"}], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":10593, "TaxDescription":null, "TaxYear":"2025"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 8/10/2026 9:57:18 PM GMT
Source Updated Date: 8/12/2026 12:56:16 AM GMT

Courtesy of: Brittany E Stockdale, The Brokerage House, britstockdalerealtor@gmail.com

Copyright © 2026 Columbus and Central Ohio Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.