SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NR4 7SJ' order by fulladdress
NR4 7SJ - 264,000
- Freehold Semi-detached house
NR4 7SJ - 265,000
- Freehold Semi-detached house
NR4 7SJ - 368,000
- Freehold Detached house
NR4 7SJ - 374,000
- Freehold Detached house
NR4 7SJ - 385,000
- Freehold Semi-detached house
NR4 7SJ - 90,000
- Leasehold Purpose built flat
NR4 7SJ - 387,000
- Freehold Semi-detached house
NR4 7SJ - 369,000
- Freehold Detached house
NR4 7SJ - 497,000
- Freehold Detached house
NR4 7SJ - 119,000
- Leasehold Purpose built flat
NR4 7SJ - 498,000
- Freehold Detached house
NR4 7SJ - 556,000
- Freehold Detached house
NR4 7SJ - 567,000
- Freehold Detached house
NR4 7SJ - 494,000
- Freehold Detached house
NR4 7SJ - 474,000
- Freehold Detached house
NR4 7SJ - 525,000
- Freehold Detached house
NR4 7SJ - 576,000
- Freehold Detached house
NR4 7SJ - 711,000
- Freehold Detached house
NR4 7SJ - 443,000
- Freehold Detached house
NR4 7SJ - 116,000
- Leasehold Purpose built flat
NR4 7SJ - 471,000
- Freehold Detached house
NR4 7SJ - 726,000
- Freehold Detached house
NR4 7SJ - 568,000
- Freehold Detached house
NR4 7SJ - 652,000
- Freehold Detached house
NR4 7SJ - 485,000
- Freehold Detached house
NR4 7SJ - 148,000
- Leasehold Purpose built flat
NR4 7SJ - 472,000
- Freehold Detached house
NR4 7SJ - 480,000
- Freehold Detached house
NR4 7SJ - 500,000
- Freehold Detached house
NR4 7SJ - 593,000
- Freehold Detached house
NR4 7SJ - 121,000
- Leasehold Purpose built flat
NR4 7SJ - 521,000
- Freehold Detached house
NR4 7SJ - 373,000
- Freehold Detached house
