Robbie Hedger

Sales Associate

  • Listing status icon

    $1,500,000

  • Active | MLS#: 502056
  • 2Beds
  • 5Baths

560 Little Sugar Creek Road Warsaw, KY 41095

Favorite
Share
Close
Info Visit Virtual Tour Search

Listing provided courtesy of: Huff Realty - Florence

Overview

Breathtaking Ohio River Views From Every Room of This Ranch Home*Extremely Private*165 + Acres*Well Equipped Kitchen*Formal DR*Rich Hardwoods*Huge Master Suite with His & Her Full Bath*Guest House w Wet Bar*In-Ground Pool*Barn*Multiple Bldg Locations*Land Can Be Set Up for Cattle, Horses or Crops*Over-sized 4 Car Garage-Rm For 10 Cars*City Water*5 Full BA*Patio*Decks*Porch*Loaded with Wildlife

General Features

  • Appliances Included Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer
  • Architecture Ranch
  • Area Gallatin Cty
  • County Gallatin
  • Degree Complete Existing Structure
  • Full Bathrooms 5
  • Tax Rate Of Record
  • Miscellaneous 220 Volt, Ceiling Fan, Garage Door Opener, Home Warranty, Humidifier, Pets Allowed, Recess Lights, Security System, Smoke Alarm
  • New Construction No
  • Property Type Single Family Detached
  • View Lake/Pond, Park, Valley, Woods

Building Features

  • Basement Feat Concrete Floor, Unfinished
  • Basement Type Full
  • Cooling Central Air
  • Entry Foyer Ceramic Tile, Closet
  • Entry Level 1
  • Exterior Finish Cedar
  • Fireplace Stone, Wood
  • Foundation Poured
  • Garage Detached, Front, Oversized
  • Heating Electric, Heat Pump
  • Inside Features 9Ft + Ceiling, Beam Ceiling, Bonus Room, Cathedral Ceiling, Crown Molding, French Doors, Great Room, Multi Panel Doors, Natural Woodwork
  • Number Fireplaces 1
  • Number Garage Spaces 10
  • Outside Features Deck, Patio, Pool In-Ground, Porch, Wood Fence, Wooded Lot
  • Roof Shingle
  • Number Rooms 9
  • Windows Insulated, Picture

Room Features

  • Master Bath 1 Type Full
  • Master Bedroom Dim 18 x 17
  • Master Bedroom Level 1
  • Master Bed Feat Bath Adjoins, Walkout, Wood Floors
  • Laundry Rm Level Lower
  • Living Rm Feat Fireplace, Walkout, Wood Floors
  • Living Rm Level 1
  • Living Room Dim 25 x 17
  • Master Bath 1 Feat Ceramic Tile, Double Vanity, Marble/Granite/Slate, Shower, Skylight
  • Master Bath 1 Lvl 1
  • Dining Rm Dim 17 x 16
  • Dining Rm Feat Chandelier, Walkout, Wood Floors
  • Dining Rm Level 1
  • Family Rm Dim 24 x 24
  • Family Rm Feat Walkout, Wet Bar
  • Family Rm Level 1
  • Kitchen Dim 24 x 16
  • Kitchen Features Ceramic Tile, Counter Bar, Eat-In, Island, Marble/Granite/Slate, Pantry, Solid Surface Ctr, Walkout, Wood Cabinets
  • Kitchen Level 1
  • Laundry Rm Dim 15 x 15
  • 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 17 x 12
  • Bedroom2 Level 1

Property Features

  • Buildings Barn, Guest House
  • Land Description No Deed Restri, Over 100 Acres
  • Lot Dimensions 165.2469 Ac
  • Sewer Septic
  • Water Source Public

Schools

  • Elementary School Gallatin County Elementary
  • JHS Middle School Gallatin County Middle School
  • High School Gallatin County High
  • School District Gallatin County Publ

Ask a Question

Price & Status History

Days on Market

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

Location

The property map location is: Approximated, identified to the street.

Walk Score

Get the Walk Score Report

