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

240 Cedar Ridge Rd.
Longview, TX 75602

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $498,900
Beds: 4
Baths: 4
Status: Active
SqFt: 2784
Agency: Teri Norwood Real Estate Team, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2010
Notes: Owner/agent. Reduced price and BRAND NEW PRIVACY FENCE! This beautiful home on a huge partially wooded lot in a secluded subdivision is a rare find in the Hallsville School district. It features 4 bedrooms, 3 1/2 baths, and a bonus room that could be used as a 5th bedroom. There is plenty of space with a total of 2,784 of living area, an oversized garage, and tons of storage. It has the appeal of a mountain home with moss rock along the front and large cedar trusses on the front porch and back patio. This open concept plan features hand-scraped wood floors, a soaring vaulted ceiling, and an impressive 16 ft. moss rock woodburning fireplace with hearth. The kitchen has GE Profile stainless appliances, custom stained cabinets, granite countertops, pot-filler, pullout trash can, and a dine-in bar. There is a dining area connected to the kitchen as well as a formal dining room (currently serving as an office / bonus space). The downstairs features a split bedroom design with four bedrooms, including a luxurious owner’s suite with two spacious closets, separate sinks, a jetted tub, and large cultured marble shower. The large bonus room upstairs has a full bathroom, wardrobe closet and independent HVAC system so it can easily serve as a bedroom, playroom, office, or hobby room. The utility room has ample cabinets, pullout trash can, and additional fridge space. This home is energy efficiency with foam insulation, a heat pump unit, LED lighting, and programmable thermostat. This home is well-cared for and move-in ready! Also Featuring: Mud bench and hooks at garage entry door Built-in speaker system in living area Garage has LED shop lights & dedicated 240v plug for an electric vehicle or tools Sprinkler System Low HOA fees ($75/yr) Fenced back yard Partially wooded lot - 0.67 Acre Outdoor stone fireplace Built 2010 New roof 10/2019 New upstairs AC Unit 03/2020 New septic water pump in 07/2021 New septic aerobic air pump, 03/2023 New exterior paint, French drain, and other updates in 2022 Owner will provide a One Year 3rd Party Warranty
MlsNumber: 20233654


Listing Provided By: Teri Norwood Real Estate Team, LLC, original listing
Name: Teri Norwood Real Estate Team, LLC
Phone: (903) 212-8326
Office Name: Teri Norwood Real Estate Team LLC
Office Phone: (903) 212-8326
Agent Name: Lara Coffey
Disclaimer: Copyright © 2024 Longview Area 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 = 2613 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 Carrie Shuttlesworth
Carrie Shuttlesworth
ASCIIKeebaugh & Company
Call Today!: (903) 736-5761

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App