err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-76.37912406542968 44.25009843812332,-76.28574027636718 44.30024519995577,-76.18960990527343 44.30221086764293,-76.17450370410155 44.22845329042562,-76.31320609667968 44.19498603641781,-76.36539115527343 44.12700873827674,-76.47250785449218 44.0836200004753,-76.78012504199218 44.08657933516313,-76.82956351855468 44.14277856510212,-76.4354289970703 44.22058035339482,-76.37912406542968 44.25009843812332)))', 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
Query String: PageAction=ViewSubCat&URL=/communities/the-islands/
Script Name: /index.asp