For more information on this property, contact Gary Rossignol at 513-777-2402 or

3815 Erie Avenue
Cincinnati, Ohio OH 45208
Price: $2,995,000
Est. Monthly Payment: $12,862.25 See Details
Listing ID 1527916
Status Active
Bedrooms 5
Full Baths 5
Total Baths 6
Partial Baths 1
Acres 5

Property Description:

Absolutely exquisite total restoration. New garages, salt water pool / 5 acres of privacy / Gated drive / LEED certified / Tax abatement / Rookwood / Geo-Thermal / Home Automation...Additional lots available with purchase.
{"zipcode": "45208", "price": "2995000"}
Down Payment
Credit Score
Loan Amount
Loan Type

Show All Rates

Primary Features

Age: 86
Appliances: Oven/Range, Dishwasher, Refrigerator, Microwave, Dryer, Washer
Architecture: Tudor
Area: Hamilton-E04
Available for Lease: no
Cooling: Central Air
County: Hamilton
District: Cincinnati City SD
Fireplace: Gas
Garage: Side, Oversized
Heating: Geothermal
Parking: Driveway
Property Type: Residential
Suburb: Hyde Park

Financial Details

Annual Assessment Amount: Of Record
Auction: no
HOA: no
HOA Fee: N/A
Price Per Acre: 599000.00
Search Price: 2995000.00
Semi-Annual Taxes: 15,951
Special Financing: no
Tax ID#: 038-0002-0026-00
Tax Rate: Of Record
Zero Selling Price: no


Association: Cincinnati Area Multiple Listing Service
Construction: Stone, Stucco
Degree Complete: Existing Structure
FIPS Code: 61
Foundation: Poured
Gas: Natural
Listing RID: 978492
Miscellaneous: Cable TV, Ceiling Fan, Recess Lights, Smoke Alarm, Garage Door Opener, Security System, Hot Tub/Spa, Sauna, 220 Volt, Intercom, Central Vacuum, Fountain, High Tech Wiring
New Construction: no
Property Description: Single Family
Property Disclaimer: Information has not been verified, is not guaranteed and subject to change.
Property Subtype 1: Single Family Residence
Sewer: Public
Validated: yes
Water Source: Public

Interior Features

Basement: Full
Basement Features: Finished, Walkout, Fireplace, WW Carpet
Bath 1: Full
Bath 1 Features: Shower, Tub, Double Vanity, Marb/Gran/Slat, Heated Floors
Bath 1 Level: 2
Bath 2: Full
Bath 2 Level: 2
Bath 3: Full
Bath 3 Level: 2
Bath 4: Partial
Bath 4 Level: 1
Bath Level 1 Type: Partial
Bathroom Level 1: yes
Bedroom 2: 15x14 Level: 2
Bedroom 2 Area: 210
Bedroom 2 Dimensions: 15 x 14
Bedroom 2 Length: 15
Bedroom 2 Width: 14
Bedroom 3: 15x11 Level: 2
Bedroom 3 Area: 165
Bedroom 3 Dimensions: 15 x 11
Bedroom 3 Length: 15
Bedroom 3 Width: 11
Bedroom 4: 17x17 Level: 3
Bedroom 4 Area: 289
Bedroom 4 Dimensions: 17 x 17
Bedroom 4 Length: 17
Bedroom 4 Width: 17
Bedroom 5: 17x16 Level: 3
Bedroom 5 Area: 272
Bedroom 5 Dimensions: 17 x 16
Bedroom 5 Length: 17
Bedroom 5 Width: 16
Bedroom Level 1: no
Breakfast Room Dimensions: 0 x 0
Dining Room: 31x15 Level: 1
Dining Room Area: 465
Dining Room Dimensions: 31 x 15
Dining Room Feat: Wood Floors, Chandelier, Chair Rail, Walkout, French Doors, Built-ins
Dining Room Length: 31
Dining Room Width: 15
Entry: 18x14 Level: 1
Entry (Foyer): Wood Floors, Closet, Open Foyer, Transom/Sidelit
Entry Area: 252
Entry Dimensions: 18 x 14
Entry Length: 18
Entry Width: 14
Family Room: yes
Family Room: 32x19 Level: Lower
Family Room Features: Fireplace, Walkout, Wet Bar
FamilyRoom Area: 608
FamilyRoom Dim: 32 x 19
FamilyRoom Length: 32
FamilyRoom Width: 19
Fireplaces: 3
Formal Dining Room: yes
Half Bathrooms: 1
Inside Features: Multi Panel Doors, 9Ft + Ceiling, Crown Molding, Natural Woodwork, Beam Ceiling, French Doors, Media Room, Great Room, Bonus Room, Heated Floors
Kitchen: 32x16 Level: 1
Kitchen Area: 512
Kitchen Dimensions: 32 x 16
Kitchen Features: Wood Floor, Marble/Granite/Slate, Eat-In, Gourmet, Wood Cabinets, Island, Walkout, Butler's Pantry
Kitchen Length: 32
Kitchen Width: 16
Land Description: 5 to 9.9 Acres
Laundry Room: 8x8 Level: 2
Laundry Room Area: 64
Laundry Room Dimensions: 8 x 8
Laundry Room Length: 8
Laundry Room Width: 8
Levels: Three
Living Room Features: Wood Floors, Fireplace, Bookcase
Living/Great Room: 32x19 Level: 1
Living/Great Room Area: 608
Living/Great Room Dimensions: 32 x 19
Living/Great Room Length: 32
Living/Great Room Width: 19
Master Bedroom: 32x19 Level: 2
Master Bedroom Area: 608
Master Bedroom Dimensions: 32 x 19
Master Bedroom Features: Wood Floor, Bath Adjoins, Walk-in Closet, Sitting Room, Fireplace
Master Bedroom Length: 32
Master Bedroom Width: 19
Recreation Room: 18x18 Level: Lower
Recreation Room Area: 324
Recreation Room Dimensions: 18 x 18
Recreation Room Length: 18
Recreation Room Width: 18
Rooms: 20
Study Features: Wood Floor, Bookcase, Panel Walls
Study/Library/Den: 15x13 Level: 1
Study/Library/Den Area: 195
Study/Library/Den Dimensions: 15 x 13
Study/Library/Den Length: 15
Study/Library/Den Width: 13

Location Information

Directions: Private gated stone Turret entry - On Erie between Hampton Lane and Forest Hill
School Name 1: Call SD 513-363-0000
School Type 1: District Phone
Suburb (SIC): Hyde Park

External Features

Garage Spaces: 4
Lot Dimensions: Irregular
Lot Measurement: Acres
Lot SqFt Range: 217800
Outside Features: Patio, Porch, Encl Porch/Patio, Pool In-Ground, Yard Lights, Sprinklers, BBQ Grill, Wooded Lot, Other
Roof: Tile
View: Woods
Windows: Insulated, Vinyl, Wood

Zoning Info

Area Info

Listing courtesy of Michael C Hinckley (513)-533-8080 from Coldwell Banker West Shell 321-9944
© 2017 The data relating to real estate for sale on this web site comes from the Internet Data Display (IDD) of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than Berkshire Hathaway HomeServices Professional Realty are marked with the IDD logo and detailed information about them includes the name of the listing brokers. The information being provided is 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.

Contact - Listing ID 1527916

Gary Rossignol

9032 Union Centre Blvd, Suite 100
West Chester, OH 45069
Phone: 513-777-2402
Phone Alt: 513-777-2402

Data services provided by IDX Broker