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

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....

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

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

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

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

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...

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

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

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 ...

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....