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.71283414959908 45.40254804714424,-75.72201803326607 45.39959505543274,-75.72939947247505 45.395798125016285,-75.73489263653755 45.388926840480536,-75.75463369488716 45.37041843760903,-75.75789526104927 45.37614644087407,-75.75866773724556 45.37777429382285,-75.76227262616158 45.37735226237295,-75.76407507061958 45.37693022777321,-75.76725080609322 45.37795516347998,-75.76924838125706 45.380185841682085,-75.77572859823704 45.38380297062277,-75.75901105999947 45.40664582074424,-75.73532178997993 45.41694920255326,-75.7211597263813 45.41875661958769,-75.7255370914936 45.411406096232504,-75.71283414959908 45.40254804714424)))', 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=6&PageAction=ViewSubCat&URL=/communities/kitchissippi/
Script Name: /index.asp