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.62687069177628 45.468799075209894,-75.67854076623917 45.460732655800314,-75.69725185632706 45.44905236166804,-75.69896847009659 45.44170578298928,-75.69090038537979 45.437249195331844,-75.6831756234169 45.43736964827514,-75.6780257821083 45.43833326256496,-75.67620791494846 45.440079771522065,-75.67500628530979 45.44038088829218,-75.67354716360569 45.44137456223175,-75.67148722708225 45.442187555165454,-75.67084349691868 45.44291020571599,-75.67015685141087 45.44507810182915,-75.66968478262424 45.44555984520757,-75.6542781740427 45.44528886506341,-75.65041579306126 45.4398689888268,-75.65367735922337 45.438815063538925,-75.65238989889622 45.43673726745431,-75.65157450735569 45.436165107271684,-75.65037287771702 45.432009243435076,-75.6493429094553 45.432009243435076,-75.6493429094553 45.42999143106494,-75.67110098898411 45.42854578978903,-75.667839422822 45.42228091640412,-75.66247500479221 45.41700945071982,-75.65638102591038 45.41764205258774,-75.65148867666721 45.419118096052166,-75.63513793051243 45.42032300088725,-75.64118899405003 45.43095517134557,-75.61226405203342 45.441224006699144,-75.62687069177628 45.468799075209894)))', 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=5&PageAction=ViewSubCat&URL=/communities/rideau-rockliffe/
Script Name: /index.asp