Skip main navigation
For sale
  • $649,900

    4787 Sycamore St, Lima, OH 45807

    4beds
    3,640sqft
    : 
    $4,332/mo
    Get pre-qualified
    Single Family Residence
    Built in 1993
    0.89 Acres Lot
    $-- Zestimate®
    $179/sqft
    $-- HOA

    What's special

    Detached two-car garageIrrigation systemScreened porchOutstanding curb appealFifth bedroomOutstanding storageSpacious patio
    Welcome to this exceptional custom-built Laurel Oaks home offering more than 5,300 square feet of thoughtfully designed living space on nearly one beautifully landscaped acre. Built with quality craftsmanship and timeless design, this home offers generous living spaces, remarkable versatility, and exceptional attention to detail. Floor-to-ceiling windows fill the home with natural light and complement the open floor plan designed for both everyday living and entertaining. The main level features a grand entry, spacious living room with fireplace, open kitchen and dining area, walk-in pantry, and a private office or flex room. Upstairs you'll find 3 spacious bedrooms, convenient second-floor laundry, abundant storage, and a large bonus room over the attached garage complete with a wet bar and separate heating and cooling system. Ideal as a media room, game room, guest suite, or additional living space. The finished lower level adds over 1,600 square feet and feels anything but a traditional basement thanks to its open design and oversized windows. It includes a second kitchen, large family room with stone fireplace, full bath, fifth bedroom, flex room perfect for a home gym or theater, and a secure fire-protected vault room. Outdoor living is just as impressive with a screened porch, spacious patio, irrigation system, mature landscaping, and outstanding curb appeal. A true bonus is the detached heated and air-conditioned building featuring two additional garage bays and a finished flex space currently used as a fitness studio. Perfect for a collector's garage, workshop, home business, office, or hobby space. Complete with an attached three-car garage, detached two-car garage, outstanding storage, and quality construction throughout, this is a home designed to fit every stage of life. Properties offering this level of space, flexibility, and craftsmanship are rarely available.
    13 days
    |
    715
    |
    30
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Jason Liening 419-302-0620,

    Cowan, Realtors

    Source: WCAR OH,MLS#: 311089MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 5
      • Full bathrooms: 3
      • 1/2 bathrooms: 2
      Bedroom 1
      • Level: Second
      • Area: 223.79 Square Feet
      • Dimensions: 16.1 x 13.9
      Bedroom 2
      • Level: Second
      • Area: 183.02 Square Feet
      • Dimensions: 16.4 x 11.16
      Bedroom 3
      • Level: Second
      • Area: 182.4 Square Feet
      • Dimensions: 15.2 x 12
      Bedroom 4
      • Level: Lower
      • Area: 172.92 Square Feet
      • Dimensions: 13.2 x 13.1
      Dining room
      • Level: First
      • Area: 227.55 Square Feet
      • Dimensions: 18.5 x 12.3
      Family room
      • Level: Lower
      • Area: 813 Square Feet
      • Dimensions: 30 x 27.1
      Kitchen
      • Level: First
      • Area: 263.67 Square Feet
      • Dimensions: 18.7 x 14.1
      Living room
      • Level: First
      • Area: 394.71 Square Feet
      • Dimensions: 22.3 x 17.7
      Office
      • Level: First
      • Area: 234.9 Square Feet
      • Dimensions: 17.4 x 13.5
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Disposal, Dryer, Electric Cooktop, Microwave, Range, Refrigerator, Washer
      Features
      • Central Vacuum, Wet Bar
      • Flooring: Carpet, Tile, Vinyl
      • Basement: Concrete,Finished
      • Has fireplace: Yes
      • Fireplace features: Basement, Family Room, Living Room
      Interior area
      • Total structure area: 3,640
      • Total interior livable area: 3,640 sqft
      • Finished area below ground: 1,600
      Video & virtual tour

      Property

      Parking
      • Total spaces: 5
      • Parking features: Detached, Garage
      • Garage spaces: 5
      Features
      • Levels: One,Two
      • Patio & porch: Covered, Patio, Porch, Screened
      Lot
      • Size: 0.89 Acres
      • Dimensions: 220 x 177
      • Features: Rolling Slope
      Details
      • Additional structures: Garage(s), Outbuilding, Storage, Workshop
      • Parcel number: 36170404008.000
      • Zoning description: Residential
      • Special conditions: Fair Market

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Brick Veneer, HardiPlank Type, Vinyl Siding
      • Foundation: Other
      Condition
      • Year built: 1993

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Natural Gas Connected, Water Connected

      Community & HOA

      HOA
      • Has HOA: No
      Location
      • Region: Lima

      Financial & listing details

      • Price per square foot: $179/sqft
      • Tax assessed value: $533,600
      • Annual tax amount: $8,163
      • Date on market: 8/6/2026
      • Listing terms: Cash,Conventional,VA Loan

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        8/6/2026Listed for sale$649,900$179/sqft
        Source: WCAR OH #311089 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024$8,163 +15.2%$186,760 +29%
        2023$7,088 -2%$144,760
        2022$7,231 -0.5%$144,760
        2021$7,267 +5.9%$144,760 +12.6%
        2020$6,859 -1.3%$128,520
        2019$6,947 -0.7%$128,520
        2018$6,996 +21.8%$128,520 +17.6%
        2017$5,746 +0.1%$109,270
        2016$5,741 -0.7%$109,270
        2015$5,779 +0.8%$109,270 +4.4%
        2014$5,735 +10.3%$104,690
        2013$5,200 +3%$104,690
        2012$5,049 -3.1%$104,690 -4%
        2011$5,213 +0.5%$109,030
        2010$5,185 +2.6%$109,030
        2009$5,051 -3.5%$109,030 -4.2%
        2008$5,233 +15.8%$113,820
        2007$4,521 $113,820
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 45807

        Getting around

        18 / 100
        Car-Dependent
        17 / 100
        Minimal Transit
        29 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes