SQL Query error - has more columns than were specified in the column list

I've joined a table with a select statement that is has a sum on marketvalue field. Without the sum the query returns multiple rows for marketvalue. I just need the total in a field. I'm getting the following error:

Msg 8158, Level 16, State 1, Line 1
'mwlRealestate20' has more columns than were specified in the column list.

Any ideas?

SELECT mwlLoanApp.LoanNumber AS [Loan Number],
	mwlBorrower3.Fullname AS [Borrower Name],
	mwlLoanApp.AppNum AS [App Num],
	mwlRealestate20.Total as [Borr REO Market Value]
 

FROM
	mwlLoanApp (NOLOCK)
	LEFT JOIN mwlBorrower AS mwlBorrower3 (NOLOCK) ON (mwlLoanApp.ID=mwlBorrower3.LoanApp_ID AND mwlBorrower3.SequenceNum=1)
	LEFT JOIN mwlBorrower AS mwlBorrower6 (NOLOCK) ON (mwlLoanApp.ID=mwlBorrower6.LoanApp_ID AND mwlBorrower6.SequenceNum=2)
    Left Join (select sum(marketvalue) as Total, borrower_id from mwlRealEstate group by borrower_id) as mwlRealestate20 (NOLOCK) on (mwlborrower3.id=mwlRealEstate20.borrower_id)

Select allOpen in new window