err#-2147217900
err desc:Could not find method 'stgeomfromtext' for type 'Microsoft.SqlServer.Types.SqlGeometry' in assembly 'Microsoft.SqlServer.Types'
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(125, 76) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( geometry::stgeomfromtext('multipolygon(((-75.75386121869087 45.3368225773578,-75.76278761029243 45.351602387525936,-75.71652486920357 45.37156408467433,-75.70605352520943 45.35341189502947,-75.70124700665474 45.35214524585177,-75.69644048810005 45.34249365462379,-75.69892957806587 45.33646057441736,-75.69575384259224 45.333986825720025,-75.69961622357368 45.330306170353424,-75.6962688267231 45.319081711744005,-75.69832876324654 45.31678826918668,-75.69583967328072 45.30725138106681,-75.7130916416645 45.299463744431435,-75.71189001202583 45.29270151790356,-75.72570875287056 45.28841433167348,-75.73154523968697 45.29873925873154,-75.75660780072212 45.28865587190627,-75.78003957867622 45.27869148343502,-75.79248502850533 45.300429710964806,-75.80527380108833 45.317331461339364,-75.80604627728462 45.32505629719886,-75.80965116620064 45.331633647407784,-75.75386121869087 45.3368225773578)))', 4326).stintersects(geometry::stgeomfromtext('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and sale_lease in ('sale') and type2 in ('att/row/twnhouse','condo apt','duplex','fourplex','garden home','house','modular','multi-family','single family','triplex','two apartment house') and status='a' and idx_approved=1
Query String: Page=2&PageAction=ViewSubCat&URL=/communities/knoxdale-merivale/
Script Name: /index.asp