Perched above the Cataraqui River in Barriefield Village, this exceptional custom-built home blends timeless elegance with modern sophistication. With over 3,500 sq. ft. of beautifully finished living space, this four-bedroom, five-bathroom residence showcases impeccable craftsmanship and thoughtful design. Striking curb appeal sets the tone from the moment you arrive, while inside, refined finishes and warm architectural details create a home that feels inviting. The main level offers an ideal layout for family living, featuring a spacious family room, formal dining area, bright eat-in kitchen, convenient powder room, and main-floor laundry. Upstairs, exposed beams add character and charm to the expansive second level, while west-facing windows capture beautiful natural light and glimpses of the water beyond. The fully finished lower level provides even more versatile living space, perfect for a rec room, home gym, guest retreat, or growing family needs. Outside, the private backyard oasis is framed by lush mature landscaping surrounding the saltwater pool, creating the perfect setting for relaxing or entertaining all summer long. Surrounded by some of Kingston's most stunning custom homes, this property offers a rare opportunity to own a truly special home in one of the city's most beautiful neighbourhoods. A home of this calibre must be experienced in person to be fully appreciated.
Address
254 Main Street
List Price
$1,400,000
MLS® Status
New
Property Type
Residential Freehold
Type of Dwelling
Detached
Style of Home
2-Storey
Transaction Type
Sale
Area
Kingston
Sub-Area
13 - Kingston East (Incl Barret Crt)
Region
Frontenac
Bedrooms
4
Bedrooms (Total)
4
Rooms Above Grade
13
Rooms Below Grade
5
Bathrooms
5
Floor Area
2500-3000 Sq. Ft.
Lot Size Source
GeoWarehouse
Lot Depth
156.4
Lot Size Units
Feet
Lot Width
59.06
Parcel Number
362620464
Occupant Type
Owner
Cross Street
Wellington Street
Approx. Age
31 - 50 Years
MLS® Number
X13157122
Listing Brokerage
ROYAL LEPAGE PROALLIANCE REALTY, BROKERAGE
Basement Area
Finished, Full
Postal Code
K7K 6W4
Posession Details
Flexible
Parking
Private
Parking Places (Total)
8
Parking Spaces
6
Tax Amount
$9,255.00
Tax Year
2025
Site Influences
Clear View, Deck, Fenced Yard, Lake/Pond, Landscaped, Lawn Sprinkler System, Privacy
Exterior Features
Deck, Landscaped, Lawn Sprinkler System, Privacy
Interior Features
Auto Garage Door Remote, Built-In Oven, Central Vacuum, On Demand Water Heater, Storage Area Lockers
Property Features
Clear View, Fenced Yard, Lake/Pond
Central Vacuum
Yes
Family Room
No
Ensuite Laundry
No
Special Designation
Heritage
Standard Status
Active
Board Or Association
Kingston & Area Real Estate Association
Heat Source
Gas
Heat Type
Forced Air
Cooling Features
Central Air
Construction Materials
Hardboard
Direction Faces
East
Fireplace
Yes
Fireplace Features
Living Room, Natural Gas
Foundation Details
Poured Concrete
Garage
Yes
Garage Type
Attached
Covered Spaces
2
Kitchens Total
1
Kitchens Above Grade
1
Other Structures
Garden Shed
Pool Features
Inground, Salt
Roof
Asphalt Shingle
Tax Legal Description
LT 5, PL 1910 ; PITTSBURGH
View Type
Panoramic, Pool, River, Water
Waterfront
No
Sewer
Sewer
Login To View 9 Additional Details On 254 Main Street
Get instant access to more information with a free account.
Already have an account? Login
Rooms
| Floor | Type | Dimensions | Features |
|---|---|---|---|
| Main | Bathroom | 1.57 x 1.62 | 2 Pc Bath |
| Main | Breakfast | 3.79 x 3.09 | |
| Main | Dining Room | 3.77 x 4.28 | |
| Main | Kitchen | 3.4 x 3.86 | |
| Main | Laundry | 2.47 x 1.5 | |
| Main | Bathroom | 1.57 x 1.62 | 2 Pc Bath |
| Second | Primary Bedroom | 6.32 x 7.8 | |
| Second | Bedroom 2 | 3.39 x 4.25 | |
| Second | Bedroom 3 | 4.04 x 5.21 | |
| Second | Bedroom 4 | 4.03 x 4.18 | |
| Second | Bathroom | 3.39 x 4.25 | 5 Pc Ensuite |
| Second | Bathroom | 2.59 x 3.35 | 5 Pc Ensuite |
| Second | Bathroom | 2.42 x 2.98 | 4 Pc Bath |
| Lower | Recreation | 6.96 x 7.75 | |
| Lower | Utility Room | 3.74 x 7.75 | |
| Lower | Bathroom | 1.54 x 1.61 | 2 Pc Bath |
| Lower | Other | 1.9 x 1.56 | Wet Bar |
| Lower | Other | 2.94 x 1.56 |