Connery personally developed the townhouse into a castle like unofficial embassy in order to further his homeland's cause, the Scotsman reported.
The three-story building is officially known as Alba House, and Connery hopes it will become a hub for Scottish affairs in New York.
The successful completion of Alba House is the latest success story of Connery's charity, Friends of Scotland, which will use the house to promote fundraising efforts as well.
Organizers have said that the house is already the country's "unofficial embassy" with government officials, universities and business all wanting to use it as a New York base.
Connery plans to open the building next week as part of the annual Tartan Week celebrations
"The formal opening of Friends of Scotland's Alba House in New York City is another huge step forward for the charity," said the actor.