$315,000
$10K PRICE DROP

5900 Cresting Rd Franklin, OH 45042

Madison Area

Estimated payment $2,148/month

Total Views 23,054
3 Beds
2.5 Baths
-- Sq Ft
-- Price per Sq Ft

Highlights

  • Traditional Architecture
  • Eat-In Kitchen
  • Forced Air Heating and Cooling System
  • 2 Car Attached Garage
  • Walk-In Closet

About This Home

Welcome to this beautifully maintained, just two years old, 3-bedroom, 2.5-bath home offering the perfect blend of modern style, comfort, and functionality. The open-concept floor plan features a bright living area that flows into the kitchen with stainless steel appliances, ample cabinetry, and generous counter space. Upstairs, the spacious primary suite offers a walk-in closet and private bath, along with two additional bedrooms, a full bath, and convenient second-floor laundry. The full unfinished basement offers endless potential for future living space or extra storage. Enjoy the spacious backyard and a prime location just minutes from I-75, Austin Landing, Liberty Center, shopping, dining, parks, and schools. Schedule your private showing today!

Listing Agent

Arthur Greenlee IV

eXp Realty License #2021000929 Listed on: 07/16/2026

eXp Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,602

Year Built

  • Built in 2024

Lot Details

  • 9,936 Sq Ft Lot

HOA Fees

  • $35 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Front Facing Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding
  • Stone

Interior Spaces

  • 2-Story Property
  • Vinyl Clad Windows
  • Unfinished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • Bathtub and Shower Combination in Primary Bathroom

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Gas Water Heater

Community Details

  • Association fees include association dues, landscapingcommunity, play area

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,602

Year Built

Built in 2024

Lot Details

9,936 Sq Ft Lot

HOA Fees

$35 per month

Parking

2

Listing Details

  • Suburb: Middletown North
  • Land Description: Less than .5 Acre
  • Broker Approved: Yes
  • Census Tract Realist: 505.04
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 9936.00
  • Suburb S I C: Middletown North
  • Zoning: Residential
  • Basement Features: Unfinished
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Living Great Rm Dim: 18 x 12
  • Living Room Feat: Walkout
  • Single Family Desc: Single Family
  • Study Lib Den Dim: 0 x 0
  • Water Heating: Gas
  • Year Built: 2024
  • H O A Paid By: Owner
  • Architecture: Traditional
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Bedrooms: 3
  • Directions: Cin Day rd to Sawyers Mill SB, Riverview Rd to Cresting
  • Lot Measurement: Acres
  • Status: Active
  • On Market Date: 2026-07-16
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • ADU Y/N: No
  • Special Features: 4098
  • Property Sub Type: Detached

Interior Features

  • Bedroom 2: 11x10 Level: 2
  • Bedroom 3: 11x10 Level: 2
  • Living Room: 18x12 Level: 1
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $2301
  • Appliances: Dishwasher, Garbage Disposal, Microwave, Oven/Range, Refrigerator
  • Kitchen Features: Eat-In
  • Basement: Full
  • Bathrooms: 3.00
  • Kitchen Dim: 14 x 14
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Partial
  • Bathroom 3 Level: 1
  • Laundry Room: 7x7 Level: 2
  • Laundryroom Dim: 7 x 7
  • Recreation Room Dim: 0 x 0
  • Available for Lease: No
  • Windows: Vinyl
  • PrimaryBedroomDim: 14 x 13
  • Primary Bathrooms: Tub w/Shower
  • PrimaryBedFeat: Bath Adjoins, Walk-in Closet
  • P R I M A R Y B E D R O O M: 14x13 Level: 2

Exterior Features

  • Roof: Shingle
  • Construction: Stone, Vinyl Siding
  • Foundation: Poured
  • Listing Price: 315000.00
  • Acres: 0.2281
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Front, Garage Attached
  • Parking: Driveway

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 425.00
  • Fee Frequency: Annually
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service

Fee Information

  • Inc.In HOA/Condo Fee: Association Dues, LandscapingCommunity, Play Area

Schools

  • District: Franklin City SD

Lot Info

  • Lot Size Sq Ft: 9936.00
  • Total Assessed Value: of rec

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

3D Interior and Exterior Tours

Floorplans

Map

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

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $1,093 $121,400 $21,800 $99,600
2024 $1,077 $107,700 $21,800 $85,900
2023 $1,065 $109,300 $21,800 $87,500
2022 $1,038 $103,800 $20,800 $83,000
2021 $979 $97,900 $20,800 $77,100
2020 $932 $95,800 $20,800 $75,000
2019 $867 $91,700 $20,800 $70,900
2018 $765 $88,200 $20,800 $67,400
2017 $724 $86,300 $20,800 $65,500
2016 $557 $82,900 $20,800 $62,100
2014 $485 $81,700 $19,400 $62,300
2013 $485 $85,000 $19,400 $65,600
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
08/18/2026 08/18/26 Price Changed $315,000 -3.0% --
07/16/2026 07/16/26 For Sale $324,900 -- --
Source: MLS of Greater Cincinnati (CincyMLS)

About the Listing Agent

Arthur Greenlee IV

eXp Realty

(513) 449-6019

Section Image

Arthur Greenlee IV is a licensed Realtor and Investor serving Ohio and Kentucky, specializing in helping buyers, sellers, and investors build wealth through real estate. As a top-producing agent, Arthur is known for his strong negotiation skills, market knowledge, and commitment to delivering results.

With a background in athletics and a mindset built on discipline and faith, Arthur approaches every transaction with focus, integrity, and hustle. He takes pride in guiding clients through

