Aston Gardens condos for sale

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`.`ListingMLS` IS NOT NULL AND ((ST_INTERSECTS(t2.Point, GeomFromText('MU' 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 `t1`.`ListingMLS` IS NOT NULL AND ((ST_INTERSECTS(t2.Point, GeomFromText('MU' 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 `t1`.`ListingMLS` IS NOT NULL AND ((ST_INTERSECTS(t2.Point, GeomFromText('MU' 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 `t1`.`ListingMLS` IS NOT NULL AND ((ST_INTERSECTS(t2.Point, GeomFromText('MU' 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 `t1`.`ListingMLS` IS NOT NULL AND ((ST_INTERSECTS(t2.Point, GeomFromText('MU' 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 `t1`.`ListingMLS` IS NOT NULL AND ((ST_INTERSECTS(t2.Point, GeomFromText('MU' 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 `t1`.`ListingMLS` IS NOT NULL AND ((ST_INTERSECTS(t2.Point, GeomFromText('MU' 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 `t1`.`ListingMLS` IS NOT NULL AND ((ST_INTERSECTS(t2.Point, GeomFromText('MU' 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 `t1`.`ListingMLS` IS NOT NULL AND ((ST_INTERSECTS(t2.Point, GeomFromText('MU' at line 1
Click the links below to sort results by price range.
Under $100,000 $200,000 - $300,000 $300,000 - $400,000

Aston Gardens condos for sale

5 Properties Found. Page 1 of 1.

Aston Gardens Naples - Senior Condos Over 55+

Located in Pelican Marsh,  Aston Gardens in Naples, Florida, is a senior living retirement community, located on the Tiburon Golf Course.  You can choose to live independently in your own home or rent a luxury Aston Gardens apartment, villa or one of the wonderful senior condos in Naples. There are also facilities at Ashton Gardens for assisted living residents.  Offering a country club lifestyle Aston Gardens, Naples has a Grand Clubhouse serving gourmet meals, plus there is complimentary transportation, this is luxurious resort style senior living at it's best.  Close to Shopping and fine dining at the Waterside shopping mall and the Mercato, where you will find more shops entertainment restaurants and a movie theater, these 55+ apartments are set in a very convenient location.

Data last updated: July 19th, 2024 at 1:36am 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.