SELECT *, CASE WHEN `locality` LIKE "titus county%" AND `slide_location` = "county-agent" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "county-agent" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "TX" AND (locality IN ("titus county") OR locality IS NULL) AND slide_location IN ("county-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[2] matching rows / [0.00 msec]
Blog ID 37
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$2,150,000453 Private Road 1625Mount Pleasant TX 75455View Listing
$1,500,000County Road 4260Mount Pleasant TX 75455View Listing
$1,219,189Old Paris RdMount Pleasant TX 75455View Listing
$899,000902 S Jefferson AveMount Pleasant TX 75455View Listing
$796,000County Road 1670Mount Pleasant TX 75455View Listing
$787,000116 County Road 4824Mount Pleasant TX 75455View Listing
$475,000County Road 4015Mount Pleasant TX 75455View Listing
$438,120County Road 3275Mount Pleasant TX 75455View Listing
$419,995510 NE County Road 2145Talco TX 75487View Listing
$400,500County Road 4663Mount Pleasant TX 75455View Listing
$399,9001708 W 16th StMount Pleasant TX 75455View Listing
$372,000Off of Highway 71Talco TX 75487View Listing
$350,000County Road 4215Mount Pleasant TX 75455View Listing
$239,0002524 Greenhill RdMount Pleasant TX 75455View Listing
$179,900529 County Road 1770Mount Pleasant TX 75455View Listing
$150,000County Road 4325 19 AcMount Pleasant TX 75455View Listing
$150,000County Road 4325 17 AcMount Pleasant TX 75455View Listing
$148,000County Road 1660Mount Pleasant TX 75455View Listing
$140,000County Road 4640Mount Pleasant TX 75455View Listing
$120,000Pr 2712 Lot 76Mount Pleasant TX 75455View Listing
$80,000County Road 1660Mount Pleasant TX 75455View Listing
$59,9005299 County Road 1915Mount Pleasant TX 75455View Listing
$55,000100 Grand Oaks DrMount Pleasant TX 75455View Listing
$49,900County Road 1740Mount Pleasant TX 75455View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-04-2024 4:39:57 pm.