• 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

    $449,000

  • Pending | MLS#: 506523
  • 2Beds
  • 3Baths

905 Welshire Villa Hills, KY 41017

Favorite
Share
Close
Info Visit Virtual Tour Search

Overview

Step free living in this beautiful all brick landominium in this premier community of Squire Valley.Gorgeous white oak hardwd/crown molding/gas fp/formal dining rm/2 bed/2 bath w/bonus rm which could be an extension of kitchen or a den/study. Pella windows/skylight,central vac.Master has adjoining bath w/2 walk-in closets & shoe closet.Patio w/retractable awning/whole house generator.New roof 2016

Listing provided courtesy of: Huff Realty - Ft. Mitchell

General Features

  • Appliances Included Dishwasher, Dryer, Garbage Disposal, Oven/Range, Refrigerator, Washer
  • Architecture Traditional
  • Area Cres.Sprn/Ft Wrght/P
  • County Kenton
  • Degree Complete Existing Structure
  • Full Bathrooms 2
  • Half Bathrooms 1
  • Hoa 1
  • HOA Fee 1 250
  • Tax Rate 13.44
  • HOA Frequency 1 Monthly
  • Inc In Hoa Condo Fee Association Dues, Clubhouse, Landscaping, Pool, Professional Mgt, Snow Removal, Tennis, Walking Trails
  • Miscellaneous 220 Volt, Air Cleaner, Cable TV, Ceiling Fan, Central Vacuum, Garage Door Opener, Home Warranty, Humidifier, Recess Lights, Security System, Smoke Alarm, Sump Pump
  • New Construction No
  • Property Type Single Family Detached
  • Subdivision Squire Valley Landominiums
  • Year Built 1997

Building Features

  • Basement Feat Unfinished
  • Basement Type Full
  • Cooling Central Air
  • Entry Foyer Wood Floors
  • Entry Level 1
  • Exterior Finish Brick
  • Fireplace Gas
  • Foundation Poured
  • Gas Natural
  • Garage Attached
  • Heating Forced Air, Gas
  • Inside Features 9Ft + Ceiling, Crown Molding, Multi Panel Doors, Recess Ceiling
  • Number Fireplaces 1
  • Number Garage Spaces 2
  • Outside Features Covered Deck/Patio, Patio
  • Roof Shingle
  • Number Rooms 7
  • Windows Wood

Room Features

  • Master Bath 1 Type Full
  • Master Bedroom Dim 13x15
  • Master Bedroom Level 1
  • Master Bed Feat Skylight, Walk-in Closet, Wood Floors
  • Laundry Rm Level 1
  • Living Rm Feat Bookcase, Wood Floors
  • Living Rm Level 1
  • Living Room Dim 25x16
  • Master Bath 1 Feat Ceramic Tile, Double Vanity, Shower, Skylight
  • Master Bath 1 Lvl 1
  • Breakfast Rm Dim 12x15
  • Breakfast Rm Level 1
  • Dining Rm Dim 13x13
  • Dining Rm Feat Wood Floors
  • Dining Rm Level 1
  • Kitchen Dim 14x10
  • Kitchen Features Counter Bar, Eat-In, Solid Surface Ctr, Walkout, Wood Cabinets, Wood Floors
  • Kitchen Level 1
  • Laundry Rm Dim 7x5
  • Bath 2 Lvl 1
  • Bath 2 Type Full
  • Bath 3 Lvl 1
  • Bath 3 Type Partial
  • Bath Lvl 1 Type Full
  • Bedroom on Level 1 1
  • Bedroom2 Dim 12x11
  • Bedroom2 Level 1

Property Features

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

Schools

  • Elementary School River Ridge Elementary
  • JHS Middle School Turkey Foot Middle School
  • High School Dixie Heights High
  • School District Kenton 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 140 days
  • Average days-on-market for homes between $359,200 - $538,800 = 117 (in zip code 41017)

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 41017 (Villa Hills)

Housing Occupancy
  • Home Owners: 13,009 (64%)
  • Renters: 4,355 (22%)
  • Vacant: 2,880 (14%)
  • Total Housing Units: 20,244
Households
  • Average Household Size: 2.51
  • Housing Density (People per square mile): 2,101
Age Range (number of people)
  • Age 0-14: 10,006
  • Age 15-24: 5,801
  • Age 25-39: 8,054
  • Age 40-59: 10,336
  • Age 60-79: 7,985
  • Age 80+: 1,824
  • Total: 44,006

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

School Information for 41017 (Villa Hills)

Public Schools in Zip Code 41017 (Villa Hills)

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

DIXIE HEIGHTS HIGH SCHOOL 3010 DIXIE HWY FORT MITCHELL, KY 41017 Phone: 8593417650 9th-12th
Grade Size Distribution
  • 9th: 403
  • 10th: 365
  • 11th: 319
  • 12th: 265
