Land.US is a premier publishing resource for U.S. land investors and legacy buyers.
SELECT *, CASE WHEN `locality` LIKE "st johns county%" AND `slide_location` = "county-agent" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "county-agent" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "FL" AND slide_location IN ("county-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[1] matching rows / [0.00 msec]
Blog ID 4
Blah
Street View data not found for this location.
Would you like us to send you recommendations?
Skip the hard work of searching for trustworthy local professionals on your own. Let us help you connect with professionals who will help you buy and sell land.
$11,8006247 W MAGNOLIA DRIVESAINT AUGUSTINE FL 32095View Listing
$11,8006291 W MAGNOLIA DRIVESAINT AUGUSTINE FL 32095View Listing
$11,8006325 W MAGNOLIA DRIVESAINT AUGUSTINE FL 32095View 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 .