Frenchman's Creek, Florida Real Estate
Frenchman's Creek Florida Homes For Sale
Frenchman's Creek is one of the earlier developments in Northern Palm Beach County. Located in Palm Beach Gardens, Frenchman's Creek has long since set the standard for country club living. With its two 18 hole championship golf courses, 17 Har-tru tennis courts, deepwater achoroage and luxurious club house, Frenchman's Creek has something to offer everyone. The North Course was recently redesigned by Jim Fazio and the South Course was redesigned by Bob Cupp which provides a fantastic golf experience for players of all levels.
| All Listings |
$400,000 - $500,000 |
$500,000 - $600,000 |
$600,000 - $700,000 |
$700,000 - $800,000 |
$900,000 - $1,000,000 |
Over $1,000,000 |
25 Search Results Found. Showing Results 1 - 15.
MLS# R2959699
City:
Palm Beach Gardens
Bedrooms:
6
Bathrooms:
7
Property Type:
Residential
MLS# R2968280
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
6
Property Type:
Residential
MLS# R3064842
City:
Palm Beach Gardens
Bedrooms:
4
Bathrooms:
6
Property Type:
Residential
MLS# R3070436
City:
Palm Beach Gardens
Bedrooms:
4
Bathrooms:
5
Property Type:
Residential
MLS# R3114344
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
6
Property Type:
Residential
MLS# R2864300
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
6
Property Type:
Residential
MLS# R3098185
City:
Palm Beach Gardens
Bedrooms:
3
Bathrooms:
2
Property Type:
Residential
MLS# R3031090
City:
Palm Beach Gardens
Bedrooms:
6
Bathrooms:
7
Property Type:
Residential
MLS# R3095554
City:
Palm Beach Gardens
Bedrooms:
4
Bathrooms:
4
Property Type:
Residential
MLS# R3068995
City:
Palm Beach Gardens
Bedrooms:
4
Bathrooms:
5
Property Type:
Residential
MLS# R3060353
City:
Palm Beach Gardens
Bedrooms:
4
Bathrooms:
5
Property Type:
Residential
MLS# R3077159
City:
Palm Beach Gardens
Bedrooms:
3
Bathrooms:
4
Property Type:
Residential
MLS# R3068283
City:
Palm Beach Gardens
Bedrooms:
3
Bathrooms:
3
Property Type:
Residential
MLS# R3068585
City:
Palm Beach Gardens
Bedrooms:
3
Bathrooms:
4
Property Type:
Residential
MLS# R3128126
City:
Palm Beach Gardens
Bedrooms:
3
Bathrooms:
3
Property Type:
Residential
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('Palm Beach Gardens') AND (`Subdivision_Name` LIKE '%Frenchmans Creek%') AND `Bedrooms` <= 100 AND `Full_Baths` <= 100 AND `Year_Built` >= 1900 ORDER BY List_Price DESC LIMIT 0,15