Arbors
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', `Status` AS 'status', `Bedrooms` AS 'bedrooms', `Full_Baths` AS 'bathrooms', `Address` AS 'address', `Area_Number` AS 'area', `City` AS 'city', `Sub_Type` AS 'subtype', `Zip_Code` AS 'zip_code', `Liv_Area_SqFt` AS 'sqft', `Year_Built` AS 'year', `Public_Remarks` AS 'remarks', `ML_Number` AS 'image', `List_Office_Name` AS 'office', `List_Office_ID` AS 'officeid', `List_Agent_Name` AS 'agent', `List_Agent_Email` AS 'agent_email', `List_Agent_ID` AS 'agent_id', `List_Agent_Phone` AS 'agent_phone', `Subdivision_Name` AS 'subdivision', `Virtual_Tour_Link` AS 'virtual_tour', `Lot_Size` AS 'acres', `Development_Name` AS 'development', `County_Name` AS 'county', `Waterfront_YN` AS 'waterfront_yn', `View` AS 'view', `Pool_Y/N` AS 'pool_yn', `Cooling` AS 'cooling', `Equipment` AS 'equipment', `Front_Exposure` AS 'front_exposure', `Furnished` AS 'furnished', `Governing_Body` AS 'governing_body', `Restrictions` AS 'restrictions', `Security` AS 'security', `Utilities` AS 'utilities', `Total_Bldg_SF_Incl` AS 'total_sqft', `Total_Floors` AS 'total_floors', `Total_Units_in_Bldg` AS 'units_in_bldg', `Total_Units_in_Complex` AS 'units_complex', `Unit_Description` AS 'unit_desc', `Tax_ID` AS 'parcel_id', `Half_Baths` AS 'half_baths', `Parking` AS 'parking', `Parking` AS 'parking_space_num', `Pets_Allowed` AS 'pets_allowed', `Roof` AS 'roof', `Rooms` AS 'rooms', `Waterfront_Desc` AS 'waterfront_desc', `Window_Treatment` AS 'window_treatment', `Year_Built_Desc` AS 'year_built_desc', `Zip_Plus4` AS 'zip_plus4', `Tax_Amount` AS 'tax_amount', `Subdivision_Info` AS 'subdivision_info', `Master_Bdrm_Bath` AS 'master_bdrm_bath', `Market_Time` AS 'market_time', `HOA` AS 'hoa', `HOA_Amount` AS 'hoa_amount', `HOA_Fee_Per` AS 'hoa_fee_per' FROM idx_res WHERE REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`City`, '.', ''), '/', ''), ')', ''), '(', ''), ' ', ' ') = UPPER('Hobe Sound') AND (`Subdivision_Name` LIKE '%Forest Glade / arbors%' OR `Subdivision_Name` LIKE '%Forest Glade / the arbors%') AND `Bedrooms` <= 100 AND `Full_Baths` <= 100 AND `Year_Built` >= 1900 ORDER BY List_Price DESC
