Choosing an Estate Agent

[Gros]

I recommend Hatched. Cheap & it works. Your property also gets advertised on RightMove. Other DIY set-ups don't. Hatched is, in reality, an agency, but at a rock bottom price.

Thanks for this suggestion. Website certainly looks good, seems to offer more than Houseweb. A complete online estate agent.

However I did a search and got this:


Search Results

Microsoft JET Database Engine error '80040e14'

Extra ) in query expression 'CategoryName = 'Buy' AND TypeName = 'semi-detached' AND Price >= 250000 AND Price <= 300000 AND NoOfBedrooms >= 2)'.

/search_results.asp, line 120

[DimPrawn]

Thanks for this suggestion. Website certainly looks good, seems to offer more than Houseweb. A complete online estate agent.

However I did a search and got this:


Search Results

Microsoft JET Database Engine error '80040e14'

Extra ) in query expression 'CategoryName = 'Buy' AND TypeName = 'semi-detached' AND Price >= 250000 AND Price <= 300000 AND NoOfBedrooms >= 2)'.

/search_results.asp, line 120

Oh Dear.

Using MS Access.
Using classic ASP
Using dynamic SQL generation rather than parameters.
Showing the error details to the end user.

Avoid. Very noddy.

[Bob Dalek]

Thanks for this suggestion. Website certainly looks good, seems to offer more than Houseweb. A complete online estate agent.

However I did a search and got this:


Search Results

Microsoft JET Database Engine error '80040e14'

Extra ) in query expression 'CategoryName = 'Buy' AND TypeName = 'semi-detached' AND Price >= 250000 AND Price <= 300000 AND NoOfBedrooms >= 2)'.

/search_results.asp, line 120

What the frig am I supposed to do about it?

[chicane]

What the frig am I supposed to do about it?

Stop recommending crap websites.

[Bob Dalek]

Stop recommending crap websites.

Not crap. Sold my place for a few hundred. Try using the search facility like someone who doesn't understand SQL.

[chicane]

Not crap. Sold my place for a few hundred. Try using the search facility like someone who doesn't understand SQL.

The only thing I'll be finding on that website is a load of porn and malware links once some kid with basic SQL knowledge and too much time on their hands twigs how vulnerable the code is.

Not sure what you mean by the second sentence.

[Platypus]

a) Whether the estate agent demands exclusive rights to market your property;
b) Whether their terms and conditions demand a minimum tie-in period;

blah blah

Also be aware that many (larger) agents now have standard contracts which include a clause whereby you waiver your right to the cooling off period you're supposed to have. Someone I know in my area just got screwed over by signing one of these. Perfectly legal too.

[Bagpuss]

Which ones put you on RightMove for a £100 package? My understanding is RightMove is only for classic estate agents to use.

Linky please.

Used to be rightmove on houseweb, now fish4homes etc

http://www.houseweb.co.uk/prop/coverage.html


http://www.mousesale.co.uk/site/sale....php?sub=index

do rightmove for £399