Skip main navigation
New construction
  • Price increase: $559K (3/3)
    $849,000

    0 Schlottman Rd, Maineville, OH 45039

    3beds
    2,062sqft
    : 
    Single Family Residence
    Built in ----
    2.22 Acres Lot
    $-- Zestimate®
    $412/sqft
    $-- HOA

    What's special

    Welcoming entryPrivate primary suiteRural lotDining areaCovered back porchWalk-in closetSpacious en-suite bath
    Don't miss this ranch by Ashford Homes! Set on a rural lot, it offers the perfect blend of peaceful surroundings while still being a convenient distance to several city centers. The thoughtfully designed layout features 3 bedrooms, 2 full baths, and the opportunity to expand with an unfinished lower level. The private primary suite includes a spacious en-suite bath and walk-in closet. A welcoming entry opens to the great room with a fireplace, flowing seamlessly into the gourmet kitchen, dining area, and covered back porch. A dedicated study or home office adds flexibility for work or hobbies. Located less than 10 minutes from downtown Loveland's shops and restaurants, you'll enjoy quiet country living without sacrificing nearby amenities. The property is part of a larger parcel recently divided into three separate lots, giving you the opportunity to choose the perfect setting. Or work with the builder to design what works for you! Currently subject to an agricultural tenant lease.
    20 hours
    |
    140
    |
    8
    |

    Zillow last checked: 8 hours ago

    Listing updated: 11 hours ago

    Listed by:

    Laura Wogen 513-383-8880,

    Coldwell Banker Realty 513-321-9944,

    Michael P Hines 513-260-0424,

    Coldwell Banker Realty

    Source: Cincy MLS,MLS#: 1870424MLS LogoOriginating MLS: Cincinnati Area Multiple Listing Service

    Tour with a local agent

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 2
    • Full bathrooms: 2
    Primary bedroom
    • Features: Bath Adjoins, Walk-In Closet(s), Wall-to-Wall Carpet, Window Treatment
    • Level: First
    • Area: 234
    • Dimensions: 18 x 13
    Bedroom 2
    • Level: First
    • Area: 132
    • Dimensions: 12 x 11
    Bedroom 3
    • Level: First
    • Area: 132
    • Dimensions: 12 x 11
    Bedroom 4
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 5
    • Area: 0
    • Dimensions: 0 x 0
    Primary bathroom
    • Features: Shower, Tile Floor, Double Vanity, Tub
    Bathroom 1
    • Features: Full
    • Level: First
    Bathroom 2
    • Features: Full
    • Level: First
    Dining room
    • Area: 0
    • Dimensions: 0 x 0
    Family room
    • Area: 0
    • Dimensions: 0 x 0
    Great room
    • Features: Fireplace, Wood Floor
    • Level: First
    • Area: 272
    • Dimensions: 17 x 16
    Kitchen
    • Features: Pantry, Eat-in Kitchen, Galley, Gourmet, Window Treatment, Kitchen Island, Wood Floor
    • Area: 208
    • Dimensions: 16 x 13
    Living room
    • Area: 0
    • Dimensions: 0 x 0
    Office
    • Features: French Doors, Window Treatment, Wood Floor
    • Level: First
    • Area: 120
    • Dimensions: 12 x 10
    Heating
    • Electric, Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Microwave, Oven/Range, Refrigerator, Electric Water Heater
    Features
    • High Ceilings, Recessed Lighting
    • Doors: Multi Panel Doors
    • Basement: Full,Unfinished
    • Number of fireplaces: 1
    • Fireplace features: Gas, Great Room
    Interior area
    • Total structure area: 2,062
    • Total interior livable area: 2,062 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Off Street, Driveway
    • Garage spaces: 2
    • Has uncovered spaces: Yes
    Features
    • Levels: One
    • Stories: 1
    • Patio & porch: Covered Deck/Patio
    Lot
    • Size: 2.22 Acres
    • Features: 1 to 4.9 Acres
    Details
    • Parcel number: NEW/UNDER CONST/TO BE BUILT

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Ranch
    • Property subtype: Single Family Residence
    Materials
    • Stone, Fiber Cement
    • Foundation: Concrete Perimeter
    • Roof: Shingle
    Condition
    • New construction: Yes
    Details
    • Builder name: Ashford Homes Llc

    Utilities & green energy

    • Gas: None
    • Sewer: None
    • Water: At Street

    Community & HOA

    HOA
    • Has HOA: No
    Location
    • Region: Maineville

    Financial & listing details

    • Price per square foot: $412/sqft
    • Date on market: 3/3/2026
    • Listing terms: No Special Financing
    Get pre-qualifiedBe ready to make an offer.
    Connect with an agentGet info on this home, tour, and more.
    Calculate monthly paymentSee if you can afford this home.

    Estimated market value

    Not available

    Estimated sales range

    Not available

    Not available

    Price history

    Price history
    DateEventPrice
    3/3/2026Price change$849,000+192.8%$412/sqft
    Source: Cincy MLS #1870424 Report a problem
    3/3/2026Price change$290,000+31.8%$141/sqft
    Source: Cincy MLS #1870374 Report a problem
    3/2/2026Listed for sale$220,000-62%$107/sqft
    Source: Cincy MLS #1868987 Report a problem
    7/17/2024Listing removed--
    Source: Cincy MLS #1793860 Report a problem
    6/28/2024Price change$579,000+15.8%$281/sqft
    Source: Cincy MLS #1793890 Report a problem
    6/5/2024Price change$499,950+16.5%$242/sqft
    Source: Cincy MLS #1793890 Report a problem
    5/22/2024Price change$429,000-4.6%$208/sqft
    Source: Cincy MLS #1793890 Report a problem
    5/14/2024Price change$449,900-10%$218/sqft
    Source: Cincy MLS #1793890 Report a problem
    5/10/2024Price change$499,950+2.2%$242/sqft
    Source: Cincy MLS #1793860 Report a problem
    5/2/2024Price change$489,000-2.7%$237/sqft
    Source: Cincy MLS #1793890 Report a problem
    4/16/2024Price change$502,750-6.7%$244/sqft
    Source: Cincy MLS #1793890 Report a problem
    1/18/2024Listed for sale$539,000+450%$261/sqft
    Source: Cincy MLS #1793890 Report a problem
    3/24/2021Listing removed--
    Source: Owner Report a problem
    1/8/2020Listing removed$98,000$48/sqft
    Source: Owner Report a problem
    10/9/2019Listed for sale$98,000$48/sqft
    Source: Owner Report a problem

    Public tax history

    Public tax history
    Tax history is unavailable.

    BuyAbility℠ payment

    Est. payment
    $4,808/mo
    Principal & interest
    $4016
    Property taxes
    $792

      Climate risks

      Neighborhood: 45039

      Nearby schools

      GreatSchools rating

      Local experts in 45039

      Similar homes

      Skip to the end of the carouselSkip to the beginning of the carousel