Selected Property

SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='ST5 2DN' order by fulladdress
Job

1 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 127,000
  • Freehold End terrace house
Job

10 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 122,000
  • Freehold Terrace property
Job

11 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 149,000
  • Freehold Mid terrace house
Job

12 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 137,000
  • Freehold Mid terrace house
Job

13 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 142,000
  • Freehold Terrace property
Job

14 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 130,000
  • Freehold Mid terrace house
Job

15 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 132,000
  • Freehold Terrace property
Job

16 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 101,000
  • Freehold Mid terrace house
Job

17 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 136,000
  • Freehold Mid terrace house
Job

18 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 127,000
  • Terrace property
Job

19 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 139,000
  • Freehold Mid terrace house
Job

2 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 141,000
  • Freehold End terrace house
Job

20 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 133,000
  • Freehold Mid terrace house
Job

21 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 134,000
  • Freehold Mid terrace house
Job

22 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 131,000
Job

23 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 136,000
  • Freehold Mid terrace house
Job

24 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 136,000
  • Freehold Mid terrace house
Job

25 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 135,000
  • Freehold End terrace house
Job

26 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 130,000
  • Freehold Mid terrace house
Job

28 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 134,000
Job

3 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 129,000
  • Freehold Mid terrace house
Job

30 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 124,000
  • Freehold Terrace property
Job

32 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 138,000
  • Freehold Terrace property
Job

4 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 167,000
  • Freehold Mid terrace house
Job

5 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 140,000
  • Freehold Terrace property
Job

6 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 127,000
  • Freehold Mid terrace house
Job

7 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 137,000
Job

8 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 129,000
  • Freehold Terrace property
Job

9 MELLARD STREET NEWCASTLE UNDER LYME NEWCASTLE ST5 2DN

ST5 2DN
  • 144,000
  • Freehold End terrace house

00 m+

Properties Available

00 m+

Valuations

00 +

Data Points

00 m+

Planning Applications