SELECT *, CASE WHEN `name` LIKE "haymarket%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "haymarket" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "haymarket" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "haymarket" 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 ("haymarket") 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
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,100,0005433 Fishers Hill WayHaymarket VA 20169View Listing
$1,100,0005441 Sherman Oaks CtHaymarket VA 20169View Listing
$1,075,00015104 Gaines Mill CirHaymarket VA 20169View Listing
$1,060,0005477 Sherman Oaks CtHaymarket VA 20169View Listing
$1,009,10015032 Walter Robinson LnHaymarket VA 20169View Listing
$999,99015033 Walter Robinson LnHaymarket VA 20169View Listing
$999,9005318 Jacobs Creek PlHaymarket VA 20169View Listing
$990,0004680 Glass Mountain WayHaymarket VA 20169View Listing
$989,0005518 Hillsman Farm LnHaymarket VA 20169View Listing
$972,9004648 Antioch RdHaymarket VA 20169View Listing
$969,99015009 Walter Robinson LnHaymarket VA 20169View Listing
$969,00015179 Landing DrHaymarket VA 20169View Listing
$929,99014979 Walter Robinson LnHaymarket VA 20169View Listing
$899,00015275 Golf View DrHaymarket VA 20169View Listing
$879,99015021 Walter Robinson LnHaymarket VA 20169View Listing
$868,61315800 Gardenia Ridge WayHaymarket VA 20169View Listing
$859,47415796 Gardenia Ridge WayHaymarket VA 20169View Listing
$859,00015046 Gaines Mill CirHaymarket VA 20169View Listing
$850,0004110 Mountain RdHaymarket VA 20169View Listing
$840,00015459 Championship DrHaymarket VA 20169View Listing
$839,99015379 Neptune CtHaymarket VA 20169View Listing
$799,9005758 Benford DrHaymarket VA 20169View Listing
$750,0005283 Antioch Ridge DrHaymarket VA 20169View Listing
$748,49816101 Calla Lily LnHaymarket VA 20169View 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 9:03:40 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
Ranch
Single Family