School Population
  • Teachers: 66
  • Students per Teacher: 20.5
  • Students: 1354
  • Male/Female: 688/641
School District
  • KENTON COUNTY
  • 20 KENTON LANDS ERLANGER, KY 41018
  • Phone: 8593448888
District Population
  • Schools: 25
  • Full-Time Teachers: 792
  • Students per Teacher: 17.6
  • Staff: 1724
  • Students: 13895
JAMES D PATTON AREA TECHNOLOGY CENTER 3234 TURKEY FOOT RD FORT MITCHELL, KY 41017 Phone: 8593412266 9th-12th
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 0
  • Male/Female: 0/0
School District
  • KENTON COUNTY
  • 20 KENTON LANDS ERLANGER, KY 41018
  • Phone: 8593448888
District Population
  • Schools: 25
  • Full-Time Teachers: 792
  • Students per Teacher: 17.6
  • Staff: 1724
  • Students: 13895
NORTHERN KY HEALTH TECHNOLOGY CENTER 790 THOMAS MOORE PARKWAY EDGEWOOD, KY 41017 Phone: 8593415200 9th-12th
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 0
  • Male/Female: 0/0
School District
  • KENTON COUNTY
  • 20 KENTON LANDS ERLANGER, KY 41018
  • Phone: 8593448888
District Population
  • Schools: 25
  • Full-Time Teachers: 792
  • Students per Teacher: 17.6
  • Staff: 1724
  • Students: 13895
BEECHWOOD HIGH SCHOOL 54 BEECHWOOD RD FORT MITCHELL, KY 41017 Phone: 8593311220 7th-12th
Grade Size Distribution
  • 7th: 89
  • 8th: 93
  • 9th: 94
  • 10th: 82
  • 11th: 76
  • 12th: 74
School Population
  • Teachers: 36
  • Students per Teacher: 14.1
  • Students: 508
  • Male/Female: 283/222
School District
  • BEECHWOOD IND
  • 50 BEECHWOOD RD FORT MITCHELL, KY 41017
  • Phone: 8593313250
District Population
  • Schools: 2
  • Full-Time Teachers: 73
  • Students per Teacher: 14.9
  • Staff: 134
  • Students: 1084
TURKEY FOOT MIDDLE SCHOOL 3230 TURKEYFOOT RD EDGEWOOD, KY 41017 Phone: 8593410216 6th-8th
Grade Size Distribution
  • 6th: 284
  • 7th: 246
  • 8th: 258
School Population
  • Teachers: 47
  • Students per Teacher: 16.8
  • Students: 788
  • Male/Female: 385/378
School District
  • KENTON COUNTY
  • 20 KENTON LANDS ERLANGER, KY 41018
  • Phone: 8593448888
District Population
  • Schools: 25
  • Full-Time Teachers: 792
  • Students per Teacher: 17.6
  • Staff: 1724
  • Students: 13895
BEECHWOOD ELEMENTARY SCHOOL 54 BEECHWOOD RD FORT MITCHELL, KY 41017 Phone: 8593311220 K-6th
Grade Size Distribution
  • Knd: 66
  • 1st: 81
  • 2nd: 82
  • 3rd: 83
  • 4th: 88
  • 5th: 89
  • 6th: 87
School Population
  • Teachers: 37
  • Students per Teacher: 15.6
  • Students: 576
  • Male/Female: 279/295
School District
  • BEECHWOOD IND
  • 50 BEECHWOOD RD FORT MITCHELL, KY 41017
  • Phone: 8593313250
District Population
  • Schools: 2
  • Full-Time Teachers: 73
  • Students per Teacher: 14.9
  • Staff: 134
  • Students: 1084
R C HINSDALE ELEMENTARY SCHOOL 440 DUDLEY RD EDGEWOOD, KY 41017 Phone: 8593418226 K-5th
Grade Size Distribution
  • Knd: 109
  • 1st: 118
  • 2nd: 118
  • 3rd: 119
  • 4th: 127
  • 5th: 104
School Population
  • Teachers: 37
  • Students per Teacher: 18.8
  • Students: 695
  • Male/Female: 344/328
School District
  • KENTON COUNTY
  • 20 KENTON LANDS ERLANGER, KY 41018
  • Phone: 8593448888
District Population
  • Schools: 25
  • Full-Time Teachers: 792
  • Students per Teacher: 17.6
  • Staff: 1724
  • Students: 13895
JAMES A CAYWOOD ELEMENTARY SCHOOL 3300 TURKEYFOOT RD EDGEWOOD, KY 41017 Phone: 8593417062 PreK-5th
Grade Size Distribution
  • PreK: 47
  • Knd: 110
  • 1st: 101
  • 2nd: 103
  • 3rd: 104
  • 4th: 98
  • 5th: 76
