Sugar
SELECT *,CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) Price, CASE WHEN minp.meta_value = 'POA' THEN '1' WHEN minp.meta_value != 'POA' THEN '2' END as `mainsort` FROM wp_posts p inner join wp_postmeta minp on minp.post_id = p.Id and CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) >= CONVERT('',UNSIGNED INTEGER) and minp.meta_key = 'cp_price' inner join wp_term_relationships tr on tr.object_id = p.Id and tr.term_taxonomy_id =10 WHERE ID not in (62293) and post_status='publish' and post_type='post' and (post_title LIKE '%%' or post_content like '%%') ORDER BY `mainsort` , CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) desc
PROPERTY RESULTS
630355_OCL190076_16630355_OCL190076_03630355_OCL190076_05630355_OCL190076_06630355_OCL190076_09630355_OCL190076_08630355_OCL190076_02630355_OCL190076_07630355_OCL190076_10630355_OCL190076_11630355_OCL190076_01

Exeter | Devon

£3,250 pcm 3

An outstanding three bedroom penthouse suite in one of the most prestigious buildings in Exeter, located on Cathedral Green. Private lift access, open plan living/dining/kitchen area and large balcony with panoramic views of the city....

632123_OCL180059_12632123_OCL180059_08632123_OCL180059_06632123_OCL180059_07632123_OCL180059_04632123_OCL180059_03632123_OCL180059_09632123_OCL180059_02632123_OCL180059_10

St Leonards | Exeter

£2,000 pcm 2

A unique single storey house situated in secluded grounds in the heart of sought-after St Leonards. Offering two en suite bedrooms, two studies ideal for home working and a spacious living area with large fitted kitchen/breakfast room....

Let Agreed
628409_OCL210008_19628409_OCL210008_13628409_OCL210008_17628409_OCL210008_09628409_OCL210008_05628409_OCL210008_02628409_OCL210008_03628409_OCL210008_04628409_OCL210008_06628409_OCL210008_08628409_OCL210008_10628409_OCL210008_14628409_OCL210008_15628409_OCL210008_16628409_OCL210008_12628409_OCL210008_18

Exeter

£2,000 pcm 3

UNDER OFFER - A stunning, recently renovated, three bedroom house situated close to the city centre and Exeter University. Property comprises open plan kitchen/living area, utility, study/fourth bedroom and three bathrooms. Enclosed rear garden and d...

Let Agreed
630332_OCL160048_28630332_OCL160048_03630332_OCL160048_25630332_OCL160048_16630332_OCL160048_04630332_OCL160048_05630332_OCL160048_12630332_OCL160048_15630332_OCL160048_14630332_OCL160048_06630332_OCL160048_07630332_OCL160048_08630332_OCL160048_26

Exeter | Devon

£2,000 pcm 4

UNDER OFFER - An outstanding four bedroom unfurnished barn conversion situated in the Broadclyst area, convenient for amenities and major road links. The property benefits from under floor heating downstairs, wood burner, three bathrooms, driveway pa...

Let Agreed
624942_OCL180038_16624942_OCL180038_04624942_OCL180038_20624942_OCL180038_09624942_OCL180038_15624942_OCL180038_08624942_OCL180038_02624942_OCL180038_03624942_OCL180038_07624942_OCL180038_10624942_OCL180038_14624942_OCL180038_11624942_OCL180038_13624942_OCL180038_12624942_OCL180038_19

Exeter

£1,850 pcm 4

UNDER OFFER - A superb four bedroom period cottage in the popular Teign Valley village of Bridford with views of surrounding countryside. The property comprises open plan kitchen/dining room, two reception room, master with en suite and family bathro...

Let Agreed
621955_OCL210002_11621955_OCL210002_07621955_OCL210002_10621955_OCL210002_02621955_OCL210002_01621955_OCL210002_03621955_OCL210002_08621955_OCL210002_04621955_OCL210002_06621955_OCL210002_09621955_OCL210002_14621955_OCL210002_05

Exeter

£1,550 pcm 3

UNDER OFFER - Well presented semi-detached family home located in a very desirable area in St Leonards. Property comprises of spacious sitting/dining room, kitchen, three bedrooms, bathroom. Benefiting from rear garden, shed, driveway and a single ga...

614340_OCL200135_12614340_OCL200135_09614340_OCL200135_06614340_OCL200135_02614340_OCL200135_13614340_OCL200135_11614340_OCL200135_04614340_OCL200135_07614340_OCL200135_03614340_OCL200135_01

Exeter

£1,300 pcm 1

An immaculate one-bed apartment in Trinity Court, Exeter's most fashionable apartment building located in Southernhay Gardens. Entrance Hall, utility cupboard, bathroom, open-plan Kitchen/Dining/Sitting Room. No parking....

Let Agreed
606792_OCL200127_07606792_OCL200127_04606792_OCL200127_02606792_OCL200127_05606792_OCL200127_06606792_OCL200127_03606792_OCL200127_01

Castle Street | Exeter

£1,250 pcm 2

UNDER OFFER. Grade II listed building offering a two bedroom duplex apartment in the heart of Exeter. Open plan living/kitchen, family bathroom, bedroom with en suite and roof terrace. Secure parking available....

Let Agreed
619373_OCL200147_08619373_OCL200147_02619373_OCL200147_10619373_OCL200147_07619373_OCL200147_04619373_OCL200147_01619373_OCL200147_03619373_OCL200147_06619373_OCL200147_05619373_OCL200147_11619373_OCL200147_09619373_OCL200147_12

Kennford | Exeter

£1,200 pcm 3

UNDER OFFER -charming three bedroom detached house situated in the popular village of Kennford with easy access into Exeter City and to the M5. The property comprises kitchen, sitting room, downstairs cloakroom, bedroom one with en suite and family ...

Picture No. 38Sitting RoomKitchenDining RoomBedroom 1GardenBedroom 2Bed 3/StudyBathroom

St Thomas

£925 pcm 3

Three bedroom semi-detached home situated on the outskirts of the city. Entrance hall into the sitting/dining area, through to a modern, fitted kitchen. Family bathroom. Garage and driveway parking....

1 to 10 of 16 Properties Property To Let/Rent in Exeter, Devon - Wilkinson Grant