SELECT *, CASE WHEN `name` LIKE "williamsburg%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "williamsburg" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "williamsburg" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "williamsburg" 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 = "VA" AND (locality IN ("williamsburg") 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 7
Blah
SELECT *, CASE WHEN `name` LIKE "williamsburg%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "williamsburg" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "williamsburg" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "williamsburg" 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 = "VA" AND (locality IN ("williamsburg") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[1] matching rows / [0.00 msec]
Blog ID 7
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,850,0002921 Barrets Pointe RdWilliamsburg VA 23185View Listing
$1,695,0001592 Harbor RdWilliamsburg VA 23185View Listing
$1,650,0002523 Manion DrWilliamsburg VA 23185View Listing
$1,650,000136 Roffinghams WayWilliamsburg VA 23185View Listing
$1,650,000101 Ensign John UtieWilliamsburg VA 23185View Listing
$1,599,000613 Dock LndgWilliamsburg VA 23185View Listing
$1,500,000109 BroadwaterWilliamsburg VA 23188View Listing
$1,495,9003463 WestportWilliamsburg VA 23188View Listing
$1,490,000201 Rivers EdgeWilliamsburg VA 23185View Listing
$1,435,0001022 Jamestown RdWilliamsburg VA 23185View Listing
$1,395,00039 Whittakers Mill RdWilliamsburg VA 23185View Listing
$1,300,0001753 S Founders HlWilliamsburg VA 23185View Listing
$1,275,0008148 Wrenfield DrWilliamsburg VA 23188View Listing
$1,250,000104 John Pott DrWilliamsburg VA 23188View Listing
$1,199,0001588 River RdgWilliamsburg VA 23185View Listing
$1,198,000207 Shady Bluff PtWilliamsburg VA 23188View Listing
$1,195,000203 WatertonWilliamsburg VA 23188View Listing
$1,150,000302 Rivers EdgeWilliamsburg VA 23185View Listing
$1,140,000104 William RichmondWilliamsburg VA 23185View Listing
$1,100,000119 Edenbridge StWilliamsburg VA 23188View Listing
$1,015,000115 Entry HlWilliamsburg VA 23188View Listing
$1,000,000108 BirdieWilliamsburg VA 23188View Listing
$1,000,000190 BlackheathWilliamsburg VA 23188View Listing
$999,000109 LothianWilliamsburg VA 23188View 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-07-2024 8:03:00 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "VA" 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 7
Blah