No listings were found matching your search criteria.
All listings featuring the RMLS logo are provided by the Regional MLS of Florida. Copyright 2008 Regional MLS of Florida
This information is not verified for authenticity or accuracy and is not guaranteed. © 1998 – 2008 Regional Multiple Listing Service, Inc. All rights reserved.
(SELECT ML_Number AS mls_number, List_Price AS price, Bedrooms AS bedrooms, Full_Baths AS bathrooms, City AS city, ML_Number AS image, NULL AS type, Subdivision_Name AS subdivision, List_Agent_Name AS agent, List_Agent_Email AS agent_email, List_Agent_Phone AS agent_phone, List_Office_ID AS officeid, 'Residential' AS idx FROM idx_res WHERE `List_Price` >= 800000 AND `List_Price` <= 900000 AND `List_Office_ID` = '801301') UNION ALL (SELECT ML_Number AS mls_number, List_Price AS price, NULL AS bedrooms, NULL AS bathrooms, City AS city, ML_Number AS image, NULL AS type, NULL AS subdivision, List_Agent_Name AS agent, List_Agent_Email AS agent_email, List_Agent_Phone AS agent_phone, List_Office_ID AS officeid, 'Business' AS idx FROM idx_bus WHERE `List_Price` >= 800000 AND `List_Price` <= 900000 AND `List_Office_ID` = '801301') UNION ALL (SELECT ML_Number AS mls_number, List_Price AS price, NULL AS bedrooms, NULL AS bathrooms, City AS city, ML_Number AS image, NULL AS type, Subdivision_Name AS subdivision, List_Agent_Name AS agent, List_Agent_Email AS agent_email, List_Agent_Phone AS agent_phone, List_Office_ID AS officeid, 'Commercial' AS idx FROM idx_com WHERE `List_Price` >= 800000 AND `List_Price` <= 900000 AND `List_Office_ID` = '801301') UNION ALL (SELECT ML_Number AS mls_number, List_Price AS price, NULL AS bedrooms, NULL AS bathrooms, City AS city, ML_Number AS image, NULL AS type, Subdivision_Name AS subdivision, List_Agent_Name AS agent, NULL AS agent_email, NULL AS agent_phone, List_Office_ID AS officeid, 'Land' AS idx FROM idx_lnd WHERE `List_Price` >= 800000 AND `List_Price` <= 900000 AND `List_Office_ID` = '801301') UNION ALL (SELECT ML_Number AS mls_number, List_Price AS price, Bedrooms AS bedrooms, Full_Baths AS bathrooms, City AS city, ML_Number AS image, NULL AS type, Subdivision_Name AS subdivision, List_Agent_Name AS agent, List_Agent_Email AS agent_email, List_Agent_Phone AS agent_phone, List_Office_ID AS officeid, 'Rental' AS idx FROM idx_rnt WHERE `List_Price` >= 800000 AND `List_Price` <= 900000 AND `List_Office_ID` = '801301') ORDER BY price DESC
