Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1011 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1011 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1011 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

198 Mills Campsite Lane
Hudson, KY 40145
Dottie Watson with REAL DEAL REALTY LLC, original listing - (270) 257-8818

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $325,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1792 Square Feet
Agency: REAL DEAL REALTY LLC
Agency Phone: (270) 257-8818

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Just shy of 2 acres, if you want a BIG home in a lake community this may be the home for you! The Sellers have some high end projects underway in this 1792 sq' home already under roof. Dual Fuel HVAC is installed. The home owners even put a security system in that would be so useful if you travel. The great room is massive and there are plenty of electrical plugs throughout the house but ESPECIALLY on what will be the bar area. This is one of those homes YOU MUST experience as the pictures can't do it justice of an unfinished home. Are you handy with carpentry? A great project to keep you excited through the boring winter months. Come spring you will have a great house and be set to enjoy Rough River Lake! The drywall and cabinets are hung. No counter top yet. There is a nice stainless farm sink installed. The dishwasher has been delivered and is boxed up. Here are a few things the owner wanted you to know:• Built in June 2022; • 200-amp electric service • Metal roof and metal siding • 8ft x 32ft covered front porch • House is wired with 24/7 surveillance all-round the house. • Vermont Casting top loading wood burning stove o 72-inch ceiling fan with light o Can less lighting • All doors except one are 36-inch openings (handicap accessible) • Dual fuel heat pump and AC • Large kitchen with a spacious dining room o 72-inch ceiling fan with light o Gorgeous cabinets and light fixtures o Stainless Steel 5 burner gas cooktop o Space for a double oven (not present) o Stainless Steel dishwasher-in box/ not installed. o Stainless Steel farmhouse sink-installed o Stainless Steel microwave • Primary Suite: o Large Bedroom with 2 Walkin closets that are cedar lined o 72-inch ceiling fan with light o HUGE 4ft x 6ft tile ready shower (have shower faucets) o Soaking tub with a view • Guest Bathroom: o Tub with glass doors (have shower faucets) • Guest rooms: o Lights in closets o Ceiling fans with lights REMAINING ITEMS TO COMPLETE HOME: • Flooring and trim through out o LVP onsite if owners want it for bathrooms and laundry room • Vanities • Toilets • Tile work in Master bath • Countertop for kitchen • Railing for front porch At the asking price, the home works out to be $181. per square foot. This does not include the new metal Barn: 30' x 50' with 16-foot eves, 2- 12' lean-to on each side. PVA shows 1.85 acres. There is a block building a tree fell on that needs to be removed from the property.
MlsNumber: --
ListingId: HK24003572


Listing Provided By: REAL DEAL REALTY LLC, original listing
Phone: (270) 668-3731
Office Phone: (270) 257-8818
Agent Name: Dottie Watson
Disclaimer: Copyright © 2024 Heart of Kentucky Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1011 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App