SELECT *, CASE WHEN `name` LIKE "severna park%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "severna park" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "severna park" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "severna park" 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 = "MD" AND (locality IN ("severna park") 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 50
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MD" 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 50
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.
$14,995,000938 Old County RdSeverna Park MD 21146View Listing
$3,199,000177 Ritchie HwySeverna Park MD 21146View Listing
$2,195,000389 South DrSeverna Park MD 21146View Listing
$1,950,000755 Dividing RdSeverna Park MD 21146View Listing
$1,850,000316 North DrSeverna Park MD 21146View Listing
$1,850,000328 North DrSeverna Park MD 21146View Listing
$1,489,000626 Old County RdSeverna Park MD 21146View Listing
$1,400,0006 Evergreen TrlSeverna Park MD 21146View Listing
$1,195,000602 Saltzman RdSeverna Park MD 21146View Listing
$1,035,000614 Hidden Pond LnSeverna Park MD 21146View Listing
$975,000639 Dunkeld CtSeverna Park MD 21146View Listing
$899,990140 Dennis RdSeverna Park MD 21146View Listing
$849,900106 Retriever WaySeverna Park MD 21146View Listing
$830,00010 Woodbent DrSeverna Park MD 21146View Listing
$799,000384 Sheffield RdSeverna Park MD 21146View Listing
$735,000816 Baltimore Annapolis BlvdSeverna Park MD 21146View Listing
$725,000647 Benfield RdSeverna Park MD 21146View Listing
$675,000254 Shakespeare CtSeverna Park MD 21146View Listing
$650,00044 Baldy AveSeverna Park MD 21146View 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 10:21:24 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MD" 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 50
Blah
Ranch
Single Family
