SELECT *, CASE WHEN `name` LIKE "ashburn%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "ashburn" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "ashburn" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "ashburn" 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 ("ashburn") 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 *, "0" as `rank` FROM `wp_slides` WHERE st = "VA" AND (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
$899,95019814 Bodmer DrAshburn VA 20147View Listing
$899,90021720 Shellhorn RdAshburn VA 20147View Listing
$899,00020400 Roslindale DrAshburn VA 20147View Listing
$898,95019812 Bodmer DrAshburn VA 20147View Listing
$896,95043474 Grandmoore StAshburn VA 20148View Listing
$895,00022180 Lewis Mountain TerAshburn VA 20148View Listing
$889,95043472 Grandmoore StAshburn VA 20148View Listing
$888,85343435 Farringdon SqAshburn VA 20148View Listing
$879,99043173 Deveron SqAshburn VA 20148View Listing
$879,90022349 Trailview Crossing TerAshburn VA 20148View Listing
$876,65843439 Farringdon SqAshburn VA 20148View Listing
$875,00020672 Meadowthrash CtAshburn VA 20147View Listing
$875,00042848 Crowfoot CtAshburn VA 20147View Listing
$875,00043132 Birch Landing SqAshburn VA 20148View Listing
$867,38043595 Farringdon SqAshburn VA 20148View Listing
$865,00043183 Hunt Manor CtAshburn VA 20147View Listing
$861,47043593 Farringdon SqAshburn VA 20148View Listing
$859,99043041 Greeley SqAshburn VA 20148View 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 9:12:13 am.
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