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(24) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( geometry::stgeomfromtext('multipolygon(((-79.9069333076477 44.674512553303565,-79.75037813186646 44.478870600803134,-79.98246431350708 44.35331432151491,-80.27360200881958 44.415145243110786,-80.43565034866333 44.48768863238376,-80.44938325881958 44.56699093657141,-79.9069333076477 44.674512553303565)))', 4326).stintersects(geometry::stgeomfromtext('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and type2 in ('commercial mix','business','commercial mix','hospitality','industrial','institutional - special purpose','manufacturing','multi-family','multi-tenant industrial','office','parking','residential commercial mix','retail','warehouse') and status='a' and idx_approved=1
Query String: Page=2&PageAction=ViewSubCat&URL=/other/commercial-listings/
Script Name: /index.asp