Frenchman's Reserve, Florida Real Estate
Frenchman's Reserve Homes For Sale
Frenchman's Reserve is a newer golf community located in Palm Beach Gardens and was developed by Toll Brothers. The 18 hole championship golf course is an Arnold Palmer Signature Design. With a luxurious club house along with beautiful swimming pool and 6 Har-tru tennis courts, Frenchman's Reserve boast all of the amenities for fabulous country club living.
| All Listings |
Under $100,000 |
$100,000 - $200,000 |
$200,000 - $300,000 |
$300,000 - $400,000 |
$400,000 - $500,000 |
$500,000 - $600,000 |
$600,000 - $700,000 |
$700,000 - $800,000 |
$800,000 - $900,000 |
$900,000 - $1,000,000 |
Over $1,000,000 |
56 Search Results Found. Showing Results 1 - 15.
MLS# R2991437
City:
Palm Beach Gardens
Bedrooms:
6
Bathrooms:
7
Property Type:
Residential
MLS# R2923282
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
5
Property Type:
Residential
MLS# R3060986
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
6
Property Type:
Residential
MLS# R3009194
City:
Palm Beach Gardens
Bedrooms:
6
Bathrooms:
6
Property Type:
Residential
MLS# R3111844
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
5
Property Type:
Residential
MLS# R3073081
City:
Palm Beach Gardens
Bedrooms:
6
Bathrooms:
5
Property Type:
Residential
MLS# R3110878
City:
Palm Beach Gardens
Bedrooms:
4
Bathrooms:
5
Property Type:
Residential
MLS# R3101335
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
5
Property Type:
Residential
MLS# R3020939
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
6
Property Type:
Residential
MLS# R3051513
City:
Palm Beach Gardens
Bedrooms:
4
Bathrooms:
3
Property Type:
Residential
MLS# R3102576
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
5
Property Type:
Residential
MLS# R3081565
City:
Palm Beach Gardens
Bedrooms:
3
Bathrooms:
3
Property Type:
Residential
MLS# R3110351
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
5
Property Type:
Residential
MLS# R3082446
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
5
Property Type:
Residential
MLS# R3063294
City:
Palm Beach Gardens
Bedrooms:
5
Bathrooms:
5
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 (`Tax_ID` LIKE '%52434131%') AND `Bedrooms` <= 100 AND `Full_Baths` <= 100 AND `Year_Built` >= 1900 ORDER BY List_Price DESC LIMIT 0,15