err#-2147217871<br>err desc:Query timeout expired<br>sql:select id from propertiesfreeholdandcondos with (nolock) where board in(17,86,41,20,97,43,44,51,11,46,37,16,13,15,85,76,110,50,100,30,24,47,88,31,14,82) and 1=1  and lattlongchecked = 1 and latitude is not null and longitude is not null  and ( Geometry::STGeomFromText('multipolygon(((-77.67611295262599 44.02695508858774,-77.76949674168849 44.22804525700999,-77.66512662450099 44.26739442109689,-78.19796353856349 45.31214394053387,-77.68709928075099 45.447188885948485,-77.21468717137599 44.573414400012624,-77.06087857762599 44.42845076792657,-77.01144010106349 44.192608503171414,-77.18722135106349 44.141384440605094,-77.35750943700099 44.15320932631078,-77.57174283543849 44.07827837677422,-77.67611295262599 44.02695508858774)))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and sale_lease in ('sale')  and status='a'  and idx_approved=1<br>Query String: PageAction=ViewSubCat&URL=/communities/hastings/<br>Script Name: /index.asp<br>