select h.houseref, h.askprice, h.userpricedetails, h.saletypeint, h.salestatusint, h.leaseint, h.wcaddress, h.town, h.county, h.description, h.overview, h.numrecept, h.numbeds, h.numbaths, h.numgarage, h.postcode, h.classval01, h.classval04, geo.latitude, geo.longitude, b.branchaddress, b.branchname, branchemail, b.branchtel from houses h left join branches b on h.branch_id = b.branch_id left join geocodes.geocodes geo on h.postcode = geo.postcode where classval04 < 5 order by askprice desc Zoe Napier Country & Equestrian

Equestrian only

Sheering, Herts Essex Borders

very small horse

Price on Application

North Fambridge

very small horse

Offers in excess of £2,000,000

Stondon Massey

very small horse

Guide Price £1,950,000

Panfield

very small horse

Guide Price £1,950,000

Little Baddow

very small horse

Guide Price £1,750,000

Nr Stock

very small horse

Price on Application

Barling Magna, Rochford

very small horse

Guide Price £1,500,000

Old Harlow

very small horse

Guide Price £1,500,000

Rettendon Common

very small horse

Price on Application

Tillingham

very small horse

Guide Price £1,425,000

North Fambridge

very small horse

£1,400,000

Greenstead Green, Halstead

very small horse

Guide Price £1,375,000

Finchingfield

very small horse

Guide price £1,350,000

Coddenham

very small horse

Guide Price £1,345,000

very small horse

Guide Price £1,275,000

Latchingdon

very small horse

Price on Application

Felsted

very small horse

offers in excess of £1,250,000

Althorne

very small horse

Guide Price £1,195,000

North Weald

very small horse

Guide Price £995,000

Asheldham

very small horse

Guide Price £975,000

Halstead

very small horse

Guide Price £895,000

Downham

very small horse

Guide Price £850,000

Hockley

very small horse

Guide Price £725,000

Rettendon Common

very small horse

Price on Application

Alresford

very small horse

Guide Price £695,000

Great Bardfield

very small horse

Guide Price £695,000

Bradwell On Sea

very small horse

Guide Price £685,000

Pebmarsh, Nr Halstead

very small horse

Guide Price £675,000

Copford

very small horse

Guide Price £665,000

Coggeshall

very small horse

Offers in excess of £660,000

Thaxted

very small horse

Guide Price £615,000

Southminster

very small horse

Guide Price £599,950

Althorne

very small horse

Guide Price £595,000

Tolleshunt Knights

very small horse

Guide Price £580,000

Wethersfield

very small horse

Guide Price £565,000

Latchingdon

very small horse

Guide Price £500,000

Althorne

very small horse

Offers in Excess of £500,000

Leavenheath

very small horse

Guide Price £475,000

Great Maplestead

very small horse

Guide Price £475,000

Gestingthorpe, Nr Halstead

very small horse

Guide Price £465,000

Frinton On Sea

very small horse

Offers in Excess of £450,000

Weeley Heath

very small horse

Guide Price £395,000

Great Oakley

very small horse

Guide Price £295,000

Langham

very small horse

Guide Price £185,000

Cressing

very small horse

Guide Price £120,000