Skip main navigation
Off market
    • $692,400

    407 Collins Ave, Cincinnati, OH 45202

    3beds
    2,288sqft
    Single Family Residence
    Built in 2017
    -- sqft lot
    $692,400 Zestimate®
    $303/sqft
    $3,615 Estimated rent

    Home value

    $692,400

    $658,000 - $727,000

    $3,615/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

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

    Rent Zestimate®

    Refinance and save

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

    Roof top deckBeautiful hardwood floorsCeramic coated windowsCustom built modern home

    Impeccable custom built Modern home w/ easy access to downtown and privacy not typical in the city. LEED Gold certified. Tax abated through 2032. Meticulously maintained inside and out. Open concept with unique design touches. Home features beautiful hardwood floors, 2nd floor laundry, master on-suite with walk out, ceramic coated windows for sun/heat. Private outdoor patio/fire pit w/ roof top deck, tailored landscaping. Close to everything. Must See!

    This property is not currently displayed as for sale or rent on Zillow. This may be different from what's on other websites or public sources.

    Zillow last checked:

    Listing updated:

    Listed by:

    Grant R Steed 513-713-3810,

    Lou Park Realty 513-428-9798

    Bought with:

    William Draznik, 2006001330

    Coldwell Banker Realty

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

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Primary bedroom
    • Features: Walk-In Closet(s), Walkout, Wood Floor
    • Level: Second
    • Area: 272
    • Dimensions: 17 x 16
    Bedroom 2
    • Level: Second
    • Area: 165
    • Dimensions: 15 x 11
    Bedroom 3
    • Level: Second
    • Area: 169
    • Dimensions: 13 x 13
    Bedroom 4
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 5
    • Area: 0
    • Dimensions: 0 x 0
    Primary bathroom
    • Features: Double Vanity, Marb/Gran/Slate, Shower, Tile Floor
    Bathroom 1
    • Features: Partial
    • Level: First
    Bathroom 2
    • Features: Full
    • Level: Second
    Bathroom 3
    • Features: Full
    • Level: Second
    Dining room
    • Features: Chandelier, Walkout, Wood Floor
    • Level: First
    • Area: 120
    • Dimensions: 15 x 8
    Family room
    • Area: 0
    • Dimensions: 0 x 0
    Great room
    • Features: Wood Floor
    Kitchen
    • Features: Counter Bar, Eat-in Kitchen, Gourmet, Kitchen Island, Pantry, Walkout, Wood Cabinets, Wood Floor
    • Area: 272
    • Dimensions: 17 x 16
    Living room
    • Features: Wood Floor
    • Area: 323
    • Dimensions: 19 x 17
    Office
    • Area: 0
    • Dimensions: 0 x 0
    Heating
    • Gas Furn EF Rtd 95%+, Variable Speed HVAC
    Cooling
    • Central Air
    Appliances
    • Included: Water Heater (High Effic Heat Pump)
    Features
    • High Ceilings
    • Windows: Aluminum Frames, ENERGY STAR Qualified Windows, Low Emissivity Windows, Picture, Wood Frames
    • Basement: Partial
    Interior area
    • Total structure area: 2,288
    • Total interior livable area: 2,288 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Driveway, On Street, Garage Door Opener
    • Garage spaces: 2
    • Has uncovered spaces: Yes
    Features
    • Stories: 3
    • Patio & porch: Patio
    • Exterior features: Balcony, Other
    • Has view: Yes
    • View description: City, River
    • Has water view: Yes
    • Water view: River
    • Waterfront features: River
    Lot
    • Features: Less than .5 Acre
    • Topography: Sloping
    Details
    • Parcel number: 0640001001400

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary/Modern
    • Property subtype: Single Family Residence
    Materials
    • Fiber Cement, Brick, Other
    • Foundation: Concrete Perimeter
    • Roof: Membrane,Shingle
    Condition
    • New construction: No
    • Year built: 2017

    Utilities & green energy

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

    Community & HOA

    Community
    • Security: Security System
    HOA
    • Has HOA: No
    Location
    • Region: Cincinnati

    Financial & listing details

    • Price per square foot: $303/sqft
    • Tax assessed value: $556,790
    • Annual tax amount: $1,174
    • Date on market: 7/8/2023
    • Listing terms: No Special Financing

    Price history

    DateEventPrice
    9/1/2023Sold$640,000-4.5%$280/sqft
    Source: Cincy MLS #1777556 Report a problem
    7/14/2023Pending sale$670,000$293/sqft
    Source: Cincy MLS #1777556 Report a problem
    7/8/2023Listed for sale$670,000+34%$293/sqft
    Source: Cincy MLS #1777556 Report a problem
    2/28/2019Sold$500,000-7.4%$219/sqft
    Source: Cincy MLS #1605226 Report a problem
    2/8/2019Pending sale$540,000$236/sqft
    Source: OwnerLand Realty, Inc. #1605226 Report a problem
    2/5/2019Price change$540,000-1.8%$236/sqft
    Source: OwnerLand Realty, Inc. #1605226 Report a problem
    12/18/2018Price change$550,000-5.2%$240/sqft
    Source: OwnerLand Realty, Inc. #1605226 Report a problem
    11/13/2018Price change$580,000-0.9%$253/sqft
    Source: OwnerLand Realty, Inc. #1565196 Report a problem
    9/17/2018Price change$585,000-1.7%$256/sqft
    Source: OwnerLand Realty, Inc. #1565196 Report a problem
    8/6/2018Price change$595,000-0.8%$260/sqft
    Source: Plum Tree Realty #1565196 Report a problem
    7/17/2018Price change$600,000-2.4%$262/sqft
    Source: Plum Tree Realty #1565196 Report a problem
    6/8/2018Price change$615,000-1.6%$269/sqft
    Source: Plum Tree Realty #1565196 Report a problem
    5/22/2018Price change$625,000-2.3%$273/sqft
    Source: Plum Tree Realty #1565196 Report a problem
    5/8/2018Price change$640,000-1.5%$280/sqft
    Source: Plum Tree Realty #1565196 Report a problem
    4/23/2018Price change$650,000-2.3%$284/sqft
    Source: Plum Tree Realty #1565196 Report a problem
    3/30/2018Price change$665,000-1.5%$291/sqft
    Source: Plum Tree Realty #1565196 Report a problem
    3/2/2018Price change$675,000-3.4%$295/sqft
    Source: Plum Tree Realty #1565196 Report a problem
    1/22/2018Price change$699,000-3.6%$306/sqft
    Source: Plum Tree Realty #1565196 Report a problem
    10/13/2017Price change$725,000-3.3%$317/sqft
    Source: Plum Tree Realty #1553551 Report a problem
    9/19/2017Listed for sale$750,000+1900%$328/sqft
    Source: Plum Tree Realty #1553551 Report a problem
    6/23/2015Listing removed$37,500+733.3%$16/sqft
    Source: Plum Tree Realty #1422565 Report a problem
    8/21/2013Sold$4,500-30.8%$2/sqft
    Source: Cincy MLS #1364154 Report a problem
    8/9/2013Pending sale$6,500$3/sqft
    Source: OwnerLand Realty #1364154 Report a problem
    7/12/2013Price change$6,500+44.4%$3/sqft
    Source: OwnerLand Realty #1364154 Report a problem
    6/29/2013Listed for sale$4,500+80%$2/sqft
    Source: OwnerLand Realty #1364154 Report a problem
    8/17/2012Sold$2,500-96.6%$1/sqft
    Source: Public Record Report a problem
    2/22/2007Sold$74,000+15.6%$32/sqft
    Source: Public Record Report a problem
    2/6/1997Sold$64,000$28/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$1,174 +3.1%$194,877
    2024$1,139 -2.2%$194,877
    2023$1,164 +0.5%$194,877 +11.4%
    2022$1,159 +1.2%$175,000
    2021$1,146 $175,000
    2020$1,146 -10%$175,000 -8.3%
    2019$1,273 +9.1%$190,799 +1107.7%
    2018$1,168 $15,799
    2017$1,168 +940.9%$15,799 +902.5%
    2016$112 $1,576
    2015$112 -0.5%$1,576
    2014$113 -94.6%$1,576 -94.8%
    2013$2,105 +2.3%$30,475
    2012$2,058 +7.7%$30,475
    2011$1,911 +48.7%$30,475 +40.4%
    2010$1,285 +3.8%$21,700
    2009$1,238 +1.8%$21,700
    2008$1,215 -21.8%$21,700 -31.8%
    2007$1,554 +1.1%$31,815
    2006$1,536 -0.9%$31,815
    2005$1,550 +21.5%$31,815 +32.5%
    2003$1,276 +6.7%$24,010
    2002$1,197 +3%$24,010 +9.6%
    2001$1,162 +3.4%$21,910
    2000$1,124 $21,910
    Find assessor info on the county website

    Neighborhood: East Walnut Hills

    Nearby homes

    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
    $692,400
    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
    $692,400

    Nearby cities

    Nearby neighborhoods

    Nearby zip codes

    Other Cincinnati Topics

      Search
      Updates
      Favorites
      Plan
      Inbox