




This 4-bedroom, 5-bathroom single family in Fredericton offers 10,516 sqft of living area on a 0.37 ac lot. Built in 2008, 2 storeys. The property has lot dimensions of 0.37. The home features concrete and tile and ceramic and wood flooring, radiant heat, natural gas, hot water heating, air conditioned.
Step into this heritage-inspired luxury home in downtown Fredericton! Built in 2008 and architecturally-designed to fit the streetscape, this stunning 2.5-storey residence boasts an incredible indoor pool, an extra-large manicured south-facing lot, and approximately 10,000 SQ FT of living space. Inside, youll find countless thoughtful design features and quality finishes, from the home lift to the ceramic and engineered wood flooring and in-floor heat. Custom cabinetry flows throughout the home, built by the first-class designer Wildwood Cabinets, while wide hallways and high ceilings add to the sense of luxury. A highlight of 748 Churchill Row is the indoor saltwater pool with a Dectron automated management system. Surrounded by a heated, stamped concrete floor and offering a steam room with an aromatherapy unit, there is ample opportunity for playtime and relaxation in all weathers. With 4 bedrooms, 4.5 bathrooms, and several flexible spaces that could serve as additional bedrooms, the home can accommodate families large and small. In addition to its beauty, superior mechanical systems run through the home, including a commercial HRV, a fire suppression system, and natural gas generator. There is also a large double-car garage with plenty of parking space & storage. Whether you're hosting guests, working from home, relaxing by the pool, or simply enjoying the quiet elegance, this downtown Fredericton estate delivers a lifestyle few properties can match. (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
Listed by Rebecca Steeves, Re/Max Hartford Realty
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.
Get in touch for a private showing or more details.
Listing represented by Rebecca Steeves, Re/Max Hartford Realty · MLS# NB111672
For illustration purposes only. Consult a mortgage professional for accurate rates.
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.
Estimate based on Ontario LTT rates. Consult your lawyer for exact amounts.