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

Great Warley

very small horse

Guide Price £3,100,000

Wickham Bishops

very small horse

Guide Price £2,150,000

North Fambridge

very small horse

Offers in excess of £2,000,000

Panfield

very small horse

Guide Price £1,950,000

Brettenham

very small horse

Guide Price £1,895,000

Horsemanside, Navestock

very small horse

Guide Price £1,895,000

Little Baddow

very small horse

Guide Price £1,695,000

Blackmore End

very small horse

Guide Price £1,650,000

Nr Stock

very small horse

Price on Application

Barling Magna, Rochford

very small horse

Guide Price £1,500,000

Rettendon Common

very small horse

Price on Application

Burnham On Crouch

very small horse

Guide Price £1,495,000

North Fambridge

very small horse

£1,400,000

Greenstead Green, Halstead

very small horse

Guide Price £1,375,000

Coddenham

very small horse

Guide Price £1,345,000

Tillingham

very small horse

Offers in Excess of £1,250,000

Althorne

very small horse

Guide Price £1,195,000

Felsted

very small horse

Price on Application

Sible Hedingham

very small horse

Guide Price £975,000

Great Holland

very small horse

Guide Price £950,000

Orsett

very small horse

Guide Price £895,000

Easthorpe

very small horse

Guide Price £850,000

Downham

very small horse

Guide Price £850,000

Hockley

very small horse

Offers in the region of £795,000

Barnston

very small horse

Offers in Excess of £790,000

Paglesham

very small horse

Guide Price £785,000

Southminster

very small horse

Guide Price £775,000

Hockley

very small horse

Guide Price £725,000

Cressing

very small horse

Guide Price £725,000

Billericay

very small horse

Guide Price £725,000

Steeple

very small horse

Guide Price £724,500

Tolleshunt Knights

very small horse

Price on Application

Rettendon Common

very small horse

Price on Application

Alresford

very small horse

Guide Price £695,000

Mayland Sea

very small horse

Guide Price £675,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

Wickham St Paul, Halstead

very small horse

Offers in excess of £625,000

Althorne

very small horse

Guide Price £595,000

Ardleigh

very small horse

Guide Price £595,000

Navestock

very small horse

Offers in excess £580,000

Great Totham

very small horse

Guide Price £550,000

Tolleshunt Knights

very small horse

Guide Price £540,000

Althorne

very small horse

Offers in Excess of £500,000

Great Bardfield

very small horse

Offers in excess of £500,000

Purleigh

very small horse

Guide Price £500,000

Curtis Mill Green

very small horse

Offer in excess of £485,000

Great Maplestead

very small horse

Guide Price £475,000

Halstead

very small horse

Guide Price £425,000

Weeley Heath

very small horse

Guide Price £395,000

Langham

very small horse

Guide Price £185,000

Chesthunt

very small horse

Guide Price £175,000

Great Braxted

very small horse

Guide Price £129,500

Kelvedon Common

very small horse

Guide Price £59,950