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

Panfield

very small horse

Guide Price £1,950,000

Horsemanside, Navestock

very small horse

Guide Price £1,895,000

Brettenham

very small horse

Guide Price £1,895,000

Little Baddow

very small horse

Guide Price £1,695,000

Pleshey

very small horse

Guide Price £1,675,000

Blackmore End

very small horse

Guide Price £1,650,000

Nr Stock

very small horse

Price on Application

White Colne

very small horse

Guide Price £1,595,000

Welwyn

very small horse

Offers over £1,500,000

Rettendon Common

very small horse

Price on Application

Burnham On Crouch

very small horse

Guide Price £1,495,000

Greenstead Green, Halstead

very small horse

Guide Price £1,375,000

Tillingham

very small horse

Offers in Excess of £1,250,000

Althorne

very small horse

Guide Price £1,195,000

Althorne

very small horse

Guide Price £1,100,000

Burnham On Crouch

very small horse

Offers in excess of £1,000,000

North Fambridge

very small horse

Guide Price £995,000

Ingatestone

very small horse

Guide Price £985,000

Great Holland

very small horse

Guide Price £950,000

Orsett

very small horse

Guide Price £895,000

Billericay

very small horse

Guide Price £869,995

Althorne

very small horse

Guide Price £860,000

Easthorpe

very small horse

Guide Price £850,000

Sible Hedingham

very small horse

Guide Price £845,000

Burnham On Crouch

very small horse

£835,000

Whepstead

very small horse

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

Great Holland

very small horse

£750,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

Rettendon Common

very small horse

Price on Application

Peldon

very small horse

Offers in excess of £700,000

Alresford

very small horse

Guide Price £695,000

Althorne

very small horse

Guide Price £675,000

Coggeshall

very small horse

Offers in excess of £660,000

Stanford Le Hope

very small horse

Guide Price £650,000

Great Maplestead

very small horse

Guide Price £629,500

Althorne

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

Lindsey

very small horse

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

Colchester

very small horse

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

Stratford St Mary

very small horse

Guide Price £75,000

Kelvedon Common

very small horse

Guide Price £59,950