Listings at the Fairfax Club

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (`t1`.`AddressSubdivision` = 'Fairfax Club') LIMIT 1' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` <= '100000' AND (`t1`.`AddressSubdivision` = 'Fairfax Club') ' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` >= '100000' AND `ListingPrice` <= '200000' AND (`t1`.`Address' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` >= '200000' AND `ListingPrice` <= '300000' AND (`t1`.`Address' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` >= '300000' AND `ListingPrice` <= '400000' AND (`t1`.`Address' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` >= '400000' AND `ListingPrice` <= '500000' AND (`t1`.`Address' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` >= '500000' AND `ListingPrice` <= '600000' AND (`t1`.`Address' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` >= '600000' AND `ListingPrice` <= '700000' AND (`t1`.`Address' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` >= '700000' AND `ListingPrice` <= '800000' AND (`t1`.`Address' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` >= '800000' AND `ListingPrice` <= '900000' AND (`t1`.`Address' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` >= '900000' AND `ListingPrice` <= '1000000' AND (`t1`.`Addres' at line 1SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `ListingPrice` >= '1000000' AND (`t1`.`AddressSubdivision` = 'Fairfax Club')' at line 1

Listings at the Fairfax Club

8 Properties Found. Page 1 of 1.

Fairfax Club Condos for sale in Naples Fl>

Looking for a great location? Take a look at the  Fairfax Club condos, located in Olde Naples, on 12th Avenue South, between Port Royal and 5th Avenue South. This area feels more like living on an Island than a town, water surrounds the peninsula, with the Gulf of Mexico on one side and Naples Bay on the other.  Located in the bay you will find Naples City Dock where you can take out a daily fishing charter, or moor your own boat, prices for local residents are extremely reasonable.  The Dock restaurant overlooks the entrance to the City Dock, a great place to unwind after a day in on the water.  The Fairfax Club Naples is a 55+ community, amenities here include a Clubhouse, including a kitchen, the clubhouse has the capability of hosting quite large parties, swimming pool, shuffleboard, picnic area, barbeque and grills, and bocce are also available.

Data last updated: July 19th, 2024 at 2:15am EDT and updating occurs daily

Naples Area Board of Realtors Logo The data relating to real estate for sale on this Website come in part from the Broker Reciprocity Program (BR Program) of M.L.S. of Naples, Inc. Properties listed with brokerage firms other than Royal Shell Real Estate are marked with the BR Program Icon or the BR House Icon and detailed information about them includes the name of the Listing Brokers. The properties displayed may not be all the properties available through the BR Program.