$1,700,000
$100K PRICE DROP

Estimated payment $10,922/month

Total Views 63,148
4 Beds
4.5 Baths
7,013 Sq Ft
$242 Price per Sq Ft

Highlights

  • Hot Property
  • Sitting Area In Primary Bedroom
  • Family Room with Fireplace
  • Home Theater
  • 8.81 Acre Lot
  • Transitional Architecture

About This Home

Formally a builder's personal Country Estate located on 8.8092 acres, with a 1-acre pond, and 500 feet of road frontage. This home boasts 4,493 sq ft with an additional 2,420 sq ft finished in the Lower Level, plus 4 FPs. The expansive foyer opens to the dining room, Massive study, two-story great room, 1st-floor owners' suite & sitting room. The curved staircase leads you up to the guestrooms with full baths. The kitchen and counter bar open to the breakfast room, hearth room, and 4-season room. The lower level offers a guest bedroom, full bath, kitchenette, dining area, family room with FP, media room, game room, and a walk-up to the attached 4-plus-car garage with 1,486 sq ft. The matching detached 10-car brick garage could become a 2000 sq. ft. guest house. Theirs also two 550-gallon gasoline fuel tanks for your convenience. An additional 8.6958 acres are available, with 700 ft of road frontage, subject to final survey.

Listing Agent

Bruce Koehler

Comey & Shepherd License #0000371130 Listed on: 05/29/2025

Comey & Shepherd

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $18,074

Year Built

  • Built in 1997

Lot Details

  • 8.81 Acre Lot

Parking

  • 12 Car Garage
  • Garage Door Opener
  • Driveway
  • Off-Street Parking

Home Design

  • Transitional Architecture
  • Brick Exterior Construction
  • Shingle Roof

Interior Spaces

  • 7,013 Sq Ft Home
  • 2-Story Property
  • Woodwork
  • Crown Molding
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Gas Fireplace
  • Double Pane Windows
  • Insulated Windows
  • Double Hung Windows
  • Panel Doors
  • Family Room with Fireplace
  • 4 Fireplaces
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Home Theater
  • Fire and Smoke Detector

Kitchen

  • Breakfast Bar
  • <<doubleOvenToken>>
  • Dishwasher
  • Kitchen Island
  • Solid Surface Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Sitting Area In Primary Bedroom
  • Main Floor Bedroom
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sump Pump

Outdoor Features

  • Patio
  • Separate Outdoor Workshop

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • 220 Volts
  • Septic Tank
  • Cable TV Available

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$18,074

Year Built

Built in 1997

Lot Details

0

Parking

12

