4577 Philnoll Drive
Colerain Twp, OH 45247
Email Text
Share

Description

Rare opportunity to own this custom built estate. Approx 7000 SqFt of luxury finish. Open floor plan with 1st floor master, designer kitchen & 2 story great room opens to private terrace. 2000 SqFt pub with guest quarters, theater & fitness rooms. Situated on 1.2 acre lot near highway access.

Details

MLS#1606165
StyleHouse
Sub-TypeResale
StatusActive
Year2000
Days On Site234

Features

Bed(s)5
Bath(s) 5 Full, 1 Half
SQ Feet6,723
Story(s)3 Story
Acreage1.20

Loading Form

Joanna Perretta

Joanna Perretta

 (937) 269-4456

Loading Form

Area Information

StateOH
CountyHamilton
CityColerain Twp
Zip Code45247
AreaHamilton-W09
Community NameWhite Oak
School DistrictNorthwest Local SD
Listing VS Median (in White Oak)
Price:
$799,000
low | high
Med:
$189,900
100% of Average
SqFt:
6,723
low | high
Med:
2,157
100% of Average
$ / SqFt:
$119
low | high
Med:
$88
75.921675390483% of Average
On Site:
234
low | high
Med:
7
100% of Average
Listing Updated: 08/19/2019
MLS Number: 1606165
Listing Provided By:
Michael McCafferty  of  Star One Real Estate Inc.
MLS Internet Data Exchange (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, and that the data is deemed reliable but is not guaranteed accurate by the MLS of Greater Cincinnati.

Joanna Perretta - Coldwell Banker Heritage

© 2017 Coldwell Banker Heritage - (937) 429-4500.
Equal housing opportunity. An equal opportunity company.
© 2018 Coldwell Banker Heritage. Equal housing opportunity. An equal opportunity company.

© 2018 Coldwell Banker Heritage. All Rights Reserved. Coldwell Banker® and the Coldwell Banker Logo are registered service marks owned by Coldwell Banker Real Estate LLC. Coldwell Banker Heritage fully supports the principles of the Fair Housing Act and Equal Opportunity Act. Each franchise is independently owned and operated. Any services or products provided by independently owned and operated franchises are not provided by, affiliated with or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.
MLS Internet Data Exchange (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, and that the data is deemed reliable but is not guaranteed accurate by the MLS of Greater Cincinnati.
Listings updated -172 minutes ago