REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Kevin Hollohan

kevin@506realty.ca +1(506) 447-2896

$ 824,900

Est. payment | -/mo

4 Beds

3 Baths

2,980 SqFt

Save

$ 824,900

Est. payment | -/mo

Save

4 Beds

3 Baths

2,980 SqFt

Open House

Thu Jul 09, 5:00pm - 7:00pm

Key Details

Property Type Single Family Home

Sub Type Freehold

Listing Status Active

Purchase Type For Sale

Approx. Sqft 2980

Square Footage 2,980 sqft

Price per Sqft $276

MLS® Listing ID NB143620

Style Contemporary

Bedrooms 4

Half Baths 1

Year Built 1992

Lot Size 7,545 Sqft

Acres 0.17322087

Property Sub-Type Freehold

Property Description

Welcome to this exceptional custom-built two-storey home, offered for sale for the very first time. Perfectly situated on a quiet cul-de-sac in a highly sought-after location, this stunning property boasts breathtaking million-dollar views of the beautiful Saint John River, incredible curb appeal, and a mature, professionally landscaped lot. Just minutes from Bliss Carman Middle School, this is a rare opportunity to own a truly special home. Step through the front door and prepare to be impressed. From the soaring ceilings and multiple skylights that flood the home with natural light and custom stained glass windows, quality craftsmanship is evident throughout. Designed with entertaining in mind, the spacious living room flows into a formal dining room where oversized windows frame the spectacular river views. The well-appointed kitchen features Corian countertops, ample cabinetry, and a bright breakfast nook. The inviting family room with fireplace opens to a beautiful three-season sunroom and back deck. A convenient half bath, separate main-floor laundry room, and direct access to the attached garage complete the main level. Upstairs offers four bedrooms, including an oversized primary suite with a private ensuite bath, plus a second full bathroom to accommodate the rest of the family. The lower level adds even more living space with a finished rec room that could easily serve as a fifth bedroom (window may not meet egress), a dedicated workshop for hobbyists or crafters, multiple storage rooms, and a versatile bonus room ideal for a home theatre, games room, fitness space, or man cave. An attached garage with room for 2 vehicles. Recent updates include a new heat pump installed in 2025, recently resealed skylights, and fresh paint throughout the main living areas and primary bedroom and ensuite. With central heating and air conditioning, exceptional quality, stunning views, and an unbeatable location, this is a home you'll be proud to call your own. (id:24570)

Location

Province NB

Lake Name Saint John River

Rooms

Kitchen 0.0

Extra Room 1 Second level 7'11'' x 6'9'' Sitting room

Extra Room 2 Second level 4'4'' x 3'9'' 3pc Bathroom

Extra Room 3 Second level 7'7'' x 10'4'' Ensuite

Extra Room 4 Second level 15'4'' x 20'5'' Primary Bedroom

Extra Room 5 Second level 7'7'' x 7'8'' 3pc Bathroom

Extra Room 6 Second level 12'0'' x 10'9'' Bedroom

Interior

Heating Forced air, Heat Pump,

Cooling Central air conditioning, Heat Pump

Flooring Carpeted, Laminate, Tile, Porcelain Tile

Exterior

Parking Features Yes

View Y/N Yes

View River view

Attached Garage Yes

Garage Yes

Private Pool No

Building

Lot Description Landscaped

Story 2

Sewer Municipal sewage system

Water Saint John River

Architectural Style Contemporary

Others

Ownership Freehold

Listed by Keller Williams Capital Realty

+1(506) 447-2896

kevin@506realty.ca

407 Aspendale Lane Fredericton, NB E3B6Y3