The Auburn offers the largest floor plan in the Yacht Club Community, featuring approximately 2,334 square feet of well-appointed living space with 10-foot ceilings. This desirable end-unit includes an updated Eat-in Kitchen that opens to the Dining area with a charming bay window. The spacious Living Room provides access to a covered composite deck, perfect for relaxing or entertaining. The Primary Suite features an adjoining luxury bath with a jetted tub and double vanity. First Floor Laundry- An open staircase leads to the finished walkout Lower Level, complete with a Family room, wet bar, wood-burning fireplace, and a third bedroom or private study. Enjoy direct access to the covered patio from the lower level. Additional updates include a new HVAC system (2023). Experience the sought-after Yacht Club lifestyle with access to the clubhouse, swimming pool, tennis courts, and pickleball courts.
Association Dues, Professional Mgt, Landscaping-Community, Landscaping-Unit, Maintenance Exterior
Annual taxes (per listing)
$4,296
Property
Type
Condominium
Year built
Built in 1998
Price per sq ft
$153/sq ft
Days on market
39
County
Hamilton
High school district
Northwest Local SD (verify with the district)
MLS #
1897158
See more of this home
Enter your email to see the rest of this home's photos and history.
You can request a tour, call, or contact an agent without doing this.
Sale history
Nov 15, 2026Price change
was $374,900 · Source: CincyMLS
$359,900
Oct 13, 2026Listed
Source: CincyMLS
$374,900
May 18, 2004Transfer
Source: Hamilton County Auditor
—
Sold history: Hamilton County Auditor public records, retrieved Nov 14, 2026.
Listing dates and prices from CincyMLS.
Public-record transfers include non-sale deeds; a Transfer shows no price. Sold or Transfer follows each
county's own sale-validity flag where it publishes one. Sale and deed dates are as recorded by each
source; a price change is dated when our listing feed first showed it.
Similar homes that sold nearby
Recent sales of homes like this one in ZIP 45252. They show what other homes sold for, not what this one will sell for.
$285,000
Sold Aug 2026
3832 Enterprise Circle
Colerain Twp, OH 45252
2 bd · 3 ba · 1,988 sq ft · Built 1998
Listing courtesy of Sibcy Cline, Inc. 513-385-0900 · Mark Schupp 513-543-1477
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.
How these were chosen: sales of the same home type (Condominium) in ZIP 45252 that closed in the last 12 months, within 25% of this home's square footage and 20 years of its age, with at most 1 bedroom and 1 full bath of difference. New construction is left out, at most 2 are shown, and not every sale in the ZIP is shown. Source: CincyMLS.
One of our agents would be happy to provide you with a current CMA.
Opens FEMA's flood map and USDA's eligibility map. FEMA's map is a starting point — your lender's flood check is final. USDA's map covers the location only; income limits and the lender's review also apply.
3826 Enterprise Circle, Colerain Twp, OH, 45252
Map shows the approximate property location.
Listed by Mark Schupp · 513-543-1477. Listing courtesy of Sibcy Cline, Inc. · 513-385-0900. Data via Cincinnati Multiple Listing Service.
The data relating to real estate appearing on this site comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati. Properties marked with the Broker Reciprocity icon are provided courtesy of the MLS of Greater Cincinnati. Information is deemed reliable but not guaranteed — independently verify all details. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Equal Housing Opportunity. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.
CincyMLS data last updated November 21, 2026 at 5:15 AM ET.