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 9PX' order by fulladdress
Job

1 FAIRLAWNS NEWCASTLE UNDER LYME NEWCASTLE ST5 9PX

ST5 9PX
  • 269,000
  • Freehold Detached house
Job

2 FAIRLAWNS NEWCASTLE UNDER LYME NEWCASTLE ST5 9PX

ST5 9PX
  • 268,000
  • Freehold Detached house
Job

3 FAIRLAWNS NEWCASTLE UNDER LYME NEWCASTLE ST5 9PX

ST5 9PX
  • 267,000
  • Freehold Detached house
Job

4 FAIRLAWNS NEWCASTLE UNDER LYME NEWCASTLE ST5 9PX

ST5 9PX
  • 266,000
  • Freehold Detached house
Job

5 FAIRLAWNS NEWCASTLE UNDER LYME NEWCASTLE ST5 9PX

ST5 9PX
  • 238,000
  • Freehold Detached house
Job

6 FAIRLAWNS NEWCASTLE UNDER LYME NEWCASTLE ST5 9PX

ST5 9PX
  • 252,000
Job

7 FAIRLAWNS NEWCASTLE UNDER LYME NEWCASTLE ST5 9PX

ST5 9PX
  • 232,000
  • Freehold Detached house
Job

8 FAIRLAWNS NEWCASTLE UNDER LYME NEWCASTLE ST5 9PX

ST5 9PX
  • 249,000

00 m+

Properties Available

00 m+

Valuations

00 +

Data Points

00 m+

Planning Applications