Patricia Shay
| share on: |
|
|
|
DIRECT: (209) 404-2891
EMAIL:
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
License #: 00904024
License #: 00904024
Find a home quick search
|
Mortgage Calculator
|
DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' , latitude, longitude) dist, ABS(CAST(price as unsigned integer) + 0 - 1601250)' at line 1 SQL=SELECT *, geodistkm(, , latitude, longitude) dist, ABS(CAST(price as unsigned integer) + 0 - 1601250) as dif FROM jos_rets_properties WHERE systemID = 'CRMLS' AND geodistkm(, , latitude, longitude) <= '10' AND mlsid <> 'MC11095260' AND prType = 'listing_mrmls_land' AND CAST(price as unsigned integer) + 0 >= '1501250' AND CAST(price as unsigned integer) + 0 <= '1701250' AND bedrooms_number >= '-1' AND bedrooms_number <= '1' AND baths_number >= '-1' AND baths_number <= '1' AND ( status = 'B' OR status = 'A' ) ORDER BY dif ASC, dist ASC LIMIT 5 |