OFF MARKET

Off market

—

•

— ba

•

—

sq ft

254 Main St, Kingston, ON K7K 6W4

About this home

This home is currently off market and not for sale.

Barriefield Village. A stunning, timeless custom build. 254 Main Street with its incredible curb appeal, sits proudly overlooking the Cataraqui River. Elegant and modern at the same time, with more than 3500 sqft of finished living space, this two-story home sees four large upper bedrooms- 2 with their own ensuite- five bathrooms and exemplary finishes both inside and out. The main level offers a spacious family room, formal dining room, bright kitchen, and main floor laundry. The exposed beams on the second level highlight its vast space, the west facing windows offering lovely water views. The lower level is fully finished too, and caps off all of the space needed in a grand family home. The landscaping around the salt water pool offers privacy and is lush and oh so pretty. Surrounded by some of the most beautiful custom homes in the area, this is a true gem that should be seen to fully appreciate all that it offers.

Single-familyProperty Type

2 garage spacesParking

Source:TREB #X12419594

Market trends in Barriefield Village Heritage District, ON

Last updated October 2026

Sale-to-list price

Median sale price

Avg. days on market

Recently sold homes

Provided by Redfin

Sale history for 254 Main St

Date

Event

Price

TREB #X12419594

Nov 21, 2025

Delisted

—

Sep 22, 2025

Listed

$1,695,000

+43

TREB #X12236824

Sep 21, 2025

Delisted

—

Jun 20, 2025

Listed

$1,750,000

Property details

Around this home

Schools

2.6km

Cathedrale Catholic School

Public, JK-8 • Assigned

1.3km

La Salle Secondary School

Public, 9-12 • Assigned

Provided by Local Logic

Lifestyle

Provided by Walk Score and Local Logic

Sell confidently with a local market expert in Kingston. 3 minutes to get started.

Nearby similar homes

Sorry, we don't have any nearby similar homes to display. See all homes for sale in Barriefield Village Heritage District

Home values near 254 Main St

Data from public records.

Address
256 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
265 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
248 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
249 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
233 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
243 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
260 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.

Address
252 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
247 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
257 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
271 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
228 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
251 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
226 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.

Address
269 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
262 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
250 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
258 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
244 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
246 Main Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.
398 Wellington Street, Kingston, ON - Beds \| - Baths \| - Sq. Ft.

More real estate resources

Municipalities

Elizabethtown-Kitley homes for sale	Gananoque homes for sale	Westport homes for sale
Frontenac Islands homes for sale	Loyalist homes for sale	Stone Mills homes for sale
Greater Napanee homes for sale	Central Frontenac homes for sale	Rideau Lakes homes for sale
South Frontenac homes for sale	Leeds and the Thousand Islands homes for sale	Front of Yonge homes for sale
Prince Edward County homes for sale	Tay Valley homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the CIPO.

Redfin Unlimited Liability Company (trade name, Redfin) is a licensed and registered real estate brokerage in British Columbia and Ontario only.

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.