This one-of-a-kind custom-built home sets a new standard for luxury living, and it comes with a STUNNING VIEW! With over 3,000 sq. ft. of refined space, it pairs flawless craftsmanship with an unbeatable panoramic view of the river and valley. From the flawlessly manicured & landscaped yard, detached garage and shed with underground services, and stone walkway to the elegant stone façade, every detail has been thoughtfully designed. Inside, soaring 9’ ceilings and dramatic 10’ illuminated tray ceilings frame the open concept layout. The dream kitchen features a 4’ x 10’ island, walk-in pantry, quartz countertops, stainless steel appliances, and a tiled backsplash, flowing seamlessly to a 14’ x 27’ covered balcony. Hardwood and porcelain floors, geothermal heating/cooling, and oversized windows add both comfort and efficiency. The main level offers 3 spacious bedrooms, including a primary retreat with a spa-inspired 5-piece ensuite and large walk-in closet. Downstairs, enjoy a second bright living space with a propane fireplace, plus access to the heated, insulated double garage. With R24 wall and R60 attic insulation, this home is built to last. Just minutes from downtown Fredericton, it’s a rare blend of elegance, efficiency, and unmatched views. Full list of valuable features on file!
For sale
C$1,400,000
207 Carlisle Rd, Douglas, NB E3G 7M9
4beds
3,020sqft
Single Family Residence
Built in 2021
4,597 Square Feet Lot
$-- Zestimate®
C$464/sqft
C$-- HOA
What's special
Stunning viewRefined spaceFlawless craftsmanshipManicured and landscaped yardOpen concept layoutDream kitchenWalk-in pantry
- 106 days |
- 94 |
- 8 |
Zillow last checked: 8 hours ago
Listing updated: October 25, 2025 at 11:55pm
Listed by:
JESSIE YERXA, Salesperson,
eXp Realty Brokerage,
ANDREW PHILLIPS, Salesperson,
eXp Realty
Source: New Brunswick Real Estate Board,MLS®#: NB125469
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
Bedroom
- Level: Main
Bedroom
- Level: Main
Bedroom
- Level: Lower
Bathroom
- Level: Main
Bathroom
- Level: Lower
Other
- Level: Main
Dining room
- Level: Main
Other
- Level: Main
Family room
- Level: Lower
Foyer
- Level: Main
Kitchen
- Level: Main
Living room
- Level: Main
Storage
- Level: Lower
Utility room
- Level: Lower
Walk in closet
- Level: Main
Heating
- Electric, Fireplace-Gas, Fireplace(s)
Cooling
- Central Air, Electric, Heat Pump - Ducted, Heat Pump - Geothermal
Appliances
- Included: Built-In Appliances, Range Hood
- Laundry: Inside
Features
- Air Exchanger, Central Vacuum, Ensuite
- Flooring: Laminate, Tile, Vinyl, Wood
- Basement: Finished,Walk-Out Access
- Has fireplace: Yes
Interior area
- Total structure area: 3,020
- Total interior livable area: 3,020 sqft
- Finished area above ground: 3,020
Property
Parking
- Parking features: Parking Spaces, Paved, Width - Double, Width - Triple, Garage
- Garage spaces: 31
- Uncovered spaces: 5
- Details: Garage Size(31 X 28 & 23 X 29)
Features
- Levels: 2 Storey,Split Entry
- Stories: 2
- Has view: Yes
- View description: Water, River
- Has water view: Yes
- Water view: Water,River
- Waterfront features: River
- Body of water: Saint John River
Lot
- Size: 4,597 Square Feet
- Features: Landscaped, Level, Wooded, 1.0 -2.99 Acres
Details
- Parcel number: 75136556
- Other equipment: Dusk-to-Dawn Light
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Split Level
- Property subtype: Single Family Residence
Materials
- Stone, Vinyl Siding
- Foundation: Concrete
- Roof: Asphalt,Metal
Condition
- Year built: 2021
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & HOA
Location
- Region: Douglas
Financial & listing details
- Price per square foot: C$464/sqft
- Annual tax amount: C$8,382
- Date on market: 8/26/2025
- Ownership: Freehold
JESSIE YERXA, Salesperson
(506) 260-2420
By pressing Contact Agent, you agree that the real estate professional identified above may call/text you about your search, which may involve use of automated means and pre-recorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you're looking for in a home.
Price history
Price history
Price history is unavailable.
Public tax history
Public tax history
Tax history is unavailable.Climate risks
Neighborhood: E3G
Nearby schools
GreatSchools rating
No schools nearby
We couldn't find any schools near this home.
- Loading
