Commitments and Contingencies - Summary of Partnership's Total and Remaining Commitments (Details)	12 Months Ended
	Dec. 31, 2022 USD ($)
Commitments And Other Guarantees [Line Items]
Total Initial Commitment	$ 645,657,972
Remaining Commitment as of December 31, 2022	$ 428,319,586
The Residency At Empire [Member] | Series BB-3 [Member]
Commitments And Other Guarantees [Line Items]
Maturity Date	2029-12
Interest Rate	6.00%
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member]
Commitments And Other Guarantees [Line Items]
Total Initial Commitment	$ 177,000,000
Remaining Commitment as of December 31, 2022	$ 142,321,563
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency At Mayer [Member] | Series A [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-10
Maturity Date	2039-04
Total Initial Commitment	$ 29,500,000
Remaining Commitment as of December 31, 2022	$ 3,500,000
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency At Mayer [Member] | Series A [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.60%	[1]
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency At Mayer [Member] | Series A T Mortgage [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-10
Maturity Date	2024-04	[2]
Total Initial Commitment	$ 12,500,000
Remaining Commitment as of December 31, 2022	$ 11,500,000
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency At Mayer [Member] | Series A T Mortgage [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.70%	[1]
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | Meadow Valley [Member] | Series A [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-12
Maturity Date	2029-12
Interest Rate	6.25%	[1]
Total Initial Commitment	$ 44,000,000
Remaining Commitment as of December 31, 2022	$ 39,276,563
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency at the Entrepreneur [Member] | Series J-4 [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-04
Maturity Date	2040-03
Total Initial Commitment	$ 16,420,000
Remaining Commitment as of December 31, 2022	$ 16,420,000
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency at the Entrepreneur [Member] | Series J-4 [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.60%	[1],[3]
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency at the Entrepreneur [Member] | Series J-3 [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-04
Maturity Date	2040-03
Interest Rate	6.00%	[1]
Total Initial Commitment	$ 26,080,000
Remaining Commitment as of December 31, 2022	$ 22,180,000
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency at the Entrepreneur [Member] | Series J-T [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-04
Maturity Date	2025-04	[2]
Total Initial Commitment	$ 13,000,000
Remaining Commitment as of December 31, 2022	$ 12,000,000
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency at the Entrepreneur [Member] | Series J-T [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.65%	[1]
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency At Empire [Member] | Series BB-3 [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-12
Maturity Date	2040-12
Interest Rate	6.45%	[1],[4]
Total Initial Commitment	$ 14,000,000
Remaining Commitment as of December 31, 2022	$ 13,945,000
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency At Empire [Member] | Series BB-4 [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-12
Maturity Date	2040-12
Interest Rate	6.45%	[1],[5]
Total Initial Commitment	$ 47,000,000
Remaining Commitment as of December 31, 2022	$ 47,000,000
Mortgage Revenue Bonds and Taxable Mortgage Revenue Bonds [Member] | The Residency At Empire [Member] | Series BB-T Mortgage [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-12
Maturity Date	2025-12	[2]
Interest Rate	7.45%	[1]
Total Initial Commitment	$ 9,404,500
Remaining Commitment as of December 31, 2022	8,404,500
Taxable Mortgage Revenue Bonds [Member]
Commitments And Other Guarantees [Line Items]
Total Initial Commitment	34,904,500
Remaining Commitment as of December 31, 2022	31,904,500
Governmental Issuer Loans and Taxable Governmental Issuer Loans [Member]
Commitments And Other Guarantees [Line Items]
Total Initial Commitment	182,057,835
Remaining Commitment as of December 31, 2022	$ 103,873,023
Governmental Issuer Loans and Taxable Governmental Issuer Loans [Member] | Osprey Village [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-07
Maturity Date	2024-08	[2]
Total Initial Commitment	$ 60,000,000
Remaining Commitment as of December 31, 2022	$ 20,106,960
Governmental Issuer Loans and Taxable Governmental Issuer Loans [Member] | Osprey Village [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.07%	[1]
Governmental Issuer Loans and Taxable Governmental Issuer Loans [Member] | Willow Place Apartments [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-09
Maturity Date	2024-10	[2]
Total Initial Commitment	$ 25,000,000
Remaining Commitment as of December 31, 2022	$ 7,645,528
Governmental Issuer Loans and Taxable Governmental Issuer Loans [Member] | Willow Place Apartments [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.30%	[1]
Governmental Issuer Loans and Taxable Governmental Issuer Loans [Member] | Hope on Avalon [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-01
Maturity Date	2023-08	[2]
Total Initial Commitment	$ 10,573,000
Remaining Commitment as of December 31, 2022	$ 5,573,000
Governmental Issuer Loans and Taxable Governmental Issuer Loans [Member] | Hope on Avalon [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.55%	[1]
Governmental Issuer Loans and Taxable Governmental Issuer Loans [Member] | Poppy Grove I [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-09
Maturity Date	2025-04	[2]
Interest Rate	6.78%	[1]
Total Initial Commitment	$ 35,688,328
Remaining Commitment as of December 31, 2022	$ 27,842,328
Governmental Issuer Loans and Taxable Governmental Issuer Loans [Member] | Poppy Grove II [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-09
Maturity Date	2025-04	[2]
Interest Rate	6.78%	[1]
Total Initial Commitment	$ 22,250,000
Remaining Commitment as of December 31, 2022	$ 17,708,700
Governmental Issuer Loans and Taxable Governmental Issuer Loans [Member] | Poppy Grove III [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-09
Maturity Date	2025-04	[2]
Interest Rate	6.78%	[1]
Total Initial Commitment	$ 39,119,507
Remaining Commitment as of December 31, 2022	30,569,507
Governmental Issuer Loans [Member] | Poppy Grove I [Member]
Commitments And Other Guarantees [Line Items]
Total Initial Commitment	21.2
Taxable Governmental Issuer Loans [Member]
Commitments And Other Guarantees [Line Items]
Total Initial Commitment	67,152,465
Remaining Commitment as of December 31, 2022	$ 59,152,465
Taxable Governmental Issuer Loans [Member] | Poppy Grove I [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-09
Maturity Date	2025-04	[2]
Interest Rate	6.78%	[1]
Total Initial Commitment	$ 21,157,672
Remaining Commitment as of December 31, 2022	$ 20,157,672
Taxable Governmental Issuer Loans [Member] | Poppy Grove II [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-09
Maturity Date	2025-04	[2]
Interest Rate	6.78%	[1]
Total Initial Commitment	$ 10,941,300
Remaining Commitment as of December 31, 2022	$ 9,941,300
Taxable Governmental Issuer Loans [Member] | Poppy Grove III [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-09
Maturity Date	2025-04	[2]
Interest Rate	6.78%	[1]
Total Initial Commitment	$ 24,480,493
Remaining Commitment as of December 31, 2022	$ 23,480,493
Property Loans [Member] | Osprey Village [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-07
Maturity Date	2024-08	[2]
Total Initial Commitment	$ 25,500,000
Remaining Commitment as of December 31, 2022	$ 24,500,000
Property Loans [Member] | Osprey Village [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.07%	[1]
Property Loans [Member] | Willow Place Apartments [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-09
Maturity Date	2024-10	[2]
Total Initial Commitment	$ 21,351,328
Remaining Commitment as of December 31, 2022	$ 20,351,328
Property Loans [Member] | Willow Place Apartments [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.30%	[1]
Property Loans [Member] | Hilltop at Signal Hills [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-01
Maturity Date	2023-08	[2]
Total Initial Commitment	$ 21,197,939
Remaining Commitment as of December 31, 2022	$ 1,479,605
Property Loans [Member] | Hilltop at Signal Hills [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.07%	[1]
Property Loans [Member] | Legacy Commons at Signal Hills [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-01
Maturity Date	2024-02	[2]
Total Initial Commitment	$ 32,233,972
Remaining Commitment as of December 31, 2022	$ 2,567,067
Property Loans [Member] | Legacy Commons at Signal Hills [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.07%	[1]
Property Loans [Member] | Oasis at Twin Lakes [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2020-07
Maturity Date	2023-08	[2]
Total Initial Commitment	$ 27,704,180
Remaining Commitment as of December 31, 2022	$ 3,685,523
Property Loans [Member] | Oasis at Twin Lakes [Member] | LIBOR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	2.50%	[1]
Property Loans [Member] | Magnolia Heights [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-06
Maturity Date	2024-07	[2]
Total Initial Commitment	$ 10,300,000
Remaining Commitment as of December 31, 2022	$ 4,111,399
Property Loans [Member] | Magnolia Heights [Member] | SOFR [Member]
Commitments And Other Guarantees [Line Items]
Interest Rate	3.85%	[1]
Joint Venture Investments [Member]
Commitments And Other Guarantees [Line Items]
Total Initial Commitment	$ 42,355,753
Remaining Commitment as of December 31, 2022	$ 30,473,113
Joint Venture Investments [Member] | Vantage At San Marcos [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2020-11	[6],[7]
Total Initial Commitment	$ 9,914,529	[6],[7]
Remaining Commitment as of December 31, 2022	$ 8,943,914	[6],[7]
Joint Venture Investments [Member] | Freestone Greeley [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-10	[6]
Total Initial Commitment	$ 16,035,710	[6]
Remaining Commitment as of December 31, 2022	$ 11,325,008	[6]
Joint Venture Investments [Member] | Freestone Cresta Bella [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2022-11	[6]
Total Initial Commitment	$ 16,405,514	[6]
Remaining Commitment as of December 31, 2022	10,204,191	[6]
Joint Venture Investments [Member] | Vantage At Loveland [Member]
Commitments And Other Guarantees [Line Items]
Total Initial Commitment	138,287,419
Remaining Commitment as of December 31, 2022	56,694,922
Bond Purchase Commitment [Member]
Commitments And Other Guarantees [Line Items]
Total Initial Commitment	3,900,000
Remaining Commitment as of December 31, 2022	$ 3,900,000
Bond Purchase Commitment [Member] | Anaheim & Walnut [Member]
Commitments And Other Guarantees [Line Items]
Commitment Date	2021-09
Maturity Date	Q3 2024	[8]
Interest Rate	4.85%	[1]
Total Initial Commitment	$ 3,900,000
Remaining Commitment as of December 31, 2022	$ 3,900,000

[1] The variable index interest rate components are typically subject to floors that range from 0% to 0.85%.

[2] The borrowers may elect to extend the maturity date for a period ranging between six and twelve months upon meeting certain conditions, which may include payment of a non-refundable extension fee.

[3] Upon stabilization, the MRB will convert to a fixed rate of 8.0% and become subordinate to the other senior MRBs.

[4] Beginning December 2029, the interest rate will change to the greater of (i) 3.25% over the then 10-Year SOFR Swap rate, or (ii) 6.00%.

[5] Upon stabilization, the MRB will convert to a fixed rate of 10.0% and become subordinate to the other senior MRBs of the borrower.

[6] A development site has been identified for this property but construction had not commenced as of December 31, 2022.

[7] The property became a consolidated VIE effective during the fourth quarter of 2021 (Note 5).

[8] This is the estimated closing date of the associated bond purchase commitment.