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

Springfield Road

Southwell

Asking Price £315,000
Virtual Tour
Sold STC

Bretton Road

Ravenshead

Asking Price £310,000
Virtual Tour
Sold STC

Chapel Lane

Ravenshead

Offers in Excess £300,000
Sold STC

Oakwood Drive

Ravenshead

Asking Price £299,995

Vernon Crescent

Ravenshead

Asking Price £279,500
Virtual Tour

Becketts Field

Southwell

Asking Price £275,000
Virtual Tour

Farm Close

Bathley

Asking Price £275,000

Buckthorn Drive

Bolsover

Guide Price £270,000

Bluebird Avenue

Ollerton

Asking Price £270,000
Virtual Tour

Broom Road

Calverton

Asking Price £265,000
Virtual Tour

Ashford Drive

Ravenshead

Asking Price £260,000
Sold STC

Landseer Road

Southwell

Asking Price £259,000
Virtual Tour

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