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 = 2427 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 = 2427 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 = 2427 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;

133 E Westcott Overlook
Oak Ridge, TN 37830

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $635,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2295 Square Feet
Agency: Alliance Sotheby's International Realty
Agency Phone: (865) 357-3232

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2024
Notes: Luxury living at an attainable price!! 3 bed, 2.5 bathroom and 2 separate garages!!! As you step into the grand foyer with soaring 13-foot ceilings, you'll be immediately captivated by the abundance of natural light pouring in from the expansive windows and high ceilings. This stunning two-story walkout home offers the perfect blend of modern elegance and functional living, featuring a main floor master suite and convenient laundry room with direct access to the master closet.<br /> <br /> <br /> With 10-foot ceilings and 8-foot doors on the main level, the home feels open and airy throughout. The gourmet kitchen is a chef's dream, offering a large island, GE Profile appliances, a gas stove, hidden pantry, soft-close wood cabinets, dovetail drawers and pot filler, making cooking both stylish and functional.<br /> <br /> <br /> Designer touches are found throughout the home, from trey ceilings, to 5¼ inch baseboards, a dramatic tiled floor-to-ceiling fireplace, custom wood shelving in all closets, and 4-way wrap designer window trim on the main floor. The premium bathrooms provide a true spa-like experience. The master suite features a custom tiled shower with frameless glass doors, dual vanities with designer-framed mirrors, and a freestanding soaking tub.<br /> <br /> <br /> This home is equipped with smart technology for added convenience and comfort. The tankless gas water heater ensures the luxury of unlimited hot water. With 3 bedrooms, 2.5 bathrooms and 4 garage spaces, this home is designed to provide both sophistication and comfort, making it the ideal choice for those seeking modern living with high-end finishes.<br /> <br /> <br /> Groves Park is a beautiful neighborhood in the heart of Oak Ridge within a highly rated school district (in 2024 the elementary school received the national blue ribbon award). With its tree lined streets, charming details, and future planned premium amenities, it's the perfect place to call home. For more information, please visit www.GrovesPark.com<br /> <br /> <br /> New Construction - Home built by River Oak Development, LLC <br /> <br /> <br /> CONSTRUCTION TO BE COMPLETE WITHIN 1 MONTHS TIME <br /> <br /> <br /> *The current taxes reflect the land value and will be reassessed and updated upon the sale of the home
MlsNumber: --
ListingId: 1279362


Listing Provided By: Alliance Sotheby's International Realty, original listing
Phone: (305) 606-1178
Office Phone: (865) 357-3232
Agent Name: Orel Brodt
Disclaimer: Copyright © 2024 East Tennessee 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 = 2427 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 Don and Vivienne Rolfe
Don and Vivienne Rolfe
ASCIIRE/MAX Preferred Properties, Inc
Vivienne: (865) 505-1776
Don: (865) 346-8657

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App