Title Page Background
DEBUG FN args: Array ( [0] => 2487 [1] => [2] => [3] => agent ) BEFORE: Site: 2487 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2487 Igate: njhud LocID: 2487 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2487 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2487 [1] => [2] => [3] => lender ) BEFORE: Site: 2487 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2487 Igate: njhud LocID: 2487 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2487 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2487 [1] => [2] => [3] => other ) BEFORE: Site: 2487 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2487 Igate: njhud LocID: 2487 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2487 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back | All Foreclosures | | | All Cities

362 Windmill Lane
Georgetown, TN 37336
Mollie Majors with Crye-Leike REALTORS, original listing - (423) 238-5440
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $1,200,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3465 Square Feet
Agency: Crye-Leike REALTORS
Agency Phone: (423) 238-5440

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Coming Soon Listing-Showings Begin Wednesday, May 21st. Looking for a meticulously maintained home with gorgeous views of the Hiwassee River? This conveniently located, custom built waterfront home is located just off Highway 58 in Georgetown, TN. From the moment you arrive, you'll see how tranquil living on the river can be. As you walk through the front door, you have water views & they can be seen from almost every room in the home. The main floor features a formal dining room, great room with propane gas fireplace flanked by built ins, a breakfast area, kitchen with granite counter tops, and stainless appliances. The primary suite is also located on the main floor & boasts a tile shower, jetted tub, granite counters and huge walk-in closet. The sellers added a terrific sunroom with heated floors & custom blinds so that you can enjoy the views all year long! You'll also find plantation shutters throughout the property.The main floor also has a laundry room as well as a half bath. You'll find hardwood & tile flooring throughout the main floor. Upstairs you will find 2 bedrooms and a full bath plus a finished bonus room with storage galore. In the daylight-walkout basement, you have a spacious family room with wet bar, eat-in area plus a second propane gas fireplace which is also flanked by built ins. There is also a full bath that is convenient to the pool. You also have two unfinished areas for all your storage needs in addition to the Utility garage that you could pull jet skis or a small boat into. The outside of this home is as pristine as the interior with its sodded yard, which is irrigated by the river, an in-ground saltwater pool, beautiful landscaping with lots of color, porcelain tile patio, a grilling deck as well as a private deck off the primary suite which were just upgraded to TREX decking. A stone path leads you down to the new covered dock (2023) with a powered 8,000-pound boat lift & a separate 8,000-pound powered jet ski lift plus water & electricity! Being located on summer water, makes for easy dock maintenance when the time comes. This is a home that can be enjoyed for generations to come . . . it's truly one you will want to see for yourself!
MlsNumber: --
ListingId: 1513092


Listing Provided By: Crye-Leike REALTORS, original listing
Phone: (423) 544-1527
Office Phone: (423) 238-5440
Agent Name: Mollie Majors
Disclaimer: Copyright © 2025 Greater Chattanooga 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => meigs [3] => TN [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: meigs State: TN Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: meigs State: TN Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2487 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Butch Boyd
Butch Boyd
ASCIIHero Homes Group
Call Today!: (904) 742-1419

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App