School Population
  • Teachers: 34
  • Students per Teacher: 18.8
  • Students: 639
  • Male/Female: 335/294
School District
  • KENTON COUNTY
  • 20 KENTON LANDS ERLANGER, KY 41018
  • Phone: 8593448888
District Population
  • Schools: 25
  • Full-Time Teachers: 792
  • Students per Teacher: 17.6
  • Staff: 1724
  • Students: 13895
RIVER RIDGE ELEMENTARY SCHOOL 2772 AMSTERDAM RD VILLA HILLS, KY 41017 Phone: 8593415260 PreK-5th
Grade Size Distribution
  • PreK: 79
  • Knd: 134
  • 1st: 146
  • 2nd: 144
  • 3rd: 144
  • 4th: 153
  • 5th: 123
School Population
  • Teachers: 60
  • Students per Teacher: 15.4
  • Students: 923
  • Male/Female: 484/407
School District
  • KENTON COUNTY
  • 20 KENTON LANDS ERLANGER, KY 41018
  • Phone: 8593448888
District Population
  • Schools: 25
  • Full-Time Teachers: 792
  • Students per Teacher: 17.6
  • Staff: 1724
  • Students: 13895
NORTHERN KY TECH - EDGEWOOD 790 THOMAS MORE PKWY EDGEWOOD, KY 41017 Phone: 8593415200
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 0
  • Male/Female: 0/0
School District
  • KENTON COUNTY
  • 20 KENTON LANDS ERLANGER, KY 41018
  • Phone: 8593448888
District Population
  • Schools: 25
  • Full-Time Teachers: 792
  • Students per Teacher: 17.6
  • Staff: 1724
  • Students: 13895

Private Schools in Zip Code 41017 (Villa Hills)

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

VILLA MADONNA SCHOOL 2500 Amsterdam Rd Villa Hills, KY 41017 Phone: 8593316333 1st-12th
Grade Size Distribution
  • 1st: 36
  • 2nd: 33
  • 3rd: 26
  • 4th: 31
  • 5th: 47
  • 6th: 33
  • 7th: 31
  • 8th: 23
  • 9th: 44
  • 10th: 52
  • 11th: 32
  • 12th: 39
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 427
BLESSED SACRAMENT ELEM. SCHOOL 2407 Dixie Hwy Covington, KY 41017 Phone: 8593313062 K-8th
Grade Size Distribution
  • Knd: 50
  • 1st: 75
  • 2nd: 74
  • 3rd: 68
  • 4th: 71
  • 5th: 67
  • 6th: 74
  • 7th: 68
  • 8th: 63
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 610
LITTLE RED SCHOOL HOUSE III 805 BUTTERMILK PIKE Crescent Spg, KY 41017 Phone: 8593440278 K
Grade Size Distribution
  • Knd: 20
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 20
ST. JOSEPH 2474 Lorraine Ct Covington, KY 41017 Phone: 8595782742 K-8th
Grade Size Distribution
  • Knd: 42
  • 1st: 73
  • 2nd: 60
  • 3rd: 54
  • 4th: 63
  • 5th: 61
  • 6th: 68
  • 7th: 85
  • 8th: 56
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 562
GODDARD SCHOOL (THE) FORT MITCHELL, KY 41017 Phone: 8593318400 PreK-K
Grade Size Distribution
  • PreK: 22
  • Knd: 5
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 27
LAKESIDE PRESBYTERIAN CHURCH K 2690 DIXIE HIGHWAY Fort Mitchell, KY 41017 Phone: 8593411124 PreK-K
Grade Size Distribution
  • PreK: 120
  • Knd: 18
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 138
NORTHERN KY MONTESSORI CENTER 232 BEECHWOOD ROAD Fort Mitchell, KY 41017 Phone: 8593313725 PreK-K
Grade Size Distribution
  • PreK: 34
  • Knd: 20
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 54
ST. PIUS X ELEMENTARY SCHOOL 348 Dudley Pike Covington, KY 41017 Phone: 8593414900 PreK-8th
Grade Size Distribution
  • PreK: 47
  • 1st: 69
  • 2nd: 81
  • 3rd: 80
  • 4th: 78
  • 5th: 80
  • 6th: 81
  • 7th: 67
  • 8th: 84
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 667
THE GODDARD SCHOOL CRESTVIEW HILLS, KY 41017 Phone: 8595789855 PreK-K
Grade Size Distribution
  • PreK: 90
  • Knd: 8
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 98
VILLA MADONNA MONTESSORI 2402 AMSTERDAM RD Villa Hills, KY 41017 Phone: 8593415145 PreK-K
Grade Size Distribution
  • PreK: 39
  • Knd: 14
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 53
GUARDIAN ANGEL SCHOOL 75 ORPHANAGE RD Fort Mitchell, KY 41017 Phone: 8593312040
Grade Size Distribution
  • Ungrd: 21
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 21

* 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