• 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

    $314,000

  • Active | MLS#: 509956
  • 4Beds
  • 4Baths

838 Hancock Court Union, KY 41091

Favorite
Share
Close
Info Visit Search

Overview

OPEN HOUSE SUN OCT 29 12-2 Like new Fischer Whitman Model from the Designer Collection. Many 1st floor additions such as a sunroom and study. 4 bdrms 2 fl, 2 hf baths. Finished basement with plenty of storage. Beautiful stone patio. Extra parking pad in driveway. Great master suite with trey ceiling, on suite bath with shower/tub, walk in closet. Desired Triple Crown Subdivision. Verify Schools.

Listing provided courtesy of: Huff Realty - Ft. Mitchell

General Features

  • Appliances Included Dishwasher, Garbage Disposal, Microwave, Oven/Range, Refrigerator
  • Architecture Traditional
  • Area Richwd/Un/Wal/Ver/SB
  • County Boone
  • Degree Complete Existing Structure
  • Full Bathrooms 2
  • Half Bathrooms 2
  • Hoa 1
  • Tax Rate of record
  • Inc In Hoa Condo Fee Association Dues, Professional Mgt, Tennis
  • Miscellaneous 220 Volt, Cable TV, Ceiling Fan, Garage Door Opener, Recess Lights, Smoke Alarm, Sump Pump
  • New Construction No
  • Property Type Single Family Detached
  • Year Built 2014

Building Features

  • Basement Type Full
  • Cooling Central Air
  • Entry Foyer Closet, Open Foyer, Transom/Sidelit, Wood Floors
  • Entry Level 1
  • Exterior Finish Brick, Vinyl
  • Fireplace Gas
  • Foundation Poured
  • Gas Natural
  • Garage Attached
  • Heating Electric
  • Inside Features 9Ft + Ceiling, Bonus Room, French Doors, Multi Panel Doors
  • Number Fireplaces 1
  • Number Garage Spaces 2
  • Outside Features Patio
  • Roof Shingle
  • Number Rooms 9
  • Windows Insulated, Vinyl/Alum Clad

Room Features

  • Master Bath 1 Type Full
  • Master Bedroom Dim 12X11.3
  • Master Bedroom Level 2
  • Master Bed Feat Bath Adjoins, Walk-in Closet, Wall-to-Wall Carpet
  • Laundry Rm Level 2
  • Living Rm Feat Fireplace, Wall-to-Wall Carpet
  • Living Rm Level 1
  • Living Room Dim 11.1X13.6
  • Master Bath 1 Feat Double Vanity, Shower, Tub
  • Master Bath 1 Lvl 2
  • Bonus Rm Level 1
  • Bonus Room Name Sunroom
  • Family Rm Dim 13.6X11.1
  • Family Rm Feat Wall-to-Wall Carpet
  • Family Rm Level 1
  • Kitchen Dim 15.3X9.5
  • Kitchen Features Eat-In, Island, Pantry, Solid Surface Ctr, Wood Cabinets, Wood Floors
  • Kitchen Level 1
  • Laundry Rm Dim 7X8
  • Bath 2 Lvl 2
  • Bath 2 Type Full
  • Bath 3 Lvl 1
  • Bath 3 Type Partial
  • Bath 4 Lvl Lower
  • Bath 4 Type Partial
  • Bath Lvl 1 Type Partial
  • Bedroom2 Dim 11.6X11.1
  • Bedroom2 Level 2
  • Bedroom3 Dim 12Z11.1
  • Bedroom3 Level 2
  • Bedroom4 Dim 10.9X11.0
  • Bedroom4 Level 2
  • Bonus Rm Dim 12X15

Property Features

  • Land Description Less than .5 Acre
  • Lot Dimensions irr
  • Sewer Public
  • Water Source Public

Schools

  • Elementary School Shirley Mann School
  • JHS Middle School Gray Middle School
  • High School Ryle 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 35 days
  • Average days-on-market for homes between $251,200 - $376,800 = 84 (in zip code 41091)

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 41091 (Union)

Housing Occupancy
  • Home Owners: 7,036 (80%)
  • Renters: 523 (6%)
  • Vacant: 1,264 (14%)
  • Total Housing Units: 8,823
Households
  • Average Household Size: 2.91
  • Housing Density (People per square mile): 427
Age Range (number of people)
  • Age 0-14: 5,187
  • Age 15-24: 3,318
  • Age 25-39: 4,156
  • Age 40-59: 4,707
  • Age 60-79: 3,645
  • Age 80+: 1,016
  • Total: 22,029

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

School Information for 41091 (Union)

Public Schools in Zip Code 41091 (Union)

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

LARRY A. RYLE HIGH SCHOOL 10379 US 42 UNION, KY 41091 Phone: 8593845300 9th-12th
Grade Size Distribution
  • 9th: 406
  • 10th: 414
  • 11th: 354
  • 12th: 374
School Population
  • Teachers: 91
  • Students per Teacher: 17.0
  • Students: 1551
  • Male/Female: 750/785
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
RANDY COOPER HIGH SCHOOL 2855 LONGBRANCH RD UNION, KY 41091 Phone: 8593845040 9th-12th
Grade Size Distribution
  • 9th: 242
  • 10th: 241
  • 11th: 208
  • 12th: 86
School Population
  • Teachers: 46
  • Students per Teacher: 16.9
  • Students: 777
  • Male/Female: 402/360
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
GRAY MIDDLE SCHOOL 10400 US 42 UNION, KY 41091 Phone: 8593845333 6th-8th
Grade Size Distribution
  • 6th: 318
  • 7th: 320
  • 8th: 336
School Population
  • Teachers: 55
  • Students per Teacher: 17.7
  • Students: 974
  • Male/Female: 506/453
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
SHIRLEY MANN ELEMENTARY 10435 US HWY 42 UNION, KY 41091 Phone: 8593845000 K-5th
Grade Size Distribution
  • Knd: 122
  • 1st: 138
  • 2nd: 140
  • 3rd: 140
  • 4th: 157
  • 5th: 143
School Population
  • Teachers: 42
  • Students per Teacher: 20.0
  • Students: 840
  • Male/Female: 412/407
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
NEW HAVEN ELEMENTARY SCHOOL 10854 US 42 UNION, KY 41091 Phone: 8593845325 PreK-5th
Grade Size Distribution
  • PreK: 45
  • Knd: 99
  • 1st: 113
  • 2nd: 114
  • 3rd: 114
  • 4th: 117
  • 5th: 120
School Population
  • Teachers: 46
  • Students per Teacher: 15.7
  • Students: 722
  • Male/Female: 368/346
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

* 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