Captain's Key
Captains Key is located in North Palm Beach Florida. Captains Key is an intimate community built on navigable water with access to the Atlantic Ocean. Captains Key is very conveniently located to public beaches, shops and many great restaurants.
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('North Palm Beach') AND (`Subdivision_Name` LIKE '%Captains Key%') AND `Bedrooms` <= 100 AND `Full_Baths` <= 100 AND `List_Price` >= 600000 AND `List_Price` <= 700000 AND `Year_Built` >= 1900 ORDER BY List_Price DESC
