• To Log in to Property Watch or Sign Up for a New Account Click Here

Cindy Brouillette

Sales Associate

  • (859) 393-6195
  • (859) 331-5887
  • Listing status icon

    $1,000,000

  • Active | MLS#: 506990
  • 5Beds
  • 7Baths

1200 Merrell Road Hebron, KY 41048

Favorite
Share
Close
Info Visit Virtual Tour Search

Overview

Main house has 4 BR, 5 full BA. Attached guest suite has LR, Kit, BR, Bath. Garage has 3 single car doors & 1 double door & bath. 2 rooms on separate HT pump. City water & 20,000 gal cistern. 3kitchens,2 laundry rooms, Florida rm, exercise rm. Gated driveway, dog kennel, in-ground, heated pool. Treed 5 acres that back up to Williams Reserve, fenced. Verify Schools.

Listing provided courtesy of: Huff Realty - Ft. Mitchell

General Features

  • Appliances Included Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer
  • Architecture Traditional
  • Area Burlgt/Hebrn/N.Boone
  • County Boone
  • Degree Complete Existing Structure
  • Full Bathrooms 7
  • Tax Rate 10.71
  • Miscellaneous 220 Volt, Cable TV, Ceiling Fan, Garage Door Opener, Recess Lights, Security System, Smoke Alarm
  • New Construction No
  • Property Type Single Family Detached
  • View Woods
  • Year Built 1998

Building Features

  • Basement Feat Finished, Fireplace, Walkout
  • Basement Type Full
  • Cooling Central Air
  • Exterior Finish Brick
  • Fireplace Gas
  • Foundation Poured
  • Gas Propane
  • Garage Detached, Oversized
  • Heating Electric, Geothermal
  • Inside Features Cathedral Ceiling, Vaulted Ceiling
  • Number Fireplaces 2
  • Number Garage Spaces 5
  • Outside Features Deck, Patio, Pool In-Ground, Wooded Lot
  • Roof Metal, Shingle
  • Number Rooms 21
  • Windows Insulated

Room Features

  • Master Bath 1 Type Full
  • Master Bedroom Dim 21x15
  • Master Bedroom Level 1
  • Master Bed Feat Bath Adjoins, Walk-in Closet, Wall-to-Wall Carpet
  • Laundry Rm Level 1
  • Living Rm Feat Fireplace, Wood Floors
  • Living Rm Level 1
  • Living Room Dim 25x18
  • Master Bath 1 Feat Ceramic Tile, Shower
  • Master Bath 1 Lvl 1
  • Bonus Rm Level 1
  • Bonus Room Name Solarium
  • Breakfast Rm Dim 16x16
  • Breakfast Rm Level 1
  • Dining Rm Dim 14x12
  • Dining Rm Feat Wood Floors
  • Dining Rm Level 1
  • Family Rm Dim 49x26
  • Family Rm Feat Fireplace, Walkout
  • Family Rm Level Lower
  • Kitchen Dim 16x11
  • Kitchen Features Ceramic Tile, Marble/Granite/Slate, Pantry, Wood Floors
  • Kitchen Level 1
  • Laundry Rm Dim 16x8
  • Bath 2 Lvl 1
  • Bath 2 Type Full
  • Bath 3 Lvl 1
  • Bath 3 Type Full
  • Bath 4 Lvl 1
  • Bath 4 Type Full
  • Bath Lvl 1 Type Full
  • Bedroom on Level 1 1
  • Bedroom2 Dim 20x12
  • Bedroom2 Level 1
  • Bedroom3 Dim 12x12
  • Bedroom3 Level 1
  • Bedroom4 Dim 16x11
  • Bedroom4 Level Lower
  • Bonus Rm Dim 27x13

Property Features

  • Land Description 5 to 9.9 Acres
  • Lot Dimensions 417x510x395x545
  • Sewer Septic
  • Water Source Public

Schools

  • Elementary School Thornwilde
  • JHS Middle School Conner Middle School
  • High School Conner Senior High
  • School District Boone County Public

Listing agent photo

Cindy Brouillette

859-393-6195Fort Mitchell Office

Ask a Question

Price & Status History

Days on Market

  • This property has been listed on the market for 127 days
  • Average days-on-market for homes between $800,000 - $1,200,000 = 127 (in zip code 41048)

Location

The property map location is: Accurate, based on Google's address match.

Walk Score

Get the Walk Score Report
Listing agent photo

Cindy Brouillette

859-393-6195Fort Mitchell Office

Ask A Question

Community Demographics for Zip Code 41048 (Hebron)

