Skip to content
Mapviewselect p1.*,p2.* from wp_property_propertypilot as p1 LEFT join wp_property_propertypilot_meta_options as p2 on p1.property_id = p2.property_id
where p1.property_status = '1' and property_name = 'status' and (p2.property_value NOT IN('Let','Sold','Sold STC')) and p1.property_leasehold > 0 GROUP By p1.property_id ORDER BY
CASE WHEN (p2.property_value in ('To Let','For Sale/To Let','For Sale')) THEN 1
WHEN (p2.property_value in ('Under Offer')) THEN 2
ELSE 3 END, p1.id desc LIMIT 0, 12
-
To Let
Manor House 4th Floor 224-236
£45,000 Per Annum Exclusive
B1
2543 Sqft 236.24 SqM
-
To Let
26 Burney Street Greenwich
£9,000 Per Annum Inclusive
B1
263 Sqft 24.43 SqM
-
To Let
25 Hare Street London SE18 6NE
£52,500 Per Annum Exclusive
A1,A3
3007 Sqft 279.35 SqM
-
To Let
7 Melbourne Grove London SE22
£20,000 Per Annum Exclusive
A3
373.20 Sqft 34.67 SqM
-
To Let
47 Old Woolwich Road Greenwich
£150,000 Per Annum Exclusive
A1
10800 Sqft 1003.32 SqM
-
To Let
14b London Road Forest Hill
£6,200 Per Annum Exclusive
B1
622 Sqft 57.78 SqM
-
For Sale/To Let
16 Melbourne Grove East Dulwich
£27,000 Per Annum Exclusive £350,000 Freehold
A1
520 Sqft 48.31 SqM
-
To Let
Unit 210 Westfield Street
£57,300 Per Annum Exclusive
B1
4092 Sqft 380.15 SqM
-
To Let
7 Lordship Lane East Dulwich
£45,000 Per Annum Exclusive
A1
595 Sqft 55.28 SqM
-
To Let
207-215 High Street Orpington
£76,500 Per Annum Exclusive
B1
6365 Sqft 591.31 SqM
-
To Let
Unit 3 Meridian Trading Estate
£160,000 Per Annum Exclusive
B1
10752 Sqft 998.86 SqM
-
To Let
2B Joyce Dawson Way Thamesmead
£65,000 Per Annum Exclusive
A1
4948 Sqft 459.67 SqM