Sales Representative

Sales Rep.

I agree to receive marketing and customer service calls and text messages from Shawn Trahan and EXIT REALTY ASSOCIATES. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. To opt-out, you can reply "STOP" at any time or click the unsubscribe link in the emails.

Privacy Policy

Terms Of Service

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 and identify the quality of services provided by REALTORS®. Used under license. This information contained on this site is based in whole or in part on listing content from The Canadian Real Estate Association, which assumes no responsibility for its accuracy. This listing content provided by <a href="http://www.realtor.ca" target="_blank">REALTOR.ca</a> has been licensed by REALTOR® members of <a href="http://www.crea.ca" target="_blank">The Canadian Real Estate Association</a>

Terms of Use This website is operated by {{officesInfo.OfficeName}}, a brokerage who is a member of The Canadian Real Estate Association (CREA). The content on this website is owned or controlled by CREA. By accessing this website, the user agrees to be bound by these terms of use as amended from time to time, and agrees that these terms of use constitute a binding contract between the user, {{officesInfo.OfficeName}}, and CREA. Copyright The content on this website is protected by copyright and other laws, and is intended solely for the private, non-commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically prohibited. Prohibited uses include commercial use, “screen scraping”, “database scraping”, and any other activity intended to collect, store, reorganize or manipulate the content of this website. Trademarks REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA’s By-Laws, Rules, and the REALTOR® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the professional real estate services provided by members of CREA. Liability and Warranty Disclaimer The information contained on this website is based in whole or in part on information that is provided by members of CREA, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members, and assumes no responsibility for its completeness or accuracy. Amendments {{officesInfo.OfficeName}} may at any time amend these Terms of Use by updating this posting. All users of this site are bound by these amendments should they wish to continue accessing the website, and should therefore periodically visit this page to review any and all such amendments.

Welcome to 517 Mansfield Street, an impeccably maintained 4 level side split nestled on a quiet family friendly cul-de-sac on The Hill ,one of Frederictons most sought after neighbourhoods. Blending timeless mid-century modern design with thoughtful updates, this stunning home offers 3 bedrooms, 2 full bathrooms, and a large detached garage. The homes striking curb appeal is highlighted by a brick faÃ§ade, landscaped rockery, and updated vinyl siding. Inside, a spacious foyer welcomes you to a versatile main level featuring a cozy family room, sunroom (currently used as a gym), and a flexible bonus space currently used for storage but previously used as a functional office space. Upstairs the open-concept kitchen/dining/living area is designed for both everyday living and entertaining. The kitchen features stainless steel appliances, a natural gas stove, modern finishes, and a large butcher block island. Hardwood flooring, a natural gas fireplace, and ductless heat pump provide warmth and comfort year-round. The upper level offers 3 well appointed bedrooms and a beautifully updated bathroom with double sinks. The lower level includes a spacious L shaped family room with a second natural gas fireplace, a full bathroom, laundry, and ample storage in the crawl space. Step outside to your private backyard retreat featuring an inground pool surrounded by stone and composite decking, a hot tub, privacy walls, and mature trees. Located just minutes from schools, shopping, restaurants, the hospital, uptown & downtown Fredericton. Recent upgrades include new roof shingles (2023), siding (2022), new deck(2017), two heat pumps (2021) & more! (id:31684)

Home Details for 517 Mansfield Street St

Heating Information

Cooling Information

Parking