Error in search string [ SELECT DISTINCT tbl_ListingResidential.col_MLSNum AS col_MLSNum, tbl_ListingResidential.col_Class AS col_Class, tbl_ListingResidential.col_ListPrice AS col_ListPrice, tbl_ListingResidential.col_Address AS col_Address, tbl_ListingResidential.col_BedroomQty AS col_BedroomQty, tbl_ListingResidential.col_FullBathQty AS col_FullBathQty, tbl_ListingResidential.col_HalfBathQty AS col_HalfBathQty, tbl_ListingResidential.col_LastUpdate AS col_LastUpdate, tbl_ListingResidential.col_City AS col_City, tbl_ListingResidential.col_State AS col_State, tbl_ListingResidential.col_Zip AS col_Zip, tbl_ListingResidential.col_Type AS col_Type, tbl_GeoInfo.col_Latitude AS col_Latitude, tbl_GeoInfo.col_Longitude AS col_Longitude, (3959 * acos( cos(radians(44.809848)) * cos(radians(tbl_GeoInfo.col_Latitude)) * cos(radians(tbl_GeoInfo.col_Longitude) - radians(-91.492261)) + sin(radians(44.809848)) * sin(radians(tbl_GeoInfo.col_Latitude)))) AS col_Distance FROM (tbl_ListingResidential ) LEFT OUTER JOIN tbl_GeoInfo ON tbl_GeoInfo.col_MLSNum = tbl_ListingResidential.col_MLSNum HAVING col_Distance < 10 AND tbl_ListingResidential.col_ListPrice BETWEEN 0 AND 10000000 AND tbl_ListingResidential.col_BedroomQty >= 0 AND tbl_ListingResidential.col_FullBathQty >= 0 ORDER BY col_LastUpdate DESC, tbl_ListingResidential.col_Address LIMIT 250 ].
The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the NW WI MLS. The information, provided by seller, listing broker and other parties, may not have been verified. Information is deemed reliable but is not guaranteed.
