Space
Finished area and layout
- Living Area
- 4,350 sqft
- Above Grade
- 2,979 sqft
- Finished Breakdown
- Above 2,979 sqft
- Bedrooms
- 4
- Bathrooms
- 3





Property Snapshot
MLS #NB149558
Finished area and layout
Type, style and structure
This 4-bedroom, 3-bathroom single family in Upper Kingsclear offers 4,350 sqft of living area on a 2,979 sqft lot. Built in 2016. The property has lot dimensions of 2979. The home features hardwood and laminate and carpeted and ceramic flooring, heat pump, forced air, propane, hot water heating, central air conditioning, air exchanger, heat pump, air conditioned, a fireplace.
When Viewing This Property on Realtor.ca Please Click on the Multimedia or Virtual Tour Link for More Property Info. Saint John River Masterpiece: 180° of Pure Magic in Pebble Beach. True waterfront living is not just about a view; it is about a lifestyle that changes with the Seasons. Boating, waterskiing, swimming and kayaking in the Summer. Skating in the crisp morning air in the winter. With over 295 ft of pristine shoreline on the Mactaquac Headpond, this custom-built home turns everyday living into a luxury vacation. Opportunities like this arrive once in a generation. This is one of the largest waterfront lots in Pebble Beach. Elevated Living, Panoramic Design strategically engineered to frame unobstructed, 180-degree vistas of the Saint John River. The main Level features premium kitchen with a Butlers Pantry: A hidden spice kitchen complete with a secondary fridge and sink. The Great Room: An open-concept flow connecting the kitchen, dining and living spaces centre around a propane fireplace and steps out to a balcony overlooking the water. Step downstairs into the Ultimate Entertainment Level A vibrant space featuring a full wet bar, a billiards table, a media lounge and a personal gym and Sauna. The Guest Quarters: An oversized fourth bedroom with its own walk-in closet, panoramic views and a 3rd full bathroom and even your own gym! Every room steps onto a deck overlooking the view. A large third deck by the water Offers a place to sunbathe by the private beachfront, dock your boat or have a fire and relax by the water. Your Private Paradise Awaits. (id:60351)
We can help you find properties matching your criteria, including exclusive listings not yet on the market.
Save favorites, track showings, view sold data & get market alerts — Free account — 100% free
Land, frontage and setting
Price, taxes and monthly charges
Take TCH exit 258 or Hwy 102 past the weigh scales in Longs Creek. Longs Creek Road left on Sandcastle Lane.
Listed by Jonathan David, PG Direct Realty Ltd.
The listing data displayed is deemed reliable but is not guaranteed accurate by the Canadian Real Estate Association (CREA). 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 The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA.
Not A Dream Realty Inc., Brokerage is a member of CREA and the Toronto Regional Real Estate Board. All information should be independently verified. © 2026 Not A Dream Realty Inc., Brokerage. All rights reserved.
Important notice: This website provides free general real estate information for consumer convenience. Listing data, maps, photos, descriptions, measurements, room sizes, lot sizes, taxes, prices, availability, school/market information, estimates, and other property details may be incomplete, delayed, approximate, generated from third-party sources, or changed without notice. We do not warrant that any information is complete, current, or error-free, and we have not independently verified all information shown. Do not rely on this website alone when making a purchase, sale, lease, financing, investment, tax, legal, valuation, or insurance decision. Verify all material facts directly with the listing brokerage, real estate board, municipality, lender, insurer, lawyer, inspector, surveyor, or other qualified professional, as applicable. Nothing on this website is an appraisal, market valuation, price opinion, professional recommendation, or legal, financial, tax, engineering, inspection, or investment advice. To the fullest extent permitted by law, the website operator, brokerage, and their representatives are not responsible for losses or damages arising from errors, omissions, delays, changes, or reliance on information displayed here.
Connect with a local real estate professional for a private showing or more details.
Listed by Jonathan David, PG Direct Realty Ltd. · MLS# NB149558
Configured mortgage defaults and jurisdiction rules are required before property payment estimates can be calculated.
Disclaimer: The mortgage estimates and monthly cost calculations shown above are for illustrative purposes only and should not be relied upon as financial advice. Actual mortgage rates, terms, and eligibility depend on your personal financial situation, credit history, and current market conditions. Please consult a licensed mortgage broker, financial advisor, or your bank to determine your actual affordability and mortgage costs before making any purchasing decisions.
Calculating…
Estimate from the jurisdiction's published transfer-tax rates. Consult your lawyer for exact amounts.