select distinct dev from communities where city = 'Port Charlotte' and parent IS NULL and (publish = 'ARS' OR publish = 'AS') and description_2 != '' AND dev != ''

The data relating to homes for sale or lease or other real estate for sale or for rent on the ZFC website comes in part from a cooperative data exchange program of the MLS in which this Broker participates. The real estate displayed may not be all of the homes in the database, or all of the properties listed with Brokers participating in the cooperative data exchange program. Homes for sale that are listed by Brokers other than this Broker are marked with either the listing Broker's name or the MLS name or a logo provided by the MLS and the details page about such properties includes the name of the listing Brokers. Information provided is thought to be reliable but is not guaranteed to be accurate; you are advised to verify facts that are important to you. No warranties, expressed or implied, are provided for the data herein, or for their use or interpretation by the user. ZFC, the Florida Association of Realtors and its cooperating Multiple Listing Services do not create, control or review the property data displayed herein and take no responsibility for the content of such records. Federal law including the fair housing act prohibits discrimination on the basis of race, color, religion, sex, handicap, familial status or national origin in the sale, rental or financing of housing. All properties featuring the Miami Realtors logo are provided by the Miami Association of Realtors. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.