Why the result is returning only 1 column instead 2 column?

-- Region Parameters

DECLARE @p0 BigInt = 0

DECLARE @p1 Int = 1

DECLARE @p2 Int = 0

DECLARE @p3 BigInt = 0

DECLARE @p4 Int = 1

DECLARE @p5 Int = 0

DECLARE @p6 Int = 1

DECLARE @p7 BigInt = 2

DECLARE @p8 VarChar(1000) = 'Studio'

DECLARE @p9 Int = 1

DECLARE @p10 BigInt = 2

DECLARE @p11 VarChar(1000) = 'Studio'

-- EndRegion

SELECT [t2].[value] AS [TRAN_S], [t5].[value] AS [PER_FT_S]

FROM (

SELECT COALESCE(CONVERT(Int,[t1].[value]),@p2) AS [value], [t1].[value2], [t1].[LAND_ID], [t1].[TRANSACTION_PRICE], [t1].[FLAT_TYPE]

FROM (

SELECT COALESCE([t0].[TRANSACTION_PRICE],@p0) AS [value], @p1 AS [value2], [t0].[LAND_ID], [t0].[TRANSACTION_PRICE], [t0].[FLAT_TYPE]

FROM [dw_property_detail] AS [t0]

) AS [t1]

) AS [t2]

CROSS JOIN (

SELECT COALESCE(CONVERT(Int,[t4].[value]),@p5) AS [value], [t4].[value2], [t4].[LAND_ID], [t4].[TRANSACTION_PRICE], [t4].[FLAT_TYPE]

FROM (

SELECT COALESCE([t3].[TRANSACTION_PRICE] / [t3].[ACTUAL_SIZE],@p3) AS [value], @p4 AS [value2], [t3].[LAND_ID], [t3].[TRANSACTION_PRICE], [t3].[FLAT_TYPE]

FROM [dw_property_detail] AS [t3]

) AS [t4]

) AS [t5]

WHERE ([t2].[value2] = @p6) AND ([t2].[LAND_ID] = @p7) AND ([t2].[TRANSACTION_PRICE] IS NOT NULL) AND ([t2].[FLAT_TYPE] = @p8) AND ([t5].[value2] = @p9) AND ([t5].[LAND_ID] = @p10) AND ([t5].[TRANSACTION_PRICE] IS NOT NULL) AND ([t5].[FLAT_TYPE] = @p11)