A PHP Error was encountered

Severity: Warning

Message: fopen(/home/danielse/public_html/system/cache/ci_sessione23424502953412c306425235057a0949ab52d76): failed to open stream: Disk quota exceeded

Filename: drivers/Session_files_driver.php

Line Number: 172

Backtrace:

File: /home/danielse/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: session_start(): Failed to read session data: user (path: /home/danielse/public_html/system/cache)

Filename: Session/Session.php

Line Number: 143

Backtrace:

File: /home/danielse/public_html/index.php
Line: 315
Function: require_once

Daniel Parker - Listings

BJ Can Help You Purchase This Home

Thank you for choosing Daniel Parker! As one of the Knoxville area's premier Real Estate Brokers, I am uniquely qualified to help you find your dream home. On the lake, around town or out on a farm. Remember, BJ is here to help!

248 Sesame St, Lenoir City, 37772

Priced At: $724,900

Property Details for ID: 1330076



SqFt: 2,215
Price SqFt: $327
Total Bedrooms: 4
Full Baths: 3 / Half Baths: 0
MLS Status: Active
Property Type: Residential
On Market Date: 2026-02-24T08:15:27Z
Subdivision: Farmstead Sd Ph 1

Public Remarks: CAN YOU TELL ME HOW TO GET TO SESAME STREET? RIGHT HERE- YOUR'RE GOING TO LOVE CALLING IT HOME! Just minutes from the lake, downtown Lenoir City and Farragut! This gorgeous Main Level Living plan truly has it all! The charming exterior leads to an open floor plan with THREE bedrooms and TWO full baths on the main. Not just a great floor plan - this house is full of features! 10 foot ceilings and 8ft doors on the main level help to accentuate the bright interior. The kitchen, complete with ivory colored cabinets is sure to be a show stopper! Not only gorgeous but functional, the kitchen features a generous pantry and a great Island for all. The upstairs has a great bonus room, full bathroom, FOURTH bedroom along with TONS of walk in storage! The rear has a great covered patio for entertaining.

Schools Information

Elementary School: Highland Park
Middle / Junior School: North
High School: Loudon

Building Description

Building Style: Craftsman, Traditional
Type: 1 1/2 Story
Site Built: Yes
Year Built: 2024
Total Rooms: 8
SqFt (Total): 2,215
SqFt (Main Lvl): 1,596
SqFt (2nd Flr Lvl): 619
Full Baths: 3
1/2 Baths: 0
Fireplace: Yes
Bonus Room: Yes
Extra Storage: Yes
Basement: No
Basement Type: Slab

  Exterior Features

Features: Patio, Porch - Covered, Prof Landscaped, Windows - Insulated, Windows - Vinyl
Construction: Frame
Siding: Brick, Fiber Cement

  Appliances

Dishwasher, Disposal, Gas Range, Microwave, Range, Refrigerator, Self Cleaning Oven, Smoke Detector, Tankless Wtr Htr

  Room Dimensions

Master Bedroom: Bedroom 2: Bedroom 3: Bonus Room:

  Interior Features

Dining Area: Living RmDining Rm
Floors: Carpet, Laminate, Tile
Other Rooms: Bedroom Main Level, Extra Storage, Family Room, LaundryUtility, Mstr Bdrm Main Level
Misc Features: Island in Kitchen, Pantry, Walk-in Shower, Walk-in Closets, WasherDryer Connect, Wired for Internet

  Property Details

Acreages: 0.34
Lot Description: Level
View: Other

Utilities

Fuel Types: Gas (Natural)

Financing

Finance Options: Cash, Conventional, FHA, VA Loan

  HOA Information

Restrictions: Yes
HOA: Mandatory
HOA Fee: 33
HOA Freq: Monthly
HOA Contact: HPC Management

Heating & Cooling

Fireplace(s): Yes
Total Fireplaces: 1
Fireplace Type(s): Gas Log, Insert, Gas
Cooling Type(s): Ceiling Fan(s), Central Cooling
Heat Type(s): Heat Pump

Garage / Parking

Garage Spaces, Attached, Garage Door Opener, Main Level

  Community Features

Architect Restricted, Sidewalks

Outbuildings

Presented By: / Woody Creek Realty, LLC

Up Coming Open Houses

Sorry, no open houses are currently available for this listing.

Directions

Traveling West on Northshore drive until you dead end into Beals Chapel. Turn Left and neighborhood directly on Right. Take 1st left onto Clover circle and home in cul de sac. OR travel West on Kingston Pike, turn Left onto HWY11 at Dixie Lee Junction, Turn Left at Muddy Creek, Turn Left onto Martel which turns into Beals Chapel, Turn Right into Farmstead, turn Left onto Poppy Place, left on Sesame Street. House is on the right.



Your commute

( Departing today at 8:00am )
—
—
—
—


Near By Properties (click flag to view)

Listing Id: (Click to View)
List Price:
Full Baths:
Half Baths:
Total Beds:
Total SqFt:
Address:
Public Remarks:


Mortgage Calculator

Loan Amount (80% of list price)

$

Term (in years)?

What will be the interest rate?

%
Instructions: Enter numbers and decimal points. No commas or other characters.


This is your Principal & Interest Payment only - you will still have to add HomeOwners Insurance and Taxes for a Total Monthly Payment.  The Loan Amount Figure is based on a 20% down payment, Private Mortgage Insurance (PMI) is required with less than a 20% down payment.  I can provide you with names of Mortgage Loan Officers that will provide you more details on your payment and total down payment requirements.

Four Reasons to Use Daniel Parker

Buying or Selling real estate should be fun and simple. With me, that's exactly what you can expect. I will strive to make each and every interaction a professional and pleasant experience!

Quick Sale

Our network of qualified purchasers combined with dedication and hard work; help ensure that no one will work harder to get your home property sold.

You Are Valued

I recognize that we are partners with our clients and as such, I strive to provide a high quality of service, and hope to build trust and friendships through honesty and integrity.

Knowledge Beyond Sales

From across town to across the country I have the expertise and knowledge to help with any real estate issue.

Professional

I Believe that everyone should be treated with the upmost of respect and professionalism combined with the highest level of service.



Realty Executives Associates is a licensed Tennessee Real Estate Firm. Firm License #213347. Some or all of the Listing Displayed on this Site may not belong to Realty Executives Associates. The data relating to real estate for sale on this website is being provided for the consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the consumers may be interested in purchasing. This information is updated daily, however, some of these properties may subsequently have sold and may no longer be available. Information provided is thought to be reliable but is not guaranteed to be accurate; you are advised to verify facts that are important to you. No warranties, expressed or implied, are provided for the data herein, or for their use or interpretation by the user.