Arthur's Other Listings

  • 6004 Tyler Point Dr, Hamilton, OH 45011

    $524,900 Pending

    • 4 Beds
    • 3.5 Baths
    • 4,125 Sq Ft
    • 6004 Tyler Point Dr
    • Hamilton, OH

    Step into comfort and space with this beautiful 4-bedroom home offering over 4,000 SQFT of living space and located on a cul-de-sac street in Fairfield Township! Featuring a 3-car garage, open floor plan, formal living and dining areas, and a family room with fireplace, this home offers plenty of room to enjoy. The spacious kitchen features stainless steel appliances, double wall ovens, abundant

    Arthur Greenlee IV eXp Realty

    Section Image
  • 761 Brooklyn Ave, Dayton, OH 45402

    $119,900 $5K PRICE DROP

    • 3 Beds
    • 1 Bath
    • 1,044 Sq Ft
    • 761 Brooklyn Ave
    • Dayton, OH

    Check this out, newly updated 3-bedroom, 1-bath single-floor living home! Featuring an updated kitchen and bathroom, new paint, new windows, and new flooring and carpet throughout, along with a new furnace and hot water heater, plus a nice front and backyard, this home has everything you need to make it your next home. Come check it out!

    Arthur Greenlee IV eXp Realty

    Section Image
  • 3070 Wardall Ave, Cincinnati, OH 45211

    $184,900 Pending

    • 5 Beds
    • 1 Bath
    • 1,500 Sq Ft
    • 3070 Wardall Ave
    • Cincinnati, OH

    his spacious 5-bedroom, 1-bath brick home offers three levels of living space, timeless character, and plenty of room to grow. Inside, you'll find original hardwood floors, rich natural woodwork, decorative columns, generous living and dining areas, and a functional kitchen with stainless-steel appliances and a tile backsplash. Major updates include new windows in 2026, a new roof in 2021, and a

    Arthur Greenlee IV eXp Realty

    Section Image
  • 5067 E Miami River Rd, Cleves, OH 45002

    $144,900

    • 3 Beds
    • 1 Bath
    • 1,428 Sq Ft
    • 5067 E Miami River Rd
    • Cleves, OH

    Explore this charming 3-bedroom, 1-bath home along the Great Miami River! Featuring hardwood floors, a full basement, and a versatile bonus room on the second level, this home offers plenty of space and possibilities. Schedule your showing today!

    Arthur Greenlee IV eXp Realty

    Section Image
  • 1510 Merrimac St, Cincinnati, OH 45207

    $249,900 $50K PRICE INCREASE

    • 4 Beds
    • 2 Baths
    • 1,756 Sq Ft
    • 1510 Merrimac St
    • Cincinnati, OH

    Seller is offering $3,000 toward the buyer's closing costs! Welcome home to this beautifully renovated 4-bedroom, 2 full-bath property in the heart of Evanston! This move-in-ready home features a brand-new kitchen complete with stainless steel appliances, a center island, and plenty of cabinet and counter space. The first-floor primary suite offers added convenience with a private en-suite

    Arthur Greenlee IV eXp Realty

    Section Image
  • 7314 Dog Trot Rd, Cincinnati, OH 45248

    $224,900 $25K PRICE DROP

    • 2 Beds
    • 1 Bath
    • 884 Sq Ft
    • 7314 Dog Trot Rd
    • Cincinnati, OH

    Discover comfort, character, and modern updates in this charming 2-bedroom, 1-bath brick ranch. Hardwood floors flow throughout the main level. The kitchen offers white shaker cabinets, quartz countertops, stainless steel appliances, and an original mint-green and black tile backsplash. The updated bathroom features a matte-black vanity and fixtures complemented by original two-tone tile. The

    Arthur Greenlee IV eXp Realty

    Section Image
  • 540 Grand Ave, Cincinnati, OH 45205

    $279,900 $10K PRICE DROP

    • 3,456 Sq Ft
    • 540 Grand Ave
    • Cincinnati, OH

    Seller financing available! Fully renovated duplex offering an outstanding opportunity for both owner-occupants and investors. Live in the spacious vacant 5-bedroom, 2-bath unit while generating immediate rental income from the 2-bedroom, 1-bath unit, currently leased at $1,350 per month through October 2026. The seller is willing to negotiate an early lease termination before closing, with any

    Arthur Greenlee IV eXp Realty

    Section Image
  • 2369 Piazza Ridge, Covington, KY 41017

    $234,900 Pending

    • 2 Beds
    • 2 Baths
    • 1,326 Sq Ft
    • 2369 Piazza Ridge
    • Covington, KY

    Welcome to easy, low-maintenance living in the desirable Tuscany community! This beautifully maintained 2-bedroom, 2-bath condo offers an open-concept layout with a spacious living area, dining space, and well-appointed kitchen perfect for everyday living and entertaining. The primary suite features a private bath and walk-in closet, while the second bedroom provides flexibility for guests or a

    Arthur Greenlee IV eXp Realty, LLC

    Section Image
  • 29 Riebel Ridge Dr, New Richmond, OH 45157

    $59,999

    • Land
    • 2.56 Acres
    • $23,437 per Acre
    • 29 Riebel Ridge Dr
    • New Richmond, OH

    Bring your vision to life on this beautiful lot located in the desirable Riebel Ridge community. Offering a peaceful setting with plenty of room to build, this property provides the perfect blend of privacy and convenience. Enjoy the charm of country living while remaining just minutes from schools, shopping, dining, and everyday amenities. Whether you're planning your forever home or your next

    Arthur Greenlee IV eXp Realty

    Section Image

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1887005

MLS of Greater Cincinnati (CincyMLS)
Your Personal Tour Guide

Ask me questions while you tour the home.