Experience timeless elegance and unparalleled privacy in this custom-built Ed Weber masterpiece, offering over 8000 sf of refined living. Nestled on 4.7 meticulously landscaped acres adjacent to Coldstream CC, this estate features a stately gated entrance and a 3-car oversized garage. Inside boasts 5 spacious bedrooms & 7 baths, highlighted by a dramatic double-height great room w/ coffered ceilings. The eat-in kitchen has an expansive island and cozy sitting area that's complete with one of the home's four fireplaces. The partially finished LL provides ample opportunity to create your dream amenities - golf simulator, private theater or more. Exceptional outdoor space built to entertain and unwind has a revamped paver patio leading to a resort-style gunite pool w/ tranquil waterfall that's surrounded by lush landscaping, vibrant flowers and a serene canopy of mature trees. With timeless style and abundant space, this is a rare offering in one of Cincinnati's most coveted communities.
For sale
$1,999,999
7335 Five Mile Rd, Cincinnati, OH 45230
5beds
--sqft
Est.:
Single Family Residence
Built in 1995
4.69 Acres Lot
$-- Zestimate®
$--/sqft
$-- HOA
What's special
- 11 days
- on Zillow |
- 543 |
- 19 |
Zillow last checked: 7 hours ago
Listing updated: July 30, 2025 at 01:16pm
Listed by:
Joseph G. Stevie 859-991-6331,
Sparen Realty 859-991-6331
Source: Cincy MLS,MLS#: 1849291
Originating MLS: Cincinnati Area Multiple Listing Service

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 7
- Full bathrooms: 5
- 1/2 bathrooms: 2
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Fireplace, Sitting Room
- Level: Second
- Area: 812
- Dimensions: 29 x 28
Bedroom 2
- Level: First
- Area: 182
- Dimensions: 14 x 13
Bedroom 3
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 4
- Level: Second
- Area: 180
- Dimensions: 15 x 12
Bedroom 5
- Level: Second
- Area: 240
- Dimensions: 16 x 15
Primary bathroom
- Features: Built-In Shower Seat, Shower, Double Vanity, 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: Chandelier
- Level: First
- Area: 240
- Dimensions: 16 x 15
Family room
- Features: Bookcases, Fireplace
- Area: 192
- Dimensions: 16 x 12
Great room
- Level: First
- Area: 483
- Dimensions: 23 x 21
Kitchen
- Features: Pantry, Counter Bar, Eat-in Kitchen, Gourmet, Kitchen Island, Marble/Granite/Slate
- Area: 312
- Dimensions: 24 x 13
Living room
- Area: 0
- Dimensions: 0 x 0
Office
- Features: Bookcases, Window Treatment, Wood Floor
- Level: First
- Area: 165
- Dimensions: 15 x 11
Heating
- Forced Air, Gas, Zoned
Cooling
- Central Air
Appliances
- Included: Gas Water Heater
Features
- Windows: Casement, Double Hung, Wood Frames
- Basement: Full,Finished,Walk-Out Access,WW Carpet
- Number of fireplaces: 4
- Fireplace features: Marble, Stone, Gas, Basement, Family Room, Master Bedroom
Interior area
- Total structure area: 0
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Off Street, Driveway
- Garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
Lot
- Size: 4.69 Acres
Details
- Parcel number: 50002630005
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional,Transitional
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 1995
Utilities & green energy
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Cincinnati
Financial & listing details
- Tax assessed value: $1
- Annual tax amount: $37,010
- Date on market: 7/24/2025
- Listing terms: No Special Financing
- Loading
- Loading