[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric.

This means there is most likely a problem with the "ConnectionString" info that you specified.
SELECT TOP 500 * FROM Properties WHERE BrokerID = 18 AND City <> '' AND ListPrice >= 0 AND ListPrice <= 10000000 AND bed = 0 AND bath >= 0.0 ORDER BY ListPrice DESC