SELECT *, CASE WHEN `name` LIKE "horseshoe bay%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "horseshoe bay" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "horseshoe bay" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "horseshoe bay" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "TX" AND (locality IN ("horseshoe bay") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 37
Blah
SELECT *, CASE WHEN `name` LIKE "horseshoe bay%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "horseshoe bay" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "horseshoe bay" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "horseshoe bay" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "TX" AND (locality IN ("horseshoe bay") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[3] 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.
$1,499,0003305 Close CallHorseshoe Bay TX 78657View Listing
$1,385,000301 Twisted Oak DrHorseshoe Bay TX 78657View Listing
$1,355,4001402 Mountain DewHorseshoe Bay TX 78657View Listing
$1,310,000W10036-A Moon StoneHorseshoe Bay TX 78657View Listing
$1,299,000321 PaintbrushHorseshoe Bay TX 78657View Listing
$1,200,000130 Christine CirHorseshoe Bay TX 78657View Listing
$1,150,000W25051 BuckeyeHorseshoe Bay TX 78657View Listing
$1,100,000402 Blvd NHorseshoe Bay TX 78657View Listing
$1,096,000301 Sun RayHorseshoe Bay TX 78657View Listing
$1,095,000100 Azalea LoopHorseshoe Bay TX 78657View Listing
$999,899313 Lucy LnHorseshoe Bay TX 78657View Listing
$995,000515 Free ReinHorseshoe Bay TX 78657View Listing
$970,000104 Cactus CorHorseshoe Bay TX 78657View Listing
$965,000103 HI Ridge RdHorseshoe Bay TX 78657View Listing
$950,000806 Silver HlHorseshoe Bay TX 78657View Listing
$950,000106 MysticHorseshoe Bay TX 78657View Listing
$925,000509 SombreroHorseshoe Bay TX 78657View Listing
$895,000Desert Rose North Unit West Lot W3086Horseshoe Bay TX 78657View Listing
$875,000129 Azalea LoopHorseshoe Bay TX 78657View Listing
$865,000707 Broken Hills DrHorseshoe Bay TX 78657View Listing
$849,000316 Lucy LnHorseshoe Bay TX 78657View Listing
$845,747306 Belforte Blvd Unit Bellagio 81Horseshoe Bay TX 78657View Listing
$845,747306 Belforte Blvd Unit 34Horseshoe Bay TX 78657View Listing
$799,240403 Mayapple Rd Unit Palermo 34Horseshoe Bay TX 78657View 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-12-2024 12:27:14 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "TX" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 37
Blah