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
Front FOR SALE

Racecourse Road

Southwell

£199,950
Virtual Tour
DSC_0023 SOLD STC

Paddock Close

Calverton

no onward chain £190,000
FRONT SOLD STC

King Street

Southwell

asking price £179,950
Front 1 SOLD STC

Briar Road

New Ollerton

£165,000
DSC_0010 SOLD STC

Radley Terrace

Halam

£160,000
DSC_0014 SOLD STC

Eakring Road

Bilsthorpe

offers over £150,000
DSC_0008 SOLD STC

Skylark Close

Ravenshead

£150,000
DSC_0009 SOLD STC

Winchester Drive

Mansfield Woodhouse

£140,000
Blue Sky Front SOLD STC

Forest Road

Calverton

£129,950
DSC_0013 SOLD STC

Readwald Drive

Rainworth

£80,000
Plot A Outline FOR SALE

Cross Lane

Blidworth

£68,400
Plot B Outline FOR SALE

Cross Lane

Blidworth

£68,400

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