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

1830 Us-77
Lott, TX 76656
Theresa Schrimsher with Texas Star Realty, original listing - (254) 721-5116

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,036,000
Beds: 1
Baths: Full: 1
Status: Active
SqFt: --
Agency: Texas Star Realty
Agency Phone: (254) 721-5116

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 56 acre(s)
Property Type: Other-Apartment
Year Built: --
Notes: This property is a chance of a lifetime! 55+ acres AG Exempt of dreamland located in Lott, Texas on State Hwy 77. This property has no restrictions and commercial possibilities! Fully fenced, the land can be used to cultivate coastal hay or to raise cattle. The possibilities are endless! This acreage features beautiful pecan, fig and live oak trees and has THREE stock tanks/ponds! And we haven't talked about all the great buildings this property has yet...there is a HUGE 60x36, 3040 sf metal building with 3 rolling doors and ample parking for RVs to include a covered parking. Includes a 1 bed/1 bath apartment with new water heater and faucets as well as a small kitchenette with washer & dryer connections in 2 story metal barn/workshop. A 2 bed/1 bath 1400 sf fixer-upper house with no electrical & plumbing that can be made into your Dream Home! This quaint cottagey farm home has hardwood flooring and bead board ceilings and with Your vision can be Gorgeous! The Metal Barn/Workshop and house are on 1 AC. <br /> This unbelievable property is conveniently located between Temple and Waco and is in the sought after Rosebud-Lott school district! Call TerryLynn to put an offer in today!
MlsNumber: --
ListingId: 561680


Listing Provided By: Texas Star Realty, original listing
Phone: (254) 721-5116
Office Phone: (254) 721-5116
Agent Name: Theresa Schrimsher
Disclaimer: Copyright © 2024 Central Texas Multiple Listing Service. 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