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

Near Colchester

very small horse

Guide Price £4,800,000

Woodham Ferrers

very small horse

Guide Price £2,950,000

South Weald

very small horse

Guide Price £2,000,000

Finchingfield

very small horse

Price on Application

Brentwood

very small horse

Price on Application

Halstead

very small horse

Guide Price £1,650,000

Little Warley

very small horse

Guide Price £1,650,000

High Ongar

very small horse

Guide Price £1,595,000

Finchingfield

very small horse

Offers in excess of £1,500,000

Barling Magna, Rochford

very small horse

Guide Price £1,500,000

Near Stock

very small horse

Price on Application

Felsted

very small horse

Guide Price £1,395,000

Finchingfield

very small horse

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

Great Dunmow

very small horse

Guide Price £1,195,000

Brentwood

very small horse

Guide Price £1,195,000

Gosfield, Halstead

very small horse

Guide Price £1,175,000

Nr Epping

very small horse

Guide Price £1,050,000

Danbury

very small horse

Guide Price £1,025,000

Purleigh

very small horse

Offers in excess of £1,000,000

Alresford

very small horse

Guide Price £950,000

Tiptree

very small horse

Guide Price £895,000

Burnham On Crouch

very small horse

Guide Price £875,000

Hatfield Peverel

very small horse

Guide Price £875,000

Maldon

very small horse

Guide Price £875,000

Great Tey, Colchester

very small horse

Guide Price £850,000

Fordham

very small horse

Guide Price £850,000

Moorhall Lane, Danbury

very small horse

Guide Price £850,000

Gestingthorpe, Nr Halstead

very small horse

Guide Price £795,000

Boxted

very small horse

Guide Price £705,000

Blackmore

very small horse

Guide Price £699,000

Newbourne, Nr Woodbridge

very small horse

Guide Price £695,000

Finchingfield

very small horse

Offers in Excess of £690,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

Halstead

very small horse

Guide Price £625,000

Little Totham

very small horse

Guide Price £600,000

Bradwell On Sea

very small horse

Guide Price £600,000

Southminster

very small horse

Guide Price £599,950

Fingringhoe, Colchester

very small horse

Guide Price £595,000

Witham

very small horse

Guide Price £595,000

Runwell

very small horse

Guide Price £595,000

Southminster

very small horse

Guide Price £580,000

Bocking

very small horse

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

Newton Green

very small horse

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

Mayland

very small horse

Offer in the Region £425,000

Pleshey

very small horse

Guide Price £415,000

Woodham Moritmer

very small horse

Offers in Excess of £400,000

Willingale - AMENITY LAND

very small horse

Guide Price £250,000

Brentwood

very small horse

Guide Price £250,000

Danbury

very small horse

Guide Price £155,000