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

Dunsil Row

Mansfield Road

Asking Price £195,000
Virtual Tour

Main Street

Blidworth

Guide Price £180,000
Virtual Tour
Sold STC

Greet Lily Mill

Station Road

Asking Price £179,950
Virtual Tour
Sold STC

Gainsborough Road

Winthorpe

Asking Price £175,000
Virtual Tour

Greet Lily Mill

Southwell

Asking Price £174,950
Virtual Tour

Hopkin Court

Mapperley Plains

Asking Price £159,950
Virtual Tour
Sold STC

Skylark Close

Ravenshead

Offers Over £150,000
Sold STC

Swallow Crescent

Ravenshead

Asking Price £150,000
Virtual Tour
Sold STC

Greet Lily Mill

Station Road

Asking Price £150,000
Virtual Tour
Sold STC

Becketts Field

Southwell

Asking Price £150,000
Virtual Tour

Victoria Street

Hucknall

Guide Price £150,000
Virtual Tour
Sold STC

Archway Cottages

Southwell

Asking Price £145,000

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