ATTENTION DEVELOPERS, INVESTORS & VISIONARIES! Opportunities of this magnitude are few and far between. Welcome to one of the Capital Region's most remarkable land offerings--over 12 acres spanning two adjoining parcels, each improved with its own residence, in the highly desirable Town of Colonie with highly sough after Niskayuna Schools. Once home to a flourishing family farm and business, this extraordinary property now offers an unparalleled opportunity to shape its next chapter. Ideally positioned just beyond the bustling Route 7 commercial corridor and neighboring established businesses, this unique offering presents exceptional potential for commercial expansion, residential development, mixed-use possibilities (subject to municipal approvals), or an extraordinary private family compound unlike anything else on the market. Imagine creating a signature residential community, expanding commercial presence in one of the Capital Region's most traveled corridors, restoring its agricultural roots with a modern farm or equestrian estate, or preserving generations of family living on one incredible property. With over 12 acres of prime land, an unbeatable location, and limitless possibilities, this is more than real estate--it's a legacy opportunity. Properties offering this combination of acreage, location, visibility, and future potential in Niskayuna Schools are exceptionally rare and seldom available. For the first 60 days on market, both parcels (4070 & 4072 River Rd) will be offered exclusively as a combined sale, providing buyers the unique opportunity to acquire the property in its entirety and maximize its extraordinary potential. Should they remain unsold after that time, the parcels may be offered individually.