SELECT *, CASE WHEN `locality` LIKE "williamson 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 ("williamson county") OR locality IS NULL) AND slide_location IN ("county-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[3] matching rows / [0.00 msec]
Blog ID 37
Blah
$5,750,000Farm to Market # 972Georgetown TX 78626View Listing
$5,300,0003625 N Interstate 35Georgetown TX 78628View Listing
$5,160,9891951 County Road 332 RdJarrell TX 76537View Listing
$5,000,0001515 County Road 315Jarrell TX 76537View Listing
$5,000,0001100 County Road 215Florence TX 76527View Listing
$4,607,95114852 W State Highway 29Liberty Hill TX 78642View Listing
$4,000,0001701 County Road 413Taylor TX 76574View Listing
$3,750,00015210 FM 1660Taylor TX 76574View Listing
$3,750,00019919 FM 973 Rd NCoupland TX 78615View Listing
$3,100,000750 County Road 307Jarrell TX 76537View Listing
$3,000,000600 County Road 405Taylor TX 76574View Listing
$2,800,000973 N Patterson AveFlorence TX 76527View Listing
$2,500,0004001 County Road 384Bartlett TX 76511View 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-13-2024 2:33:53 pm.