Sugar
SELECT *,CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) Price 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 inner join wp_postmeta minpp on minpp.post_id = p.Id and minpp.meta_key = 'cp_price_qualifier' WHERE post_status='publish' and post_type='post' and (post_title LIKE '%%' or post_content like '%%') ORDER BY CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) desc
Settle V1 Yellow Brick FOR SALE

Brierley Heath, Brand Lane

Stanton Hill

£349,995
front 1 FOR SALE

Woodland Drive

Southwell

£349,950
Virtual Tour
DSC_0043 FOR SALE

Lower Kirklington Road

Southwell

£342,500
Virtual Tour
DSC_0039 FOR SALE

Belle Vue Gardens

Blidworth

£330,000
DSC_0037 FOR SALE

Chapel Fields

Ravenshead

£325,000
DSC_0032 FOR SALE

Swallow Crescent

Ravenshead

£325,000
Windsor V0  Red Brick FOR SALE

Brierley Heath, Brand Lane

Stanton Hill

£322,495
DSC_0030 SOLD STC

Winster Avenue

Ravenshead

£320,000
DSC_0016 SOLD STC

Chapel Lane

Ravenshead

offers in excess of £300,000
DSC_0079 SOLD STC

De Vere Gardens

Woodthorpe

guide price £300,000
DSC_0040 FOR SALE

Rise Park Road

Nottingham

£299,995
Birkwith Red Brick FOR SALE

Brierley Heath, Brand Lane

Stanton Hill

£299,995

Your privacy and our use of cookies Read more about cookies and learn how to disable them.