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

Woodham Ferrers

very small horse

Guide Price £2,950,000

Sheering, Herts Essex Borders

very small horse

Price on Application

Stisted

very small horse

Guide Price £2,150,000

South Weald

very small horse

Guide Price £2,000,000

Brentwood

very small horse

Price on Application

Finchingfield

very small horse

Price on Application

Little Leighs

very small horse

Guide Price £1,750,000

Old Harlow

very small horse

Guide Price £1,700,000

Little Warley

very small horse

Guide Price £1,650,000

Halstead

very small horse

Guide Price £1,650,000

Billericay

very small horse

Guide Price £1,650,000

High Ongar

very small horse

Guide Price £1,595,000

Barling Magna, Rochford

very small horse

Guide Price £1,500,000

Finchingfield

very small horse

Offers in excess of £1,500,000

Near Stock

very small horse

Price on Application

Upminster

very small horse

Guide Price £1,495,000

Finchingfield

very small horse

Guide price £1,350,000

Finchingfield

very small horse

Guide Price £1,350,000

Rettendon Common

very small horse

Guide Price £1,325,000

Asheldham

very small horse

Guide Price £1,250,000

Latchingdon

very small horse

Price on Application

Little Totham

very small horse

Price on Application

Brentwood

very small horse

Guide Price £1,195,000

Nr Epping

very small horse

Guide Price £1,050,000

Danbury

very small horse

Guide Price £1,025,000

Gosfield, Halstead

very small horse

Offers in excess of £1,000,000

North Fambridge

very small horse

offers in excess of £995,000

North Weald

very small horse

Guide Price £995,000

Alresford

very small horse

Guide Price £950,000

Burnham On Crouch

very small horse

Guide Price £875,000

Maldon

very small horse

Guide Price £875,000

Downham

very small horse

Guide Price £850,000

Great Tey, Colchester

very small horse

Guide Price £850,000

Fordham

very small horse

Guide Price £850,000

Soutminister

very small horse

Guide Price £850,000

Tiptree

very small horse

Guide Price £835,000

Gestingthorpe, Nr Halstead

very small horse

Guide Price £795,000

Tiptree Heath

very small horse

Offers in excess of £780,000

Chelmsford

very small horse

Guide Price £739,500

Boxted

very small horse

Guide Price £705,000

Wickford

very small horse

Guide Price £699,000

Finchingfield

very small horse

Offers in Excess of £690,000

Peldon Common

very small horse

Guide Price £685,000

Burnham On Crouch

very small horse

Guide Price £675,000

Little Braxted

very small horse

Guide Price £665,000

Fingringhoe

very small horse

Guide Price £639,995

Althorne

very small horse

Guide Price £625,000

Chelmsford

very small horse

Guide Price £625,000

Little Totham

very small horse

Guide Price £600,000

Southminster

very small horse

Guide Price £599,950

Fingringhoe, Colchester

very small horse

Guide Price £595,000

Runwell

very small horse

Guide Price £595,000

Nr Wickham Bishops

very small horse

Guide Price £595,000

Bradwell On Sea

very small horse

Guide Price £585,000

Wethersfield

very small horse

Guide Price £565,000

Battlesbridge

very small horse

Guide Price £565,000

Tolleshunt Knights

very small horse

Guide Price £550,000

Bradwell On Sea

very small horse

Guide Price £539,500

Latchingdon

very small horse

Guide Price £500,000

Great Maplestead

very small horse

Guide Price £475,000

Colchester

very small horse

Guide Price £450,000

High Roding

very small horse

Guide Price £439,500

Burnham On Crouch

very small horse

Guide Price £435,000

Langford

very small horse

Guide Price £425,000

Latchingdon

very small horse

Guide Price £425,000

Pleshey

very small horse

Guide Price £415,000

Woodham Moritmer

very small horse

Offers in Excess of £400,000

Great Oakley

very small horse

Guide Price £295,000

Near Gosfield

very small horse

Guide Price £180,000

Danbury

very small horse

Guide Price £155,000

Willingale - AMENITY LAND

very small horse

Guide Price £150,000