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

520 Private Road 5517
Alba, TX 75410
Jackie Carlson with Mayben Realty - Mt. Vernon, original listing - (903) 572-2400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $879,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2250 Square Feet
Agency: Mayben Realty - Mt. Vernon
Agency Phone: (903) 572-2400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: More Pictures will be added tomorrow morning. This breathtaking lakefront home is located in the gated Pension Point community, offering picturesque views of Lake Fork and is surrounded by magnificent trees. To booth the leaseback gives an additional 0.8 acres. A grand brick columns on each side of the driveway greets you as you arrive to this move-in ready residence spans 2,250 sq ft and features three bedrooms and two updated full bathrooms, along with a freshly painted living area with high ceilings. The combined dining and living space is perfect for hosting large gatherings, highlighted by a grand brick fireplace that adds a warm ambiance. The chic kitchen is outfitted with stainless steel appliances and a welcoming eat-in island, while an extra dining nook serves as an ideal spot for games or enjoying your morning coffee. Step outside to the patio area to take in the lake view and the calming sounds of nature. The spacious master bedroom is a perfect sanctuary for curling up with a good book and unwinding after a long day. The en suite features a large walk-in shower, a double sink vanity with a makeup area, and an expansive walk-in closet that includes a safe. Additionally, the property boasts a three-car garage with ample workspace and a fully screened cabana equipped with electrical wiring and TV capabilities. With 200 feet of water frontage, the shoreline features a two-stall boathouse, plus a large deck ideal for fishing or entertaining, and a cleaning sink area, all while showcasing breathtaking views. Spend your evenings by the firepit, enjoying spectacular sunsets. If the charm of lake life is calling you, this home is a must-see!
MlsNumber: --
ListingId: 25005781


Listing Provided By: Mayben Realty - Mt. Vernon, original listing
Phone: (903) 572-2400
Office Phone: (903) 572-2400
Agent Name: Jackie Carlson
Disclaimer: Copyright © 2025 Greater Tyler 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