RE/MAX Escarpment
-
56 AQUAMARINE Drive in Hamilton: Single Family for sale : MLS®# 40748135
56 AQUAMARINE Drive Hamilton L8E 0E8 
$4,499,900Single Family- Status:
- Active
- MLS® Num:
- 40748135
- Bedrooms:
- 4
- Bathrooms:
- 7
- Floor Area:
- 4,554 sq. ft.
Welcome to 56 Aquamarine Drive — a luxurious 4700 sq ft custom waterfront home with direct lake access, private elevator, and a triple car garage with vehicle/boat lifts. This 4 bed, 6 bath masterpiece offers high-end finishes throughout, including a gourmet Viking kitchen, grand dining room, sunroom with skylights, and multiple fireplaces. Each bedroom features its own ensuite, ideal for multigenerational living. The primary suite offers a lakeview balcony, spa-like bath, and fireplace. Enjoy a 14’ swim spa, beautifully landscaped yard, new seawall, and upper/lower patios overlooking the lake. Located on a quiet court near marinas, highways, shopping, and Niagara wine country. Luxury Certified. (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc.
- DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
3762-3766 GREENLANE Road in Beamsville: Agriculture for sale : MLS®# XH4187711
3762-3766 GREENLANE Road Beamsville L0R 1B1
$2,599,999Agriculture- Status:
- Active
- MLS® Num:
- XH4187711
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 3,161 sq. ft.
Welcome to this unique property where traditional agriculture meets modern entrepreneurial opportunity on this 22-acre plum orchard estate in the heart of Lincoln. Zoned Agricultural by the Township of Lincoln, this property is permitted to support a full range of agricultural uses, including crop cultivation, livestock production, and on-farm diversified operations. In other words, it’s a perfect canvas for both conventional farming and innovative ventures. The estate features rows of lush plum trees primed for bountiful harvests, while the 1960’s bungalow—with its three cozy bedrooms—offers original charm and comfortable living. Adjacent to the main residence is a 1,200-square-foot, two-story farm worker help house awaiting renovation, providing ample potential for creative customization. A standout feature is the pair of spacious chicken barns. These structures, previously utilized for specialized agricultural operations, with much of the specialized equipment left intact—these versatile barns now offer tremendous business potential. Whether you’re interested in a cannabis operation, branching into mushroom cultivation, turning the barns into indoor storage or pursuing another value-added agricultural enterprise, these barns provide an exceptional possibilities! Completing the picture is a large reservoir pond at the rear of the property—a peaceful spot ideal for wildlife viewing and outdoor relaxation. Conveniently located near Beamsville, Vineland, and the QEW this property offers the rare combination of rural seclusion and modern accessibility. Don’t miss your chance to own this unique agricultural gem, where traditional values and innovative business opportunities come together. (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
3762-3766 GREENLANE Road in Lincoln: Single Family for sale : MLS®# XH4187704
3762-3766 GREENLANE Road Lincoln L0R 1B1
$2,599,999Single Family- Status:
- Active
- MLS® Num:
- XH4187704
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 3,161 sq. ft.
Welcome to this unique property where traditional agriculture meets modern entrepreneurial opportunity on this 22-acre plum orchard estate in the heart of Lincoln. Zoned Agricultural by the Township of Lincoln, this property is permitted to support a full range of agricultural uses, including crop cultivation, livestock production, and on-farm diversified operations. In other words, it’s a perfect canvas for both conventional farming and innovative ventures. The estate features rows of lush plum trees primed for bountiful harvests, while the 1960’s bungalow—with its three cozy bedrooms—offers original charm and comfortable living. Adjacent to the main residence is a 1,200-square-foot, two-story farm worker help house awaiting renovation, providing ample potential for creative customization. A standout feature is the pair of spacious chicken barns. These structures, previously utilized for specialized agricultural operations, with much of the specialized equipment left intact—these versatile barns now offer tremendous business potential. Whether you’re interested in a cannabis operation, branching into mushroom cultivation, turning the barns into indoor storage or pursuing another value-added agricultural enterprise, these barns provide an exceptional possibilities! Completing the picture is a large reservoir pond at the rear of the property—a peaceful spot ideal for wildlife viewing and outdoor relaxation. Conveniently located near Beamsville, Vineland, and the QEW this property offers the rare combination of rural seclusion and modern accessibility. Don’t miss your chance to own this unique agricultural gem, where traditional values and innovative business opportunities come together. (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
275 CUMBERLAND Avenue in Hamilton: Other for sale : MLS®# 40749138
275 CUMBERLAND Avenue Hamilton L8M 2A3
$2,199,900Other- Status:
- Active
- MLS® Num:
- 40749138
- Floor Area:
- 7,186 sq. ft.
Welcome to 275 Cumberland Avenue, Hamilton. A timeless beauty nestled just below the Escarpment, this stately 3-storey mansion is brimming with charm, character, and untapped potential. Located in one of Hamilton’s most cherished neighbourhoods, the home has been lovingly preserved to maintain its historic elegance while offering modern-day flexibility. Inside, you’ll find five distinct, self-contained units—an incredibly rare opportunity for investors, multigenerational families, or anyone seeking supplemental income while enjoying grand residence of their own. From soaring ceilings and rich wood detailing to vintage accents and architectural flourishes, every inch of this home tells a story. Set on a mature, tree-lined lot with 10+ parking, you’re just steps from Gage Park, top-rated schools, transit, and local shops—making this location as desirable as the home itself. Over size lot may offer varies development opportunities. Don’t miss your chance to own a truly unique piece of Hamilton’s history. (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
275 CUMBERLAND Avenue in Hamilton: Multi-family for sale : MLS®# 40749091
275 CUMBERLAND Avenue Hamilton L8M 2A3
$2,199,900Multi-family- Status:
- Active
- MLS® Num:
- 40749091
- Bedrooms:
- 9
- Bathrooms:
- 7
- Floor Area:
- 7,186 sq. ft.
Welcome to 275 Cumberland Avenue, Hamilton. A timeless beauty nestled just below the Escarpment, this stately 3-storey mansion is brimming with charm, character, and untapped potential. Located in one of Hamilton’s most cherished neighbourhoods, the home has been lovingly preserved to maintain its historic elegance while offering modern-day flexibility. Inside, you’ll find five distinct, self-contained units—an incredibly rare opportunity for investors, multigenerational families, or anyone seeking supplemental income while enjoying grand residence of their own. From soaring ceilings and rich wood detailing to vintage accents and architectural flourishes, every inch of this home tells a story. Set on a mature, tree-lined lot with 10+ parking, you’re just steps from Gage Park, top-rated schools, transit, and local shops—making this location as desirable as the home itself. Over size lot may offer varies development opportunities. Don’t miss your chance to own a truly unique piece of Hamilton’s history. (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
275 CUMBERLAND Avenue in Hamilton: Single Family for sale : MLS®# 40749031
275 CUMBERLAND Avenue Hamilton L8M 2A3
$2,199,900Single Family- Status:
- Active
- MLS® Num:
- 40749031
- Bedrooms:
- 9
- Bathrooms:
- 7
- Floor Area:
- 7,186 sq. ft.
Welcome to 275 Cumberland Avenue, Hamilton. A timeless beauty nestled just below the Escarpment, this stately 3-storey mansion is brimming with charm, character, and untapped potential. Located in one of Hamilton’s most cherished neighbourhoods, the home has been lovingly preserved to maintain its historic elegance while offering modern-day flexibility. Inside, you’ll find five distinct, self-contained units—an incredibly rare opportunity for investors, multigenerational families, or anyone seeking supplemental income while enjoying grand residence of their own. From soaring ceilings and rich wood detailing to vintage accents and architectural flourishes, every inch of this home tells a story. Set on a mature, tree-lined lot with 10+ parking, you’re just steps from Gage Park, top-rated schools, transit, and local shops—making this location as desirable as the home itself. Over size lot may offer various development opportunities. Don’t miss your chance to own a truly unique piece of Hamilton’s history. Luxury Certified. (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
141 MARGARET Avenue in Stoney Creek: Single Family for sale : MLS®# 40741347
141 MARGARET Avenue Stoney Creek L8J 3G7
$1,699,990Single Family- Status:
- Active
- MLS® Num:
- 40741347
- Bedrooms:
- 4
- Bathrooms:
- 4
- Floor Area:
- 3,070 sq. ft.
POOL POOL!!!!!New custom built home with full Tarion warranty and INGROUND POOL situated on a prime 43 x 175 size lot in Stoney Creek. This home offers 3075 sq feet of finished space in addition to unfinished 1400 sq feet in the basement with a separate entrance, ideal for an in-law suite. The main floor has a powder room, walk in closet, mudroom with an entrance from the garage, a large kitchen with a breakfast bar, walk in pantry, dinette and a separate dining room . You will also find a cozy family room with a gas fireplace and a separate den/office space on the main floor. There are 4 bedrooms on the second floor, each with an ensuite bathroom and a walk-in closet. For your convenience the laundry room is located on the second floor as well. The home is ready for you to choose the colors and finishes the way you like. (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
OPEN HOUSE: 263 HUMPHREY Street in Waterdown: Single Family for sale : MLS®# 40743153
263 HUMPHREY Street Waterdown L8B 1X4 OPEN HOUSE: Jul 20, 202512:00 PM - 02:00 PM EDTOpen House on Sunday, July 20, 2025 12:00PM - 2:00PM
$1,664,900Single Family- Status:
- Active
- MLS® Num:
- 40743153
- Bedrooms:
- 4
- Bathrooms:
- 4
- Floor Area:
- 4,123 sq. ft.
Welcome to 263 Humphrey Street—an exceptional 4-bedroom, 4-bathroom home offering 3,075 sq ft of finished living space in one of Waterdown’s most coveted neighbourhoods. Designed for families and professionals who value quality, comfort, and smart investment, this property delivers on every level. From the moment you arrive, you'll notice the difference. A concrete driveway, full interlock front walkway, side path, and backyard patio enhance both function and curb appeal. Premium slate grey garage doors and upgraded Vinyl Guard front and walkout doors add a sleek, secure finish. Inside, the home is bright and spacious, featuring triple-glazed North Star windows for superior insulation and energy savings. The open-concept main level flows seamlessly to a stunning European-style bifold patio door that opens to a 12’ x 25’ composite deck with a natural gas line—perfect for entertaining or quiet evenings outdoors. The fully finished basement with walkout offers endless possibilities—ideal for a home office, business setup, or in-law suite conversion. Additional highlights include a Champion 14kW whole-home natural gas generator, a Lennox EL296V high-efficiency furnace, a Lennox PureAir hospital-grade air filtration system, a NuvoH2O citrus-based water filtration system, and an underground water runoff system for the backyard. Thoughtfully upgraded and meticulously maintained, this home is a must-see for buyers seeking long-term value, flexible living space, and high-end systems built to last—all in a quiet, family-friendly community minutes from parks, schools, shopping, and highway access (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
491-493 DEWITT Road in Hamilton: Single Family for sale : MLS®# 40748087
491-493 DEWITT Road Hamilton L8E 5W8
$1,649,999Single Family- Status:
- Active
- MLS® Num:
- 40748087
- Bedrooms:
- 4
- Bathrooms:
- 3
- Floor Area:
- 2,507 sq. ft.
Welcome to 491-493 Dewitt Rd — a truly one-of-a-kind waterfront residence in Stoney Creek’s sought-after lakefront community. This luxury home features a main-level layout ideal for daily living and a fully equipped second-floor apartment perfect for extended family, guests, or rental income. With 4 bedrooms, 4 bathrooms, 2 kitchens, 2 laundry rooms, and spacious open-concept living areas, each level offers a walkout patio or balcony with stunning lake views. Set along a prime stretch of Lake Ontario shoreline, enjoy breathtaking sunrises and sunsets. Live in it as a grand single-family home or maintain two self-contained units — the possibilities are endless. Located minutes from parks, marinas, vineyards, trails, the GO Station, and the QEW. (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
8 HACKNEY Court in Ancaster: Single Family for sale : MLS®# 40732963
8 HACKNEY Court Ancaster L9K 1M3
$1,399,999Single Family- Status:
- Active
- MLS® Num:
- 40732963
- Bedrooms:
- 5
- Bathrooms:
- 4
- Floor Area:
- 5,000 sq. ft.
Stunning Family Home on Quiet Court in Ancaster Meadowlands – 5,000+ Sq Ft of Finished Living Space! This beautifully maintained home offers 3500 sq ft above grade plus 1500 sq ft of professionally finished basement space—providing ample room for family living, entertaining, and multi-generational comfort. Step inside through the grand double-door entry into a spacious, sun-filled foyer with soaring ceilings. The main level features hardwood flooring throughout the formal living room, family room, and an elegant dining room enhanced with timeless wainscotting. A bonus main floor den serves perfectly as a home office, music room, or even a guest bedroom. The spacious eat-in kitchen offers ample cabinetry, a central island, modern appliances, and direct access to the backyard. Upstairs, discover 4 generously sized bedrooms, including a luxurious primary retreat with vaulted ceilings and a unique 13’ x 11’ sitting area ideal for a nursery, workout space, or office. The spa-inspired ensuite features heated floors, a corner Jacuzzi tub, a walk-in shower, and double vanity—your private escape at the end of the day. Two of the secondary bedrooms are connected by a functional Jack & Jill bathroom. The fully finished basement is built for entertaining and extended stays, complete with a home theatre setup, second kitchen, an additional bedroom, and a full bathroom—perfect for guests or in-laws. Step outside to a private backyard oasis on a 50' x 137' lot, complete with a tiered stone patio and mature landscaping—ideal for summer BBQs and peaceful evenings. Quiet, low-traffic court location, Main floor laundry, inside garage entry & side door access, Hardwood in all main living areas, Double garage & extended driveway, close to parks, schools, shopping, and major commuter routes. This one checks all the boxes—space, style, comfort, and location. Don’t miss your chance to own this beautiful home in the Meadowlands! (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
15 PELHAM Drive in Ancaster: Single Family for sale : MLS®# 40734220
15 PELHAM Drive Ancaster L9K 1L4
$1,399,900Single Family- Status:
- Active
- MLS® Num:
- 40734220
- Bedrooms:
- 5
- Bathrooms:
- 4
- Floor Area:
- 4,234 sq. ft.
2903sf plus 1331sf bsmt, this Ancaster executive beauty is perfect for a large family! Main floor office! Separate basement entrance! Oversized lot with 78 ft frontage! 4 car drive! (with room to expand) PLUS! 9ft ceilings on main floor, spacious living room with soaring 17ft ceiling, full suite dining room, family room with fireplace and wall of windows overlooking a super private backyard, spacious kitchen with tons of cabinets and drawers, Brazilian granite and S/S appliances. Main floor laundry/mudroom with access to the garage and side yard. Upstairs are 4 bedrooms incl a huge primary with large walk in closet and 4 pce ensuite, another bedroom with ensuite privilege to a 4 pc bath-perfect for guests, plus 2 more kid sized bedrooms with built in closet organizers. MORE! The fully finished basement gives you an additional 1300+sf of living space with a large family room with a second fireplace and walk up wet bar area, a 5th bedroom, gym or possible 6th bedroom and 2 piece (roughed in for 3)bath. There is direct outdoor access from the basement. There is also a cold room and utility room for storage. The backyard is large and very private with mature trees and low maintenance landscaping and features a large bi-level deck with gazebo. This well maintained, one owner home is situated on a quiet, mature street and will be perfect for your family! Rm szs are approx, irreg taken at widest points. Sq ft not exact (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
-
2352 BRINELL Avenue in Burlington: Single Family for sale : MLS®# 40724239
2352 BRINELL Avenue Burlington L7R 3P5
$1,299,900Single Family- Status:
- Active
- MLS® Num:
- 40724239
- Bedrooms:
- 4
- Bathrooms:
- 3
- Floor Area:
- 3,476 sq. ft.
Vacation Everyday. Splish, Splash.... Summer Oasis. Enjoy swimming in the on-ground pool surrounded by decking. Private, large patio area, lots of sun. Too cold to swim, jump into the Hot Tub. 2 large sheds, oversized 16' x 28' garage. Lovely gardens, fenced yard, circular drive with loads of parking available. Pool has inline chlorine feed and solar blanket with roller. Timer on the pump motor. This 2 storey, 4 bedroom home is on a generous corner lot (62'x120') Shingles 2017. Gutters replaced with Alurex 5 to keep leaves out. Large Principle bedroom with 3 pc ensuite. Main floor laundry, 4 pc bath on the main level. Separate dining room, den and large living room. Addition was done in 1986. Kitchen is bright with an oversized island and stainless appliances. Lower level has a rec room for the kids, 2 separate rooms with endless possibilities, storage and a workshop. Located close to the highway for easy commuting. Shopping, schools nearby. (id:2493) More detailsListed by RE/MAX Escarpment Realty Inc. - DEMIS RASHO
- 860 QUEENSTON RD
- 1 (289) 8087355
- Contact by Email
Data was last updated July 18, 2025 at 08:15 PM (UTC)
Office Location
860 Queenston Rd.
Stoney Creek, ON, L8G 4A8