Listing Details

  • Suburb: Turtle Creek Twp.
  • Cross Street: Columbine
  • Buildings: Workshop
  • Land Description: 5 to 9.9 Acres
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt, Cable, Ceiling Fan, Recessed Lights, Smoke Alarm, Tech Wiring
  • Basement Sq Ft: 2420
  • Census Tract Realist: 323.00
  • Cooling: Ceiling Fans, Central Air
  • Heating: Forced Air, Gas
  • Sub Lease Expiration Date: 1800-01-01T00:00:00.000-05:00
  • Suburb S I C: Turtle Creek Twp.
  • Taxes Annual: 18074
  • Price Per Acre: 192980.07
  • Zoning: Residential
  • Basement Features: Finished, Fireplace, Walkout, Laminate Floor
  • Bathroom 4: Full
  • Bathroom 4 Level: Lower
  • Level 1 Bathroom Type: Full, Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Breakfast Room Area: 196
  • Dining Room Feat: Chair Rail, Chandelier, Window Treatment, Wood Floor, Formal
  • Entry Area: 240
  • Entry Foyer: Closet, Open Foyer, Transom/Sidelit, Wood Floor
  • Family Room Feat: Walkout, Fireplace, Wood Floor
  • Great Room Feat: Walkout, Window Treatment, Fireplace, Wood Floor
  • Living Great Rm Area: 1026
  • Living Great Rm Dim: 38 x 27
  • Living Great Rm Len: 38
  • Living Great Rm Wid: 27
  • Living Room Feat: Walkout, Wet Bar, Fireplace, Other
  • Mechanical Systems: Central Vacuum, Garage Door Opener, Sump Pump
  • Single Family Desc: Single Family
  • Study Lib Den: 23x15 Level: 1
  • Study Lib Den Area: 345
  • Study Lib Den Dim: 23 x 15
  • Study Lib Den Len: 23
  • Water Heating: Propane
  • Year Built: 1997
  • Architecture: Transitional
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Bedrooms: 4
  • Directions: I-75 to East on Rt 63 to left on Markey to left on North St. Rt. 123. From 1-71 to North on Rt 48 or North Rt 123.
  • Lot Measurement: Acres
  • Status: Active
  • Property Subtype 1: Single Family Residence
  • Street Direction: N
  • Occupancy: At Closing
  • ADU Y/N: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Cathedral Ceiling, Crown Molding, French Doors, Multi Panel Doors, Natural Woodwork
  • Bedroom 2: 19x14 Level: 2
  • Bedroom 3: 16x13 Level: 2
  • Bedroom 4: 15x14 Level: Lower
  • Breakfast Room: 14x14 Level: 1
  • Dining Room: 13x13 Level: 1
  • Living Room: 38x27 Level: Lower
  • Recreation Room: 35x27 Level: Lower
  • Flex Rooms: 3 Season Room, Media Room, Bonus Room, Sitting Area, Exercise Room, GuestSuite w/ Ktchn
  • Property Type: Residential
  • Other Tax Parcel I D: The current 19.86 acre parcel is being subdivided with the home on 8.8092 acres. Two additional parcel will be created with an available 8.6958 acres and a 2.3609 acre parcel. Preliminary survey is completed.
  • Reciprocal Listing: No
  • Semi Annual Taxes: $9037
  • Appliances: Dishwasher, Double Oven, Garbage Disposal, Oven/Range, Refrigerator
  • Kitchen Features: Pantry, Counter Bar, Solid Surface Ctr, Tile Floor, Island, Wood Cabinets
  • Bedroom 2 Area: 266
  • Basement: Full
  • Bedroom 3 Area: 208
  • Study Features: Bookcases, Wall-to-Wall Carpet
  • Bedroom 4 Area: 210
  • Entry: 16x15 Level: 1
  • Bathrooms: 5.00
  • Great Room: 22x17 Level: 1
  • Kitchen Area: 256
  • Kitchen Dim: 16 x 16
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 1
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Diningroom Area: 169
  • Family Room Area: 285
  • Laundry Room: 8x9 Level: 1
  • Laundry Room Area: 72
  • Laundryroom Dim: 8 x 9
  • Recreation Room Area: 945
  • Recreation Room Dim: 35 x 27
  • Fireplace: Ceramic, Gas
  • Fireplaces: 4
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 7013.00
  • Total Rooms: 17
  • Windows: Double Hung, Double Pane, Wood, Insulated
  • First Floor Family Room: 19x15 Level: 1
  • PrimaryBedroomArea: 484
  • PrimaryBedroomDim: 22 x 22
  • PrimaryBedroomLen: 22
  • Primary Bathrooms: Shower, Tile Floor, Double Vanity, Tub
  • PrimaryBedFeat: Bath Adjoins, Walk-in Closet, Wall-to-Wall Carpet, Fireplace, Sitting Room
  • P R I M A R Y B E D R O O M: 22x22 Level: 1

Exterior Features

  • View: Lake/Pond
  • Roof: Shingle
  • Construction: Brick
  • Outside Features: Patio
  • Foundation: Poured
  • Listing Price: 1700000.00
  • Acres: 8.8092
  • New Construction: No

Garage/Parking

  • Garage Spaces: 12.00
  • Garage Carport: Oversized, Side, Garage Attached, Garage Detached
  • Parking: Off Street, Driveway

Utilities

  • Gas: Propane
  • Sewer: Septic Tank
  • Water Source: At Street

Condo/Co-op/Association

  • HOA Yes/No: No
  • Association: Cincinnati Area Multiple Listing Service

Schools

  • District: Lebanon City SD

Lot Info

  • Lot Dimensions: 500.42 frontage subject to survey
  • Lot Size Sq Ft: 383729.00
  • Total Assessed Value: 15.16

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/10/2025 07/10/25 For Sale $1,500,000 -11.8% $214 / Sq Ft
06/26/2025 06/26/25 Price Changed $1,700,000 -2.9% $242 / Sq Ft
06/17/2025 06/17/25 Price Changed $1,750,000 -2.8% $250 / Sq Ft
05/29/2025 05/29/25 For Sale $1,800,000 -- $257 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

About the Listing Agent

Bruce Koehler

Comey & Shepherd

(866) 980-1677

Section Image

Clients who select me as their Realtor® know they have chosen a professional who truly cares about their needs, while being knowledgeable about the Greater Cincinnati market. I am committed to professionalism and to providing top-quality service.

Whether you're buying your first home, looking to upgrade, or downsize, contact me to help you with your next Real Estate sale or purchase!

