Skip main navigation
Off market
    • $686,800

    1574 Sycamore Ridge Dr #75, Hamilton Township, OH 45039

    5beds
    --sqft
    Single Family Residence
    Built in ----
    -- sqft lot
    $686,800 Zestimate®
    $--/sqft
    $3,281 Estimated rent

    Home value

    $686,800

    $639,000 - $735,000

    $3,281/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,281/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

    $3,281/mo

    Rent Zestimate®

    Refinance and save

    $4,207/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,207/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

    Cstm Garry Brasch home. 2 sty foy & grt rm. Hdwd ent, kit, bkfst rm. Formal LR & DR. Rear study, 9' ceil, gourmet kit, lg mstr suite & ba. 3 car side ent gar. Fin LL study & much more.

    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.

    Zillow last checked:

    Listing updated:

    Listed by:

    Bruce Koehler 513-379-8665,

    Sibcy Cline Voice of America 513-777-8100

    Bought with:

    Bruce Koehler, 0000371130

    Sibcy Cline Voice of America

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

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Primary bedroom
    • Features: Wall-to-Wall Carpet, Bath Adjoins, Walk-In Closet(s)
    • Level: Second
    • Area: 340
    • Dimensions: 17 x 20
    Bedroom 2
    • Level: Second
    • Area: 156
    • Dimensions: 12 x 13
    Bedroom 3
    • Level: Second
    • Area: 156
    • Dimensions: 12 x 13
    Bedroom 4
    • Level: Second
    • Area: 143
    • Dimensions: 11 x 13
    Bedroom 5
    • Level: Second
    • Area: 143
    • Dimensions: 11 x 13
    Primary bathroom
    • Features: Double Vanity, Shower, Tile Floor, Jetted Tub
    Bathroom 1
    • Features: Full
    • Level: Second
    Bathroom 2
    • Features: Full
    • Level: Second
    Bathroom 3
    • Features: Full
    • Level: Second
    Bathroom 4
    • Features: Full
    • Level: First
    Dining room
    • Features: WW Carpet, Chandelier, Chair Rail
    • Level: First
    • Area: 182
    • Dimensions: 13 x 14
    Family room
    • Features: Wall-to-Wall Carpet
    • Area: 342
    • Dimensions: 19 x 18
    Kitchen
    • Features: Wood Floor, Eat-in Kitchen, Wood Cabinets, Pantry, Kitchen Island, Counter Bar, Solid Surface Ctr, Walkout
    • Area: 150
    • Dimensions: 10 x 15
    Living room
    • Features: Wall-to-Wall Carpet
    • Area: 132
    • Dimensions: 11 x 12
    Office
    • Features: Wall-to-Wall Carpet
    • Area: 0
    • Dimensions: 0 x 0
    Heating
    • Gas, Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Oven/Range, Dishwasher, Disposal, Microwave
    Features
    • High Ceilings, Crown Molding, Ceiling Fan(s), Recessed Lighting
    • Doors: Multi Panel Doors, French Doors
    • Windows: Insulated Windows, Vinyl, Skylight(s)
    • Basement: Full,Partially Finished
    • Number of fireplaces: 1
    • Fireplace features: Gas, Marble
    Interior area
    • Total structure area: 0

    Property

    Parking
    • Total spaces: 3
    • Parking features: Driveway, Garage Door Opener
    • Attached garage spaces: 3
    • Has uncovered spaces: Yes
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Patio, Deck
    • Has view: Yes
    • View description: Trees/Woods
    Lot
    • Features: Wooded, Less than .5 Acre
    Details
    • Parcel number: 16114150040
    • Zoning description: Residential

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Transitional
    • Property subtype: Single Family Residence
    Materials
    • Brick
    • Foundation: Concrete Perimeter
    • Roof: Shingle
    Condition
    • New construction: Yes

    Utilities & green energy

    • Electric: 220 Volts
    • Gas: Natural
    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Cable Connected

    Community & neighborhood

    Security
    • Security features: Smoke Alarm
    Location
    • Region: Hamilton Township
    • Subdivision: Miami Bluffs

    HOA & financial

    HOA
    • Has HOA: No
    • Services included: Clubhouse, Community Landscaping, Pool, Tennis

    Other

    Other facts
    • Listing terms: No Special Financing,Conventional

    Price history

    DateEventPrice
    3/12/2004Sold$536,303
    Source: Cincy MLS #843754 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: 45039

    Nearby homes

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

    Nearby schools

    GreatSchools rating
    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
    $686,800
    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
    $686,800

    Nearby cities

    Nearby zip codes

    Other Hamilton Township Topics

      Search
      Updates
      Favorites
      Home Loans
      Inbox