Aggregate limited partnership units issued for acquisition purposes

No definition available.

Name:	ck0001412502_AggregateUnitsOfLimitedPartnershipIssuedForAcquisitionUnits
Namespace Prefix:	ck0001412502_
Data Type:	xbrli:sharesItemType
Balance Type:	na
Period Type:	duration

- Definition

Aggregate value of limited partnership units issued for acquisition

+ References

No definition available.

+ Details

Name:	ck0001412502_AggregateUnitsOfLimitedPartnershipIssuedForAcquisitionValue
Namespace Prefix:	ck0001412502_
Data Type:	xbrli:monetaryItemType
Balance Type:	credit
Period Type:	duration

- Definition

Area Of Property Purchased

+ References

No definition available.

+ Details

Name:	ck0001412502_AreaOfPropertyPurchased
Namespace Prefix:	ck0001412502_
Data Type:	num:areaItemType
Balance Type:	na
Period Type:	duration

- Definition

Represents the assumed liabilities in a business acquisition.

+ References

No definition available.

+ Details

Name:	ck0001412502_BusinessAcquisitionAssumedLiabilities
Namespace Prefix:	ck0001412502_
Data Type:	xbrli:monetaryItemType
Balance Type:	credit
Period Type:	duration

- Definition

The purchase price of the acquisition, net of adjustments, if any, for properties in which the percentage acquired was less than one hundred percent.

+ References

No definition available.

+ Details

Name:	ck0001412502_BusinessAcquisitionProrataAcquisitionPrice
Namespace Prefix:	ck0001412502_
Data Type:	xbrli:monetaryItemType
Balance Type:	credit
Period Type:	duration

- Definition

Represents the amount of debt issued in a business acquisition.

+ References

No definition available.

+ Details

Name:	ck0001412502_DebtToFinanceAcquisition
Namespace Prefix:	ck0001412502_
Data Type:	xbrli:monetaryItemType
Balance Type:	credit
Period Type:	instant

- Definition

Amount per share or per unit of equity securities issued. Represents the first price.

+ References

No definition available.

+ Details

Name:	ck0001412502_SharesIssuedPricePerShareOne
Namespace Prefix:	ck0001412502_
Data Type:	num:perShareItemType
Balance Type:	na
Period Type:	instant

- Definition

Amount per share or per unit of equity securities issued. Represents the second price.

+ References

No definition available.

+ Details

Name:	ck0001412502_SharesIssuedPricePerShareTwo
Namespace Prefix:	ck0001412502_
Data Type:	num:perShareItemType
Balance Type:	na
Period Type:	instant

- Definition

Units In Property Acquired

+ References

No definition available.

+ Details

Name:	ck0001412502_UnitsInPropertyAcquired
Namespace Prefix:	ck0001412502_
Data Type:	xbrli:integerItemType
Balance Type:	na
Period Type:	duration

- Definition

Line items represent financial concepts included in a table. These concepts are used to disclose reportable information associated with domain members defined in one or many axes to the table.

+ References

No definition available.

+ Details

Name:	us-gaap_BusinessAcquisitionLineItems
Namespace Prefix:	us-gaap_
Data Type:	xbrli:stringItemType
Balance Type:	na
Period Type:	duration

- Definition

Amount of consideration transferred, consisting of acquisition-date fair value of assets transferred by the acquirer, liabilities incurred by the acquirer, and equity interest issued by the acquirer.

+ References

Reference 1: http://www.xbrl.org/2003/role/presentationRef
-Publisher FASB
-Name Accounting Standards Codification
-Topic 805
-SubTopic 30
-Section 30
-Paragraph 7
-URI http://asc.fasb.org/extlink&oid=6911251&loc=d3e6578-128477

Reference 2: http://www.xbrl.org/2003/role/presentationRef
-Publisher FASB
-Name Accounting Standards Codification
-Topic 805
-SubTopic 30
-Section 50
-Paragraph 1
-Subparagraph (b)
-URI http://asc.fasb.org/extlink&oid=35744584&loc=d3e6927-128479

Reference 3: http://www.xbrl.org/2003/role/presentationRef
-Publisher FASB
-Name Accounting Standards Codification
-Topic 805
-SubTopic 30
-Section 30
-Paragraph 8
-URI http://asc.fasb.org/extlink&oid=6911251&loc=d3e6613-128477

+ Details