Ask A Question

Community Demographics for Zip Code 41095 (Warsaw)

Housing Occupancy
  • Home Owners: 751 (55%)
  • Renters: 303 (22%)
  • Vacant: 310 (23%)
  • Total Housing Units: 1,364
Households
  • Average Household Size: 2.66
  • Housing Density (People per square mile): 98
Age Range (number of people)
  • Age 0-14: 821
  • Age 15-24: 410
  • Age 25-39: 521
  • Age 40-59: 624
  • Age 60-79: 406
  • Age 80+: 67
  • Total: 2,849

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

School Information for 41095 (Warsaw)

Public Schools in Zip Code 41095 (Warsaw)

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

GALLATIN COUNTY HIGH SCHOOL 70 WILDCAT CIRCLECLE WARSAW, KY 41095 Phone: 8595677640 9th-12th
Grade Size Distribution
  • 9th: 134
  • 10th: 115
  • 11th: 92
  • 12th: 94
School Population
  • Teachers: 26
  • Students per Teacher: 16.7
  • Students: 435
  • Male/Female: 220/211
School District
  • GALLATIN COUNTY
  • 600 MAIN ST WARSAW, KY 41095
  • Phone: 8595672828
District Population
  • Schools: 5
  • Full-Time Teachers: 104
  • Students per Teacher: 15.3
  • Staff: 260
  • Students: 1593
GALLATIN COUNTY MIDDLE SCHOOL 88 PAW PRINT PATH WARSAW, KY 41095 Phone: 8595675860 6th-8th
Grade Size Distribution
  • 6th: 117
  • 7th: 110
  • 8th: 131
School Population
  • Teachers: 19
  • Students per Teacher: 18.8
  • Students: 358
  • Male/Female: 189/160
School District
  • GALLATIN COUNTY
  • 600 MAIN ST WARSAW, KY 41095
  • Phone: 8595672828
District Population
  • Schools: 5
  • Full-Time Teachers: 104
  • Students per Teacher: 15.3
  • Staff: 260
  • Students: 1593
GALLATIN COUNTY UPPER ELEMENTARY SCHOOL 50 PAW PRINT PATH WARSAW, KY 41095 Phone: 8595672060 4th-5th
Grade Size Distribution
  • 4th: 113
  • 5th: 127
School Population
  • Teachers: 15
  • Students per Teacher: 16.0
  • Students: 240
  • Male/Female: 116/116
School District
  • GALLATIN COUNTY
  • 600 MAIN ST WARSAW, KY 41095
  • Phone: 8595672828
District Population
  • Schools: 5
  • Full-Time Teachers: 104
  • Students per Teacher: 15.3
  • Staff: 260
  • Students: 1593
GALLATIN CO ALTERNATIVE SCHOOL 605 EAST MAIN ST WARSAW, KY 41095 Phone: 8595677100 K-12th
School Population
  • Teachers: 1
  • Students per Teacher: N/A
  • Students: 0
  • Male/Female: 0/0
School District
  • GALLATIN COUNTY
  • 600 MAIN ST WARSAW, KY 41095
  • Phone: 8595672828
District Population
  • Schools: 5
  • Full-Time Teachers: 104
  • Students per Teacher: 15.3
  • Staff: 260
  • Students: 1593
GALLATIN COUNTY ELEMENTARY SCHOOL 25 BOAZ DR WARSAW, KY 41095 Phone: 8595676342 PreK-3rd
Grade Size Distribution
  • PreK: 61
  • Knd: 138
  • 1st: 120
  • 2nd: 119
  • 3rd: 122
School Population
  • Teachers: 31
  • Students per Teacher: 18.1
  • Students: 560
  • Male/Female: 270/258
School District
  • GALLATIN COUNTY
  • 600 MAIN ST WARSAW, KY 41095
  • Phone: 8595672828
District Population
  • Schools: 5
  • Full-Time Teachers: 104
  • Students per Teacher: 15.3
  • Staff: 260
  • Students: 1593

* 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