Water Views - Master on Main
15090 Madison Piner, KY
$ 1,650,000
Property Attributes
  • MLS#520025
  • TypeSingle Family
  • CountyKENTON
  • CityPiner
  • AreaMornV-Piner-Rylan-Vi
  • NeighborhoodPiner
  • Zip41063
  • StyleCape Cod,Ranch
  • Year Built2004
  • Taxes21334
  • Price$ 1,650,000
  • Bedrooms3
  • Full Bathrooms4
  • Half Bathrooms2
  • Lot Size77.05 Acres
Listing Provided Courtesy Of:
Realty Executives Select
Property Description

77+ Acres of Peaceful, Serene Living! Custom 5800 SF Ranch*White Crystalized Canadian Brick*14 Ft. Ceilings*5 Car Garage*Detached 48x96 Garage w. Concrete/Water/Electric (Ultimate Toy Shed!)*Overlooks Stocked Lake/Rolling Fenced Pasture Land*Luxury Owner's Retreat*Expansive Custom Mouser Kitchen w. Large Island/Cook Station*Huge Finished Lower Level w.Custom Bar/2nd Kitchen/Gathering Rm/Full Bath*Massive Windows to Take In the Views*Covered Porch w. Fireplace/Inground Pool*2nd Home w. 2 Bedrm/2 Baths/Filled w.Charm & Character*4 Stall Horse Barn/Loft/Tack Rm*Gorgeous Sunsets! 30 Min to Cinti!

Elementary School Middle School High School
Piner Elementary Twenhofel Middle School Simon Kenton High
Price History
9/13/2018 Listed $1,650,000

General Features

Bathrooms 6
Elementary School Piner Elementary
High School Simon Kenton High
Listing Area MornV/Piner/Rylan/Vi
Middle School Twenhofel Middle School
Miscellaneous 220 Volt, Air Cleaner, Cable TV, Ceiling Fan, Central Vacuum, Fountain, Garage Door Opener, Handicap Use, Home Warranty, Hot Tub/Spa, Humidifier, Pets Allowed, Recess Lights, Security System, Smoke Alarm
New Construction No
Property Condition Yes
Property Sub Type Single Family
School District Kenton County Public
Sic Piner
Sub Type Description Farm Over 10 Acres
Subdivision None - Peaceful Country Setting
Suburb Piner
Virtual Tour Url https://view.paradym.com/showvt.asp?sk=301&t=4263707
Year Built 2004
Zoning Agricultural

Interior Features

Appliances Included Dishwasher, Garbage Disposal, Microwave, Oven/Range, Refrigerator
Basement Features Finished, Walkout, WW Carpet
Basement Type Full
Bedroom 2 Dimensions 13x12
Bedroom 3 Dimensions 13x12
Cooling Central Air
Dining Room Dimensions 16x13
Family Room Dimensions 22x17
Family Room Y/n Yes
Fireplace Gas, Marble, Stone
Formal Dining Rm Y/n Yes
Full Baths 4
Gas Propane
Half Baths 2
Heating Forced Air, Gas
Inside Features 9Ft + Ceiling, Beam Ceiling, French Doors, Great Room, Multi Panel Doors, Natural Woodwork
Kitchen Features Ceramic Tile, Counter Bar, Country, Eat-In, Gourmet, Island, Solid Surface Ctr, Walkout, Wood Cabinets
Laundry 6x12
Living Rm Feat Fireplace, Window Treatments, Wood Floors
Living Room Dimensions 14x12
Master Bedroom Dimensions 20x18
Master Bedroom Features Bath Adjoins, Dressing Area, Fireplace, Walk-in Closet, Walkout, Wall-to-Wall Carpet, Window Treatments
Number of Fireplaces 3
Room Type Basement, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 2, Bedroom 3, Breakfast Room, Dining Room, Entry, Family Room, Game Room, Great Room, Kitchen, Laundry Room, Living Room, Master Bathroom
Total Beds 3
Total Rooms 17
Windows Casement, Insulated, Picture, Wood

Exterior Features

Accessible Transport State Highway
Architecture Cape Cod, Ranch
Buildings Barn, Guest House, Stable, Storage Shed
Exterior Finish Brick
Farm Type Cattle, Crop(Grain, Corn, Soy), Horses, Recreational
Fencing/misc Fencing Total
Foundation Poured
Garage 10
Land Description 50 to 99 Acres
Lot Dimensions 77 acres
Lot Size Area 77.0528
Lot Square Footage 3356419.97
Outside Features Covered Deck/Patio, Patio, Pool In-Ground, Porch, Wood Fence, Wooded Lot
Parking Driveway
Roof Composition, Shingle
Sewer Septic
Structures Cattle Barn, Hay Shed, Horse Barn, Misc Shed, Tractor Barn, Workshop
Topography Cleared, Lake/Pond, Level, Pasture, Rolled, Stream/Creek
Trees Partial Wooded
View Lake/Pond, Valley, Woods
Water Source Public


  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Pets
  • Master On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Zip Code Average in 41063

AVG $610K
AVG $4,126
AVG 89
Year Built
AVG 1985

Looking for more comfortable experience?

Check out our mobile application and browse the properties as no other.