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

Ricket Lane

Blidworth

offers in excess of £1,200,000
WhatsApp Image 2022-09-28 at 11 FOR SALE

Chapel Lane

Farnsfield

£995,000
DSC_0089 FOR SALE

Willoughby Court

Norwell

£800,000
Virtual Tour
Part Exchange Considered FOR SALE

Plot 3 Kighill Lane

Ravenshead

£780,000
Plot 2 FOR SALE

Plot 2 Kighill Lane

Ravenshead

£775,000
DSC_0152 FOR SALE

Goodwins Court

Rolleston

offers over £759,500
Virtual Tour
Front FOR SALE

Greaves Lane

Edingley

£750,000
Photo_6553876_DJI_276_jpg_4205839_0_2021920125812_ FOR SALE

Galley Hill Road

Southwell

£710,000
Front 1 FOR SALE

Old Great North Road

Sutton on Trent

offers over £700,000
Virtual Tour
DSC_0041 FOR SALE

Sheepwalk Lane

Ravenshead

£655,000
Virtual Tour
DSC_0047 FOR SALE

Halloughton Road

Southwell

£649,950
Virtual Tour
front SOLD STC

The Ropewalk

Southwell

offers in excess of £600,000
Virtual Tour

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