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

1987 County Road (cr) 1596
Avinger, TX 75630
Jessica Waldron with Summers Cook & Company, original listing - (903) 736-3946

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $679,800
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2472 Square Feet
Agency: Summers Cook & Company
Agency Phone: (903) 736-3946

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: WATERFRONT TURNKEY LUXURY AWAITS...Welcome to your dream lakefront retreat nestled in the planned, private-lake community of Eagle Landing in northeast Texas, which offers a 4000' landing strip for use by its residents. Designed with serenity in mind, this meticulously maintained home boasts a myriad of updates and modern conveniences to ensure comfort and luxury living. Originally constructed by a brick layer, this home features a seamlessly updated interior freshly painted throughout, including trim and cabinets. In addition to spacious bedrooms, each complete with his and hers closets, transformed bathrooms await, with updated plumbing, new fixtures, sleek tiled rain showers, and quartz countertops. Attention to detail is evident with all-new door hardware, hinges, cabinet pulls, and drawer pulls. The eat-in kitchen and formal dining room provide ample space for entertaining, or the dining room could alternately accommodate a pool table for added entertainment. All interior windows feature new window treatments and new transitions tinting finish, and the screened-in back porch offers the perfect setting to enjoy the lake views on warm summer nights. Updates extend beyond the interior with a new roof, new gutters with leaf-guards, and new fascia and soffits ensuring durability and curb appeal. New exterior paint, along with a freshly painted retaining wall, patio, stairs, and lakeside deck further enhance the home's exterior charm.The two 2-car garages offer ample space for vehicles and storage, with newly finished commercial-grade epoxy floors and a convenient 20amp EV plug installed in the primary garage. The wood-burning stove, half bath, and workbench areas in one garage create a versatile space that could be transformed into the ultimate work area or play space. Outside, enjoy the tranquil lakeside setting with a newly painted boat dock equipped with fresh bumpers and cleats and new solar-powered lighting illuminating the pathway to the lake and boat dock. Two new lakeside decks offer the perfect spot to soak in the stunning views, and a newly constructed fire pit area invites cozy evenings by the water's edge. Landscape maintenance is a breeze with tumbled river rock beds along the front and rear of the house, complemented by a new rock walkway leading to the lake. New HVAC, water heater, smoke detectors, and all new kitchen appliances offer added peace of mind. For those seeking the ultimate turnkey experience, this home is available fully furnished, with the added option to acquire a boat with minimal usage. Don't miss your chance to experience lakefront living at its finest in this stunning, updated retreat, and learn more about the community at eaglelanding.org. Schedule your private tour today!
MlsNumber: --
ListingId: 20241630


Listing Provided By: Summers Cook & Company, original listing
Phone: (903) 736-3946
Office Phone: (903) 736-3946
Agent Name: Jessica Waldron
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 = 2555 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 KAREN HAMMONDS
KAREN HAMMONDS
ASCIINEXTHOME Realty Advisors
Call Today!: (903) 293-2020

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App