Skip main navigation
Off market
  • $859,000

    5155 State Route 123, Franklin, OH 45005

    5beds
    5,441sqft
    SingleFamily
    Built in 2006
    5 Acres Lot
    $859,000 Zestimate®
    $158/sqft
    $4,089 Estimated rent

    Home value

    $859,000

    $799,000 - $928,000

    $4,089/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,089/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,089/mo

    Rent Zestimate®

    Refinance and save

    $4,433/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $4,433/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Pool tableRemodeled kitchenHeated floorsGutter guardsSecond tv areaNewer stainless steel appliancesHuge kitchen remodel

    Welcome home to this astonishing, custom brick 2 story home on a beautiful 5 acre lot in Franklin township. You will be welcomed to the property by a brick and wrought iron entrance then wind up along the all-paver driveway. This home boasts a remarkable 5 car (6 door) garage complete with 2 air compressors, soft water hot / cold spigot and a full bathroom. Guests may choose to follow the all-paver walkway to the informal guest side entrance or continue to the spectacular 2 story front entrance. As you enter from the garage you will be greeted by a spacious, remodeled kitchen, complete with newer stainless steel appliances and quartz countertops, that opens up to the family room and stone hearth fireplace. The spacious main floor master suite offers a custom cherry organized closet system and beautiful bath. Down the hall is a second full bath and bedroom. The second floor houses 2 more bedrooms, with one having 4 dormers added with windows for a more usable space. The full finished walkout basement is a show stopper!!! The main attraction is the theatre room. Host your own movie nights. Guests can also enjoy a 5th bedroom, a bathroom with heated floors and a steam shower, which has a control board that plays music and has a variety of amazing features! The basement also features a kitchen and lots of space for a pool table a second TV area or a ping pong table too! Updates include carpet main & second floor, kitchen and dining room floor and basement lvp (2020), tankless water heater, gutter guards (2020), huge kitchen remodel (2020), dormers/windows in bedroom (2020)

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 4
    Features
    • Basement: Full, Finished, Walkout
    Interior area
    • Total interior livable area: 5,441 sqft

    Property

    Parking
    • Total spaces: 4
    Features
    • Levels: 2 Story
    Lot
    • Size: 5.00 Acres
    Details
    • Parcel number: 08233510020
    • Zoning: Residential

    Construction

    Type & style
    • Home type: SingleFamily
    Condition
    • Year built: 2006

    Utilities & green energy

    • Utilities for property: City Water

    Community & neighborhood

    Location
    • Region: Franklin

    Other

    Other facts
    • Levels: 2 Story
    • Property Type: Residential
    • Utilities: City Water
    • Zoning: Residential
    • Basement: Full, Finished, Walkout
    • Cooling: Central
    • Appliances: Dishwasher, Range, Refrigerator, Microwave, Water Softener
    • Outside Features: Patio
    • Construction Type: Brick
    • Inside Features: High Speed Internet, Electric Water Heater, Security / Surveillance, Tankless Water Heater
    • Lot Size Source: Assessor's Data
    • Fireplace: Gas
    • Heating: Heat Pump, Electric
    • Last Change Type: Pending
    • Garage: Attached, Opener, 4 or More, 220 Volt Outlet
    • Kitchen Features: Remodeled, Pantry, Quartz
    • Legal Description: 4-3-23 5.0010 AC.
    • Parcel Number: 08233510020

    Price history

    DateEventPrice
    11/29/2022Sold$700,000+0%$129/sqft
    Source: DABR MLS #875606 Report a problem
    10/28/2022Pending sale$699,900$129/sqft
    Source: DABR MLS #875606 Report a problem
    10/22/2022Listed for sale$699,900+20.3%$129/sqft
    Source: DABR MLS #875606 Report a problem
    3/12/2020Sold$582,000$107/sqft
    Source: Cincy MLS #1640148 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: 45005

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Franklin

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $859,000
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $859,000