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

South Weald

very small horse

Guide Price £2,000,000

Panfield

very small horse

Guide Price £1,950,000

Old Harlow

very small horse

Guide Price £1,700,000

Little Warley

very small horse

Guide Price £1,650,000

Billericay

very small horse

Guide Price £1,650,000

Little Leighs

very small horse

Guide Price £1,600,000

High Ongar

very small horse

Guide Price £1,595,000

Barling Magna, Rochford

very small horse

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

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

Halstead

very small horse

Guide Price £1,195,000

Nr Epping

very small horse

Guide Price £1,050,000

Gosfield, Halstead

very small horse

Offers in excess of £1,000,000

Cold Norton

very small horse

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

Brentwood

very small horse

Offers in Excess of £900,000

Cold Norton

very small horse

Guide Price £895,000

Billericay

very small horse

Guide Price £895,000

Great Tey, Colchester

very small horse

Guide Price £850,000

Downham

very small horse

Guide Price £850,000

Soutminister

very small horse

Guide Price £850,000

Gestingthorpe, Nr Halstead

very small horse

Guide Price £795,000

Tiptree Heath

very small horse

Guide Price £780,000

Great Wigborough

very small horse

Guide Price £739,500

Billericay

very small horse

Guide Price £725,000

Billericay

very small horse

Guide Price £725,000

Creeting St Mary

very small horse

Guide Price £689,500

Peldon Common

very small horse

Guide Price £685,000

Tiptree

very small horse

Offers In Excess Of £670,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

Nr Wickham Bishops

very small horse

Guide Price £595,000

Wickford

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

Tolleshunt Knights

very small horse

Guide Price £550,000

Latchingdon

very small horse

Guide Price £500,000

Leavenheath

very small horse

Guide Price £495,000

Great Maplestead

very small horse

Guide Price £475,000

Colchester

very small horse

Guide Price £450,000

Frinton On Sea

very small horse

Guide Price £450,000

Langford

very small horse

Guide Price £425,000

Latchingdon

very small horse

Guide Price £425,000

Great Oakley

very small horse

Guide Price £295,000

Willingale - AMENITY LAND

very small horse

Guide Price £150,000