Housing Occupancy
  • Home Owners: 3,700 (73%)
  • Renters: 745 (15%)
  • Vacant: 616 (12%)
  • Total Housing Units: 5,061
Households
  • Average Household Size: 3.03
  • Housing Density (People per square mile): 613
Age Range (number of people)
  • Age 0-14: 3,225
  • Age 15-24: 2,108
  • Age 25-39: 2,510
  • Age 40-59: 2,895
  • Age 60-79: 2,255
  • Age 80+: 473
  • Total: 13,466

* All numbers in this section are 2016 projections provided by Geolytics Inc

School Information for 41048 (Hebron)

Public Schools in Zip Code 41048 (Hebron)

* This list of schools may not match the property above.

BOONE COUNTY AREA TECHNOLOGY CENTER 3320 COUGAR PATH HEBRON, KY 41048 Phone: 8596897855 9th-12th
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 0
  • Male/Female: 0/0
School District
  • BOONE CO
  • 8330 US 42 FLORENCE, KY 41042
  • Phone: 8592831003
District Population
  • Schools: 22
  • Full-Time Teachers: 1152
  • Students per Teacher: 16.1
  • Staff: 2453
  • Students: 18555
CONNER HIGH SCHOOL 3310 COUGAR PATH HEBRON, KY 41048 Phone: 8593344400 9th-12th
Grade Size Distribution
  • 9th: 322
  • 10th: 328
  • 11th: 293
  • 12th: 309
School Population
  • Teachers: 78
  • Students per Teacher: 16.1
  • Students: 1254
  • Male/Female: 642/599
School District
  • BOONE CO
  • 8330 US 42 FLORENCE, KY 41042
  • Phone: 8592831003
District Population
  • Schools: 22
  • Full-Time Teachers: 1152
  • Students per Teacher: 16.1
  • Staff: 2453
  • Students: 18555
CONNER MIDDLE SCHOOL 3300 COUGAR PATH HEBRON, KY 41048 Phone: 8593344410 6th-8th
Grade Size Distribution
  • 6th: 293
  • 7th: 306
  • 8th: 345
School Population
  • Teachers: 54
  • Students per Teacher: 17.5
  • Students: 944
  • Male/Female: 491/437
School District
  • BOONE CO
  • 8330 US 42 FLORENCE, KY 41042
  • Phone: 8592831003
District Population
  • Schools: 22
  • Full-Time Teachers: 1152
  • Students per Teacher: 16.1
  • Staff: 2453
  • Students: 18555
CHESTER GOODRIDGE ELEMENTARY SCHOOL 3330 COUGAR PATH HEBRON, KY 41048 Phone: 8593344420 PreK-5th
Grade Size Distribution
  • PreK: 27
  • Knd: 127
  • 1st: 140
  • 2nd: 143
  • 3rd: 142
  • 4th: 149
  • 5th: 152
School Population
  • Teachers: 51
  • Students per Teacher: 17.3
  • Students: 880
  • Male/Female: 425/441
School District
  • BOONE CO
  • 8330 US 42 FLORENCE, KY 41042
  • Phone: 8592831003
District Population
  • Schools: 22
  • Full-Time Teachers: 1152
  • Students per Teacher: 16.1
  • Staff: 2453
  • Students: 18555
NORTH POINTE ELEMENTARY SCHOOL 875 NORTH BEND RD HEBRON, KY 41048 Phone: 8593347000 PreK-5th
Grade Size Distribution
  • PreK: 16
  • Knd: 175
  • 1st: 171
  • 2nd: 171
  • 3rd: 172
  • 4th: 180
  • 5th: 151
School Population
  • Teachers: 52
  • Students per Teacher: 19.9
  • Students: 1036
  • Male/Female: 512/503
School District
  • BOONE CO
  • 8330 US 42 FLORENCE, KY 41042
  • Phone: 8592831003
District Population
  • Schools: 22
  • Full-Time Teachers: 1152
  • Students per Teacher: 16.1
  • Staff: 2453
  • Students: 18555

Private Schools in Zip Code 41048 (Hebron)

* This list of schools may not match the property above.

LITTLE RED SCHOOL HOUSE HEBRON, KY 41048 Phone: 8595861904 K
Grade Size Distribution
  • Knd: 20
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 20

* School data provided by US Department of Education


Information is provided in part by the IDX program of the Northern Kentucky Association of REALTORS® MLS. All information provided is deemed reliable but is not guaranteed and should be independently verified.

* Rates and payment information listed in the mortgage calculator are provided as for general reference only. Specific mortgage information should be verified with a qualified lending professional