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

134 At Crumley Rd
Rockford, TN 37853
Mandy Street with Realty Executives Associates, original listing - (865) 983-0011

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,800,000
Beds: 5
Baths: Full: 7, ½: 1
Status: Active
SqFt: 10958 Square Feet
Agency: Realty Executives Associates
Agency Phone: (865) 983-0011

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2002
Notes: The Home with the Million Dollar views-spanning from Walland Gap to Bluff Mountain Ridge! This home draws you in with its impressive stature and inviting front porch, perfect for relaxing in a rocking chair or perfect for a bed swing. This home is fully equipped and ready for all the amazing gatherings and entertaining you have planned. As you enter you are welcomed with natural light, with the entryway offering a direct view through to the family room and those stunning mountain views. The main level has bamboo flooring and 9' ceilings throughout, creating a timeless atmosphere, complemented by upgraded trim work, extra-wide baseboards, and an abundance of glass and French doors. The formal spaces seamlessly blend with the open-concept kitchen and family room, featuring a ventless propane fireplace in the living room. The home is designed with accessibility in mind, featuring no steps on the main floor, including both covered porches, the pool area, the main 2-car garage, and the guest quarters.<br /> The kitchen opens to the family room creating an inviting atmosphere for family and friends to gather, whether around the breakfast bar or watching everyone splash and play around the pool. This kitchen has plenty of cabinet space and a walk-in pantry for additional storage. The cozy breakfast nook, framed by a bay window, provides the ideal spot for casual dining as well as a formal dining room located just off the kitchen. <br /> Step outside to enjoy the AMAZING views. The in-ground pool offers the perfect spot to relax while soaking in the scenic horizon, and the expansive covered porch is designed for effortless entertaining. The pool area boasts a newer diving board and a new pool pump, along with direct access to a convenient half bath. With six and a half bathrooms above grade, plus a basement bathroom, there's no shortage of convenience for all. <br /> The Owners suite and bath, located on the main level, features a luxurious Toto Washlet bidet toilet seat, double vanities, a garden tub, and a separate shower. Your guests will appreciate the privacy offered by the guest quarters, complete with a bathroom featuring a walk-in shower and a small kitchen, including a cooktop, sink, microwave, and full-size refrigerator; or you could use it as a small rental for additional income. <br /> Upstairs you will find an expansive recreation room, filled with natural light and showcasing mountain and pool views, offering yet another space for entertaining OR an additional in-law suite. This room includes a full bath, walk-in closet, and a floor-to-ceiling stacked stone ventless propane fireplace, creating a cozy ambiance. The remaining bedrooms and baths are all located on the second floor and a sweet little sun deck to sit and enjoy the Mountain Views. <br /> The basement offers an impressive 10' ceiling height, and features an exercise area with floor mats, mirrored walls with unbelievable possibilities. A handyman's dream come true!<br /> This expansive home also includes two laundry rooms- one on the main level and one upstairs, a Central Vacuum System, a temperature-controlled storage room, a generator, a BRAND NEW ROOF installed March 2025 with warranty to go to new owners, a newer tankless propane water heater, a newer evaporator main heat pump, a newer 50-gallon electric water heater, and a new water softener tank.<br /> The beautifully landscaped grounds are irrigated with well water, featuring a fully computerized sprinkler system, including a handheld remote for easy control and a dedicated zone for hanging plants. This remarkable home is truly one-of-a-kind, nestled in a serene and stunning location, just minutes from Knoxville Airport and convenient for shopping and dining in both Maryville and Knoxville.
MlsNumber: --
ListingId: 1296192


Listing Provided By: Realty Executives Associates, original listing
Phone: (865) 803-6323
Office Phone: (865) 983-0011
Agent Name: Mandy Street
Disclaimer: Copyright © 2025 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 = 2431 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 Melony Colquitt
Melony Colquitt
ASCIIKeller Williams Realty - Maryville
Call Today!: (865) 384-7937

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App