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

116 Magnolia Ave
South Pittsburg, TN 37380

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $285,000
Beds: 4
Baths: 3
Status: Active
SqFt: 1680
Agency: Berkshire Hathaway HomeServices J Douglas Properti

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: JUST COMPLETED NEW CONSTRUCTION! Welcome to your future home in charming South Pittsburg, TN! This stunning under-construction residence will offer 4 bedrooms and 3 full bathrooms, spanning 1680 square feet on a single level. Discover the convenience of two primary bedrooms with en suite bathrooms, perfect for versatile living arrangements. Step onto the inviting front porch or relax on the spacious back deck, both designed to enhance your outdoor living experience. Admire the upgraded cement fiber siding, combining durability with timeless appeal. Inside, you will be greeted by high end finishes and luxury vinyl plank flooring gracing the main living areas, hallways, and bedrooms. The modern kitchen boasts a gas stove, sleek island, and beautiful granite countertops, creating a perfect hub for dining and social gatherings. Enjoy mountain views while sipping coffee on the back deck. Experience the best of South Pittsburg living with this exceptional property, offering a blend of comfort, style, and functionality. Minutes away from Google Data Center, Sweetens Cove Golf Course, and only 35 minutes to Chattanooga. Don't miss the opportunity to make this your dream home! Special financing is available for this property. The lender will provide a buydown of 1% for one year off current rates for the buyer. The lender will provide specific rates and APRs for your client's particular situation based on their personal qualifications. Ask your agent for more details on this offer today!
MlsNumber: 1381638


Listing Provided By: Berkshire Hathaway HomeServices J Douglas Properti, original listing
Name: Berkshire Hathaway HomeServices J Douglas Properti
Phone: (423) 298-3388
Office Name: Berkshire Hathaway HomeServices J Douglas Pro
Office Phone: (423) 498-5800
Agent Name: Grace Edrington
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App