Sales Representative

Sales Rep.

I agree to receive marketing and customer service calls and text messages from Alourd Rosales and EXIT INTEGRITY REALTY, BROKERAGE. 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.

"THE JEWEL OF JORDAN" A Rare 1929 Arts & Crafts Estate in the Heart of Niagara's Wine Country!Step into a piece of Niagara history. This stately two-story home sits on a magnificent 86 x 165 ft mature tree-lined lot in the village of Jordan, one of the most sought-after and under-the-radar communities in the entire Niagara Region. Solid brick construction, soaring ceilings, and an extraordinary collection of architectural details have been meticulously restored to honour the home's original character. Original hardwood floors flow throughout. The formal living features a gas fireplace with marble surround, beautifully restored plaster crown molding, classic wainscotting, and period lighting. The beautiful windows make this space a bright and  wonderful place to sit, relax and maybe play a tune on the piano. The kitchen is both elegant and functional; custom cabinetry, granite countertops and high end appliances. A cooks and entertainers dream, that flows into the formal dining room with whimsical wallpaper imported from England and seating easily for 12. Upstairs, you'll find 4 bedrooms that have all been carefully renovated, oak floors, window seating and period lighting. The primary bedroom features a gas fireplace, and an attached sunroom, perfect for a reading den or art studio. The fully updated bath includes in-floor heating, a curb less shower, and a separate water closet. The back deck is a great place to hangout on a hot summers day under a 100 year old Maple.  The fully finished basement features a second kitchen and full bath, an ideal setup for an in-law suite, or for extended family. This is also a possibility to run an Airbnb. The real hidden treasure is a third-floor attic space with tremendous potential; imagine it finished as a lounge, creative studio, or executive home office. Just steps to world class wineries, restaurants, shops and bakeries.This is your opportunity to own a true piece of Niagara's architectural heritage. (id:31684)

Home Details for 3792 Main Street

Heating Information

Cooling Information

Parking