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
Unit 4 Thistlebrook Industrial
£70,000 Per Annum Exclusive
B8
7459 Sqft 692.90 SqM
-
To Let
4 College Approach Greenwich
£20,000 Per Annum Exclusive
A1
638 Sqft 59.27 SqM
-
To Let
Unit 210 Westfield Street
£57,300 Per Annum Exclusive
B1
4092 Sqft 380.10 SqM
-
To Let
Unit 3 Hopyard Studios Lovibond
£17,400 Per Annum Exclusive
B1
822 Sqft 76.36 SqM
-
To Let
Unit 5 Dulwich Business Centre
£37,500 Per Annum Exclusive
B1
3249 Sqft 301.80 SqM
-
To Let
67 Lordship Lane East Dulwich
£47,000 Per Annum Exclusive
A1
768 Sqft 71.35 SqM
-
To Let
7 Lordship Lane East Dulwich
£50,000 Per Annum Exclusive
A1
595 Sqft 55.28 SqM
-
To Let
First Floor 48-54 Denmark Hill
£21,151 Per Annum Exclusive
B1
1479 Sqft 137.40 SqM
-
To Let
9 Nevada Street Greenwich London
£35,000 Per Annum Exclusive
A1,A3
495 Sqft 45.99 SqM
-
To Let
139 Woolwich Road Greenwich
£30,000 Per Annum Exclusive
A1,A3
1134 Sqft 105.30 SqM
-
To Let
207-215 Hight Street Orpington
£76,500 Per Annum Exclusive
B1
6365 Sqft 591.30 SqM
-
To Let
Unit 3 Meridian Trading Estate
£160,000 Per Annum Exclusive
B1
10752 Sqft 998.90 SqM