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 = 'reapit_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
Sold STC

Chatsworth Avenue

Southwell

Offers Over £530,000
Virtual Tour

Chestnut Close

Harlow Wood

Asking Price £525,000
Sold STC

Halloughton Road

Southwell

Offers in Excess £525,000
Virtual Tour
Sold STC

Gravelly Lane

Fiskerton

Asking Price £525,000
Virtual Tour
Sold STC

The Close

Averham

Asking Price £525,000
Virtual Tour

Woodland Rise

Ravenshead

Guide Price £500,000
Virtual Tour

Ridgewood Grove

Ravenshead

Asking Price £499,995
Sold STC

Sheepwalk Lane

Ravenshead

Asking Price £475,000
Virtual Tour

Halam Road

Southwell

Asking Price £470,000

Cheriton Drive

Ravenshead

Asking Price £455,000
Virtual Tour
Sold STC

Manor House Close

Lowdham

Asking Price £450,000
Virtual Tour

Heather Lane

Ravenshead

Asking Price £450,000

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