Please check your search filters, pan the map to a different area, or change your City/Neighborhood selection to ANY.
zoom: 12
latcenter: 27.3178042501
longcenter: -82.5248334079
QS:
query:
SELECT PropertyType, PropertySubType, STELLAR_ComTransactionType, Listings.ListingId, UnparsedAddress, City, CountyOrParish, StateOrProvince, PostalCode, ListPrice, BedroomsTotal, BathroomsTotalInteger, BathroomsFull, BathroomsHalf, PoolPrivateYN, WaterfrontFeatures, SpecialListingConditions, ListingContractDate, DATE_FORMAT(ListingContractDate, '%M %e, %Y') as ListedOn, ListOfficeName, PublicRemarks, LivingArea, STELLAR_TotalAcreage, LotSizeAcres, LotSizeSquareFeet, Latitude, Longitude, ClosePrice, DATE_FORMAT(CloseDate, '%M %e, %Y') as CloseDate, DaysOnMarket, CumulativeDaysOnMarket, Media FROM Listings WHERE 1=1 AND `MlsStatus` = 'Active' AND InternetAddressDisplayYN = 1 AND PropertyType = 'Residential' AND PropertySubType IN ('Single Family Residence','Farm') AND PropertySubType != 'Manufactured Home' AND PropertySubType != 'Mobile Home' AND ( ( Latitude BETWEEN 27.31780425009999 AND 27.31780425009999 ) AND ( Longitude BETWEEN -82.74181338836874 AND -82.30785342743124 ) ) ORDER BY ListingContractDate DESC LIMIT 0, 30
query:
SELECT PropertyType, PropertySubType, STELLAR_ComTransactionType, Listings.ListingId, UnparsedAddress, City, CountyOrParish, StateOrProvince, PostalCode, ListPrice, BedroomsTotal, BathroomsTotalInteger, BathroomsFull, BathroomsHalf, PoolPrivateYN, WaterfrontFeatures, SpecialListingConditions, ListingContractDate, DATE_FORMAT(ListingContractDate, '%M %e, %Y') as ListedOn, ListOfficeName, PublicRemarks, LivingArea, STELLAR_TotalAcreage, LotSizeAcres, LotSizeSquareFeet, Latitude, Longitude, ClosePrice, DATE_FORMAT(CloseDate, '%M %e, %Y') as CloseDate, DaysOnMarket, CumulativeDaysOnMarket, Media FROM Listings WHERE 1=1 AND `MlsStatus` = 'Active' AND InternetAddressDisplayYN = 1 AND PropertyType = 'Residential' AND PropertySubType IN ('Single Family Residence','Farm') AND PropertySubType != 'Manufactured Home' AND PropertySubType != 'Mobile Home' AND ( ( Latitude BETWEEN 27.31780425009999 AND 27.31780425009999 ) AND ( Longitude BETWEEN -82.74181338836874 AND -82.30785342743124 ) ) ORDER BY ListingContractDate DESC LIMIT 0, 30
The information relating to real estate for sale on this website comes in part from the My Florida Regional MLS DBA Stellar MLS. This information is provided exclusively for consumers' personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS.