Bruce's Other Listings

  • 2266 Ohio 123, Lebanon, OH 45036

    $1,500,000

    • 4 Beds
    • 4.5 Baths
    • 7,013 Sq Ft
    • 2266 Ohio 123
    • Lebanon, OH

    This incredible 4,593 sq ft Home, sitting on 8.80 acres, and your private 1+acre lake is just out the back door. An additional 5 acres is still available. Once you enter the expansive foyer, you'll notice the curved staircase to the 2ed floor bedroom. Spacious Dining room, Hugh, and well-appointed 1st floor study. The owner's suite offers you a two-sided fireplace, enjoyed from both the sitting

    Bruce Koehler Comey & Shepherd REALTORS

    Section Image
  • 2266 Ohio 123 Unit Site A, Lebanon, OH 45036

    $325,000

    • Land
    • 3.6 Acres
    • $90,278 per Acre
    • 2266 Ohio 123
    • Unit Site A
    • Lebanon, OH

    Beautiful 3.6-acre parcel. Located only 10 minutes from I-75 and 15 minutes from I-71. The acreage is subject to final survey. Additional acreage is available.

    Bruce Koehler Comey & Shepherd REALTORS

    Section Image
  • 2266 Ohio 123 Unit Site B, Lebanon, OH 45036

    $220,000

    • Land
    • 2.5 Acres
    • $88,000 per Acre
    • 2266 Ohio 123
    • Unit Site B
    • Lebanon, OH

    Beautiful 2.6-acre parcel. Located only 10 minutes from I-75 and 15 minutes from I-71. The acreage is subject to final survey. Additional acreage is available.

    Bruce Koehler Comey & Shepherd REALTORS

    Section Image
  • 2266 Ohio 123 Unit Site C, Lebanon, OH 45036

    $200,000 Pending

    • Land
    • 2.4 Acres
    • $83,333 per Acre
    • 2266 Ohio 123
    • Unit Site C
    • Lebanon, OH

    Beautiful 2.4-acre lake view parcel. Located only 10 minutes from I-75 and 15 minutes from I-71. The acreage is subject to final survey. Additional acreage is available.

    Bruce Koehler Comey & Shepherd REALTORS

    Section Image
  • 2266 N St Rt 123, Turtle Creek Township, OH 45036

    $1,500,000

    • 4 Beds
    • 4.5 Baths
    • 7,013 Sq Ft
    • 2266 N St Rt 123
    • Turtle Creek Township, OH

    This incredible 4,593 sq ft Home, sitting on 8.80 acres, and your private 1+acre lake is just out the back door. An additional 5 acres is still available. Once you enter the expansive foyer, you'll notice the curved staircase to the 2ed floor bedroom. Spacious Dining room, Hugh, and well-appointed 1st floor study. The owner's suite offers you a two-sided fireplace, enjoyed from both the sitting

    Bruce Koehler Comey & Shepherd

    Section Image
  • 2266 N Nn St Rt 123, Lebanon, OH 45036

    $200,000 Pending

    • Land
    • 2.5 Acres
    • $80,000 per Acre
    • 2266 N Nn St Rt 123
    • Lebanon, OH

    Beautiful 2.5 acre parcel with lake view. The property includes 2 barns, and a perfect location for your new home, or mini farm. Located only 10 minutes from I-75 and 15 minute from I-71. The acreage is subject to final survey. An additional 10 acres with 700 ft of Road frontage is available for $550,000.

    Bruce Koehler Comey & Shepherd REALTORS

    Section Image
  • N Ohio 123, Lebanon, OH 45036

    $550,000

    • Land
    • 9 Acres
    • $63,291 per Acre
    • N Ohio 123
    • Lebanon, OH

    8.6958 beautiful acres in this park setting for your Estate home, farm or development with 700 ft of road frontage. Electric and Water located at street. A creek is located at the rear property, with lake view and several building sites. ODOT approved curb-cut, and final approval is subject to Turtle creek Twp. and within Twp guidelines. Final acreage is subject to survey. The property is located

    Bruce Koehler Comey & Shepherd

    Section Image
  • Lot Ohio 123, Lebanon, OH 45036

    $200,000 Pending

    • Land
    • 2.36 Acres
    • $84,746 per Acre
    • Lot Ohio 123
    • Lebanon, OH

    Beautiful 2.3609 acre parcel with lake view. The property includes 2 barns, and a perfect location for your new home, or mini farm. Located only 10 minutes from I-75 and 15 minute from I-71. The acreage is subject to final survey. An additional 8.6958 acres with 700 ft of Road frontage is available for $550,000., MLS # 1842639

    Bruce Koehler Comey & Shepherd

    Section Image
  • 2110 Fulton Ave, Cincinnati, OH 45206

    $165,000

    • 2 Beds
    • 1 Bath
    • 814 Sq Ft
    • 2110 Fulton Ave
    • Cincinnati, OH

    Well maintained, and a spacious 814 sq ft, 2 bedroom Condo. Conveniently located near Eden Park, Downtown, and I-71 & 1-75. This unit offer hardwood floors, updated carpet and plenty of natural light. The bright and sunny kitchen and counter bar is open to the great room and breakfast area. The owners suite offer 3 closet and next to the full bath. The guest room is spacious and brite. Come with

    Bruce Koehler Comey & Shepherd

    Section Image

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1841256

MLS of Greater Cincinnati (CincyMLS)