225 Water Street - Photo 1 of 38, Saint Andrews, New Brunswick
1 / 38
$1,999,900

225 Water Street — Saint Andrews, New Brunswick

E5B1B3

Fundy Bay Real Estate Group Inc.
MLS® NB126689
0Beds
6,954Sq Ft
1849Built

About This Property

An exceptional opportunity to acquire a substantial waterfront property in the heart of downtown St. Andrews by-the-Sea. Properties offering this combination of location, waterfront, existing income and future potential are rarely available in the towns commercial core. Situated directly on Water Street, this mixed-use property offers an established commercial space at street level together with three residential units above, valuable waterfront land extending toward the harbour, direct connection toward Market Square, and parking for three vehicles. While the property currently accommodates a full-service restaurant, the real opportunity extends well beyond its present use. For an investor or developer with vision, the size and configuration of the property may present possibilities to further enhance its commercial and residential income, explore additional accommodations or rental units, expand or reimagine portions of the existing property, or create an entirely new mixed-use concept that takes full advantage of its exceptional downtown waterfront setting, subject to all applicable approvals. The existing building provides considerable infrastructure from which to begin. The main level includes a large commercial space, full commercial kitchen, bar, public washrooms and an expansive waterfront patio. Above are three residential units, including two two-bedroom apartments with outstanding harbour and wharf views, while the third one-bedroom unit is presently used for office and storage purposes. Continue the existing operation, reposition the commercial space, increase residential or accommodation income, or investigate a larger redevelopment vision. Development possibilities are subject to municipal, planning, heritage and other applicable approvals. Buyers are encouraged to complete their own due diligence regarding their intended use. Don't buy it for what it is. Buy it for where it is, what comes with it, and what it could become. (id:63357)

Fundy Bay Real Estate Group Inc.MLS® NB126689

Property Location

Map

Property Details

Property Type
Detached
Bedrooms
0
Living Area
6,954 sqft
Above Grade Area
6,954 sqft
Year Built
1849
Status
Active
MLS® Number
NB126689

Location & Neighborhood

What's nearby 225 Water Street

Nearby Schools

Parks & Recreation

Transit Access

POI data updated recently

Price History

$1,999,900

Sep 3, 2026

$479,100

-19.3%

Saint Andrews Market Snapshot

32

Active Listings

Last updated: Sep 5, 2026

Powered by REALTOR.ca

The data relating to real estate on this website comes in part from the MLS® Reciprocity program.

REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA's By-Laws, Rules, and the REALTOR® Code.

The MLS® trademark and the MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.

The information contained on this site is based in whole or in part on information that is provided by members of CREA, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy.

The listing content on this website is protected by copyright and other laws. Screen scraping, database scraping, and all other forms of automated data collection are prohibited.

$1,999,900
Oakwyn Realty Ltd.

Oakwyn Realty Ltd.

Search Listings Online Inc.

3195 Oak St, Vancouver, BC V6H 2L2

REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA's By-Laws, Rules, and the REALTOR® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. The information contained on this site is based in whole or in part on information that is provided by members of CREA, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy.

The listing content on this website is protected by copyright and other laws. Screen scraping, database scraping, and all other forms of automated data collection are prohibited.

© 2026 Search Listings Online. Powered by CREA DDF