• Home
• Featured Listings
• Sellers
• Buyers
• Agents
• Contact Us

• Blog
• Home Watch Service

• Jupiter Homes
• Jupiter Condos
• Jupiter Island Real Estate
• Jupiter Island Condos
• Admirals Cove
• Jonathan’s Landing
• Abacoa
  • Abacoa Town Center
  • Antigua
  • Cambridge
  • Charleston Court
  • Island at Abacoa
  • Mallory Creek
  • Martinique
  • Newhaven
  • Osceola Woods
  • Somerset
  • Tuscany
  • Valencia
  • Village
• Juno Beach Homes & Condos
• Palm Beach Gardens Communities
• North Palm Beach Communities
• Tequesta
• The Loxahatchee River
• Bluffs
• Singer Island
• Hobe Sound
• Jonathan's Landing Info
• Contact Us

Charleston Court

 Charleston Court - Charleston Court is a community of 2 story town homes with 1 and 2 car garages.  It has a community pool and located within walking distance to Abacoa Town Center and Roger Dean Stadium.   Charleston Court has approximately 180 units with many of them built on or near the Abacoa Golf Course providing expansive golf views.

All Listings

$200,000 - $300,000

3 Search Results Found. Showing Results 1 - 3.

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('Jupiter') AND (`Subdivision_Name` LIKE '%Charleston Court at Abacoa%' OR `Subdivision_Name` LIKE '%Charleston Court at Abacoa ph 02%') AND `Bedrooms` <= 100 AND `Full_Baths` <= 100 AND `Year_Built` >= 1900 ORDER BY List_Price DESC