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.95460176467896 45.45724086262233,-76.27457857131958 45.264255114140326,-76.05897188186646 45.04344838585674,-75.30640840530396 45.25265503624703,-75.36134004592896 45.538098589494005,-75.5771666765213 45.4781883781261,-75.58918297290802 45.36637833907405,-75.66368401050568 45.302663445541896,-75.83431541919708 45.29469404344385,-75.95460176467896 45.45724086262233)))', 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','multi-family','single family','triplex','two apartment house') and status='a' and idx_approved=1
Query String: Page=18&PageAction=ViewSubCat&URL=/communities/ottawa-suburbs/
Script Name: /index.asp