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 = 2459 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 2459 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 2459 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;

2106 Wisteria Drive
Hixson, TN 37343
Norma Whaley with Keller Williams Realty, original listing - (423) 664-1600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,300,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3338 Square Feet
Agency: Keller Williams Realty
Agency Phone: (423) 664-1600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1962
Notes: A unique find! A meticulously maintained waterfront home features 3 bedrooms, 3.5 baths, and is strategically situated on 3.03 acres with 360 ft. of water frontage. The property is in a quiet slough within a few feet of the main channel. As you approach the stone entrance and sweeping driveway, the beautifully maintained rolling landscape sets the tone for a lifestyle of relaxation and privacy. Upon entering the covered parking area, you will step into the foyer. To the right, you will find a spacious master en-suite with a tiled shower, air jetted tub, a walk-in closet, and an electric wall fireplace & views of the lake. To the left is a light-filled bedroom with a custom Murphy bed, a walk-in closet, and an adjacent full bath in the hallway. The sleek contemporary gourmet kitchen opens to the living area with panoramic water views. The kitchen has two Wolf ovens, a cooktop, a grill, a Kitchen Aid refrigerator, a Sub-Zero beverage refrigerator, 2 microwaves, (a Wolf & a Meile), a Meile dishwasher, Quartz countertops, a massive granite island that can seat up to ten people, a large pantry, two built-in brews express coffee makers, and a pot filler over the stovetop. The level below the main living area on the ground level features a newly added game/flex room with a half bath, sink, refrigerator, microwave, and closet. The elevator in the main living area provides access to the lower-level media room, an adjoining bedroom with a full bath and stand-up shower, and a private entry from the deck. The media room includes a projector TV, a custom built-in entertainment center, The back of the house impresses with its various decks and screened gazebo that offers serene views of the water and nature. You can take the steps down to the dock or the driveway from the house, for easy access to the lake. Don't forget to stop by the lake storage building to inflate your water toys and collect your fishing gear. The dock has two electric lifts, one for boats up to 38 ft. long, and the second for jet skis and kayaks perfect for large family gatherings and parties. You can enjoy meals, conversations, and relaxation in the screened area on the dock, which includes a refrigerator. The extensive walkway and the dock are covered with maintenance-free Trek decking.<br /> <br /> The sellers were attracted to this property because of the acreage, year-round deep water, and privacy. The home was built in the 1960s, and the owners have renovated it, starting with all electrical and plumbing updates using custom top-quality construction materials and high-end finishes throughout. The only original room of the home is the small utility/safe room in the basement that houses the electrical panel for the main house and generator. Additional features include heated tiled floors in the main living area with individual thermostats, Pella Windows throughout with built-in blinds, motion lights, an irrigation system, a dog run, retaining walls that define space, and a recently built storage area that connects to the other side of the covered parking area. The individual storage rooms (laundry/supply room & the large workshop with a tool area each have individual Mitsubishi mini-split units for heating and cooling. There are three laundry areas, one inside the home and two in the newly built storage area (laundry/supply room and workshop/tool room). The property is conveniently located near shopping, CHI Memorial Hospital, restaurants, I-75, and I-24.
MlsNumber: --
ListingId: 1500732


Listing Provided By: Keller Williams Realty, original listing
Phone: (423) 785-7605
Office Phone: (423) 664-1600
Agent Name: Norma Whaley
Disclaimer: Copyright © 2024 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

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 = 2459 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;
Real Estate Expert Photo for Emily Wiersema
Emily Wiersema
ASCIIColdwell Banker Pryor Realty Inc
Call Today!: (423) 432-3578

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App