Name:	us-gaap_BusinessCombinationConsiderationTransferred1
Namespace Prefix:	us-gaap_
Data Type:	xbrli:monetaryItemType
Balance Type:	credit
Period Type:	duration

- Definition

This element represents the amount of earnings or loss of the acquiree since the acquisition date included in the consolidated income statement for the reporting period.

+ References

Reference 1: http://www.xbrl.org/2003/role/presentationRef
-Publisher FASB
-Name Accounting Standards Codification
-Topic 805
-SubTopic 10
-Section 50
-Paragraph 2
-Subparagraph (h)(1)
-URI http://asc.fasb.org/extlink&oid=56956515&loc=d3e1392-128463

+ Details

Name:	us-gaap_BusinessCombinationProFormaInformationEarningsOrLossOfAcquireeSinceAcquisitionDateActual
Namespace Prefix:	us-gaap_
Data Type:	xbrli:monetaryItemType
Balance Type:	credit
Period Type:	duration

- Definition

This element represents the amount of revenue of the acquiree since the acquisition date included in the consolidated income statement for the reporting period.

+ References

+ Details

Name:	us-gaap_BusinessCombinationProFormaInformationRevenueOfAcquireeSinceAcquisitionDateActual
Namespace Prefix:	us-gaap_
Data Type:	xbrli:monetaryItemType
Balance Type:	credit
Period Type:	duration

- Definition

The amount of debt that an Entity assumes in acquiring a business or in consideration for an asset received in a noncash (or part noncash) acquisition. Noncash is defined as transactions during a period that affect recognized assets or liabilities but that do not result in cash receipts or cash payments in the period. "Part noncash" refers to that portion of the transaction not resulting in cash receipts or cash payments in the period.

+ References

Reference 1: http://www.xbrl.org/2003/role/presentationRef
-Publisher FASB
-Name Accounting Standards Codification
-Topic 230
-SubTopic 10
-Section 50
-Paragraph 5
-URI http://asc.fasb.org/extlink&oid=6367179&loc=d3e4332-108586

Reference 2: http://www.xbrl.org/2003/role/presentationRef
-Publisher FASB
-Name Accounting Standards Codification
-Topic 230
-SubTopic 10
-Section 50
-Paragraph 4
-URI http://asc.fasb.org/extlink&oid=6367179&loc=d3e4313-108586

Reference 3: http://www.xbrl.org/2003/role/presentationRef
-Publisher FASB
-Name Accounting Standards Codification
-Topic 230
-SubTopic 10
-Section 50
-Paragraph 3
-URI http://asc.fasb.org/extlink&oid=6367179&loc=d3e4304-108586

+ Details

Name:	us-gaap_NoncashOrPartNoncashAcquisitionDebtAssumed1
Namespace Prefix:	us-gaap_
Data Type:	xbrli:monetaryItemType
Balance Type:	credit
Period Type:	duration

- Definition

The cash outflow associated with the acquisition of business during the period. The cash portion only of the acquisition price.

+ References

Reference 1: http://www.xbrl.org/2003/role/presentationRef
-Publisher FASB
-Name Accounting Standards Codification
-Glossary Investing Activities
-URI http://asc.fasb.org/extlink&oid=6516133

Reference 2: http://www.xbrl.org/2003/role/presentationRef
-Publisher FASB
-Name Accounting Standards Codification
-Topic 230
-SubTopic 10
-Section 45
-Paragraph 13
-Subparagraph (b)
-URI http://asc.fasb.org/extlink&oid=56944662&loc=d3e3213-108585

+ Details

Name:	us-gaap_PaymentsToAcquireBusinessesGross
Namespace Prefix:	us-gaap_
Data Type:	xbrli:monetaryItemType
Balance Type:	credit
Period Type:	duration

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_ValleyHomesDuplexesGrandForksNdMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_TitanMachineryBismarckMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_QuailCreekSpringfieldMoMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_ParkviewArmsBismarckNdMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_LandMankatoMNMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_LandFargoNDMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_HuntingtonFargoNDMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_SummerfieldFargoNDMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_BellPlazaFKNorthlandPlazaMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_ColumbineApartmentsGrandForksNDMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

- Details

Name:	ck0001412502_RealEstatePropertyAcquisitionsAxis=ck0001412502_SummitPointFargoNDMember
Namespace Prefix:
Data Type:	na
Balance Type:
Period Type:

Business Combinations and Acquisitions - Purchases, Prior Year (Details) $ / shares in Units, $ in Thousands											5 Months Ended	12 Months Ended
	Oct. 01, 2015 USD ($) item	Sep. 01, 2015 USD ($) item	Aug. 13, 2015 USD ($) ft²	Aug. 04, 2015 USD ($) item	Jul. 20, 2015 USD ($) a	Jun. 16, 2015 USD ($) a	May 13, 2015 USD ($) item	Feb. 03, 2015 USD ($) item	Jan. 28, 2015 USD ($) ft²	Jan. 13, 2015 USD ($) item	Dec. 31, 2015 USD ($) $ / shares	Dec. 31, 2016 USD ($) $ / shares shares	Dec. 31, 2015 USD ($) $ / shares shares	Dec. 31, 2014 USD ($) $ / shares shares
BUSINESS COMBINATIONS AND ACQUISITIONS
Acquisition price												$ 35,312	$ 82,586	$ 132,990
Prorata Acquisition Price												$ 35,312	$ 66,836	$ 132,990
Aggregate number of limited partnership units issued for acquisition \| shares												1,466,000	729,000	1,233,000
Price per limited partnership unit issued for acquisition, price one \| $ / shares											$ 15.00	$ 15.50	$ 15.00	$ 14.00
Price per limited partnership unit issued for acquisition, price two \| $ / shares											$ 15.50	$ 16.00	$ 15.50	$ 15.00
Aggregate value of limited partnership units issued for acquisition												$ 23,020	$ 11,228	$ 17,461
New loans issued to finance acquisition											$ 45,830	2,662	45,830	67,477
Assumed loans													719	2,636
Assumed liabilities												78	1,329
Consideration in cash to pay for acquisitions												$ 9,552	$ 23,480	$ 44,054
Valley Homes Duplexes, Grand Forks, ND
BUSINESS COMBINATIONS AND ACQUISITIONS
Units acquired \| item										24
Acquisition price										$ 2,148
Prorata Acquisition Price										$ 2,148
Titan Machinery Bismarck, ND
BUSINESS COMBINATIONS AND ACQUISITIONS
Area of the property purchased \| ft²									22,293
Acquisition price									$ 3,416
Prorata Acquisition Price									$ 3,416
Quail Creek, Springfield, MO
BUSINESS COMBINATIONS AND ACQUISITIONS
Units acquired \| item								164
Acquisition price								$ 10,900
Prorata Acquisition Price								$ 10,900
Parkview Arms, Bismarck, ND
BUSINESS COMBINATIONS AND ACQUISITIONS
Units acquired \| item							62
Acquisition price							$ 4,464
Prorata Acquisition Price							$ 4,464
Development Land, Mankato, MN
BUSINESS COMBINATIONS AND ACQUISITIONS
Area of the property purchased \| a						1.13
Acquisition price						$ 263
Prorata Acquisition Price						$ 263
Development Land, Fargo, ND
BUSINESS COMBINATIONS AND ACQUISITIONS
Area of the property purchased \| a					1.95
Acquisition price					$ 500
Prorata Acquisition Price					$ 500
Huntington, Fargo, ND
BUSINESS COMBINATIONS AND ACQUISITIONS
Units acquired \| item				10
Acquisition price				$ 420
Prorata Acquisition Price				$ 420
Summerfield, Fargo, ND
BUSINESS COMBINATIONS AND ACQUISITIONS
Units acquired \| item				18
Acquisition price				$ 774
Prorata Acquisition Price				$ 774
Bell Plaza (FKA Northland Plaza)
BUSINESS COMBINATIONS AND ACQUISITIONS
Area of the property purchased \| ft²			296,967
Acquisition price			$ 52,500
Prorata Acquisition Price			$ 36,750
Revenues from acquisition											3,163
Net loss attributable to Parent from acquisition											$ 2,356
Columbine Apartments, Grand Forks, ND
BUSINESS COMBINATIONS AND ACQUISITIONS
Units acquired \| item		12
Acquisition price		$ 629
Prorata Acquisition Price		$ 629
Summit Point, Fargo, ND
BUSINESS COMBINATIONS AND ACQUISITIONS
Units acquired \| item	87
Acquisition price	$ 6,572
Prorata Acquisition Price	$ 6,572