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 4HX' order by fulladdress
Job

1 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 339,000
  • Detached house
Job

10 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 348,000
  • Freehold Detached property
Job

11 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 318,000
  • Freehold Detached house
Job

12 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 342,000
  • Freehold Detached house
Job

14 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 358,000
Job

15 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 365,000
Job

16 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 344,000
  • Freehold Bungalow property
Job

2 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 364,000
  • Freehold Detached house
Job

3 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 346,000
  • Freehold Detached house
Job

4 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 386,000
  • Freehold Detached property
Job

5 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 412,000
  • Freehold Detached house
Job

6 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 399,000
  • Freehold Detached house
Job

7 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 388,000
  • Freehold Detached house
Job

8 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 365,000
  • Freehold Detached house
Job

9 THE PIPPINS NEWCASTLE UNDER LYME NEWCASTLE ST5 4HX

ST5 4HX
  • 315,000
  • Freehold Detached house

00 m+

Properties Available

00 m+

Valuations

00 +

Data Points

00 m+

Planning Applications