Whitby, Ontario

Welcome to this exceptional A.B. Cairns Coventry Model, ideally situated on a quiet court in the prestigious Queen's Common community of Whitby. Offering over 3,200 sq. ft. of beautifully designed living space above grade, plus a fully finished basement, this executive home combines luxury, comfort, and functionality for today's family. The finished lower level features a spacious recreation room with a cozy fireplace, a fifth bedroom, additional bathroom, making it ideal for guests, extended family, or a private retreat. Designed for both everyday living and effortless entertaining, this impressive home backs directly onto D'Hillier Park, a Large wooded park featuring a ball diamond, tennis courts, a pond and walking paths that provides a peaceful and private setting. Step outside to your backyard oasis complete with an inground pool, perfect for relaxing or hosting family and friends all summer long. With parking for up to six vehicles, this home offers exceptional convenience. Located within the catchment for sought-after schools, including Colonel J.E. Farewell Public School and St. John the Evangelist Catholic School, as well as highly desirable secondary schools, this location is ideal for families. Commuters will appreciate the quick access to Highways 412, 401, and 407, making travel throughout the GTA a breeze. This is a rare opportunity to own a premium executive home in one of Whitby's most coveted neighbourhoods. (id:61476)

Clarington, Ontario

Welcome to sought-after Parkwood Village in the heart of Courtice! This bright and spacious 2-bedroom, 2-bathroom, 2-storey condo townhome is the largest model in the community, offering 1,790 sq. ft. of thoughtfully designed living space. Ideal for families, professionals, or downsizers seeking room without the maintenance, this home features a functional open-concept layout with generous principal rooms throughout. The sun-filled living area flows seamlessly into the dining room, creating an inviting space for everyday living and entertaining. The spacious kitchen offers abundant cabinetry, generous counter space, and a breakfast bar that's perfect for casual meals, morning coffee, or gathering with family and friends. A main-floor private office provides the perfect work-from-home space and could easily serve as a fourth bedroom to suit your family's needs. Upstairs, you'll find two spacious bedrooms, including a generous primary retreat complete with a charming Juliette balcony, private ensuite, walk in closet and plenty of natural light. A large loft offers exceptional flexibility and can easily be used as a third bedroom, family room, media room, or cozy sitting area, adapting to your lifestyle and needs. Enjoy all the benefits of condo living, including exterior maintenance, snow removal, and lawncare. No more shovelling driveways or spending family time on yard work. Residents also enjoy outstanding community amenities, including new pickleball courts, an outdoor tennis court, a heated on-site car wash, BBQ and grilling areas, ample visitor parking, exclusive resident parking, storage lockers, party/meeting rooms and a dog park. Perfectly located close to shopping, transit, schools, parks, and everyday amenities, this home offers the ideal combination of space, convenience, and low-maintenance living. Whether you're looking to upsize or downsize, this is an exceptional opportunity you won't want to miss. New Heat Pump 2021 Hot Water Tank 2025 (id:61476)

Scugog, Ontario

"Living On The Island" Enjoy the resort lifestyle while just a quick drive to the city. Every Day feels Like A Retreat! Breathtaking Property, Straight Out Of A Magazine! Once In A While A Dreamy Property Presents Itself ~ You Don't Want To Miss This Beautifully Renovated Custom Home! 4 Bedrooms, 4 Gorgeous Bathrooms. Triple Car Garage W/ Access To Basement. **Unique Exterior Architecture Sitting On A 120X250 Lot. ** Grand Entrance To Open Wood Staircase, Jaw Dropping Kitchen W/ Quartz Counters, Thermador Appls, B/I Beverage Centre, Oversize Island, Backsplash, Pot Filler. Walk Out To New Deck Off Dining Room. 2 Walk Out To Backyard Oasis - Gazeebo, Fire pit, playground. Surrounded by Nature, Tranquility and stunning lake views. Residents Enjoy boating, fishing, and breathtaking sunsets right from their doorstep. Just Steps To Private Boat Launch. The Great Room Boasts Vaulted 16Ft Ceilings, Floor to Ceiling Windows W/Automated Blinds & Gas Fireplace. Primary Retreat Offers Private Juliette Balcony, W/I Closet W/Organizer + B/I Wall Cabinets, 2 Skylights W/Automated Blinds & Spa Like Ensuite. Finished Lower Level W/ Separate Entrance Perfect In-Law/Nanny Suite or Teen Suite. Features 4th Bedroom, Open Rec Space, Potential Office Space, Full Bath W/Sauna & Lots of addn't Storage. (id:61476)

Clarington, Ontario

Attention All Investors And Developers - Excellent and RARE investment opportunity for 192 Acres of land (App. $14K per Acre!!). This is one of the largest parcels of land currently offered for sale in the Municipality of Durham. The property is only a few minutes away from the 407. Build your dream mansion on this beautiful land or purchase it as an inflation hedge, a haven for protecting cash, or for future developments.. Nearby amenities and services are available, with easy connectivity and accessibility to major highways. There is road frontage on Concession Road 8. (id:61476)

Whitby, Ontario

Welcome to Whitby's Highly Sought-After Lynde Creek Enclave! Tucked away on a private court, this exceptional home has been meticulously Renovated & Updated from top to bottom! Features Include: *Custom Designed Modern Kitchen w/Centre Island , Upgraded Cabinetry w/quartz counter tops, Stainless Steel Appliances, Handy Wall Mounted Pot Filler over the Stove and a stylish espresso/bar station next to the Dining Room! Additional upgrades include *Modern Bathrooms, Updated Roof(2024), Furnace(2017), Newer Gas Fireplace, Hardwood flrs, Smooth ceilings w/pot lights & a Beautiful Oak Staircase accented w/Metal Pickets. A Separate Side Entrance leads to the Finished Basement, providing Excellent Additional living space for recreation, entertaining, or Potential In-law suite accommodation. This home offers an Excellent Floor Plan with a Spacious Family Room that walks out to your huge private backyard! Gorgeous Front & Back Landscaping w/ Stone Front Steps Leading to a New Front Door. Heading into the Backyard you'll find an Oasis that awaits you. Situated on a massive lot, this incredible outdoor space features an Inground Pool surrounded by interlock stone, a charming gazebo & plenty of room for Summer gatherings & Creating Memories. Located in a Desirable, family-friendly neighbourhood close to Downtown Whitby, Hwy. 401 & 412, Excellent schools, Central Park, Lynde Creek, Big Box stores, Walking/Bike Trails, TTC & Go Transit. (id:61476)

Pickering, Ontario

Set on a picturesque 1.1 acre country-sized lot just moments from the city, this beautifully maintained home offers the perfect blend of space, comfort, and convenience. Thoughtfully updated and filled with natural light, the functional layout features 4 spacious bedrooms and 3 bathrooms designed for everyday family living. Warm and inviting principal rooms are enhanced with updated flooring, California shutters, pot lights throughout, and fresh modern paint tones. The heart of the home is the welcoming living area with a cozy wood-burning fireplace - the perfect gathering space on cooler evenings. The bright kitchen offers excellent functionality, complete with a convenient powder room nearby and easy access to the backyard for seamless indoor-outdoor living. Upstairs, the primary retreat features a skylit ensuite with updated flooring, creating a bright and airy space to unwind. Additional practical features include multiple storage closets, direct backyard access from both the garage and built-in rear shed, and an unspoiled basement ready for your personal vision - whether it's a recreation room, gym, or additional living space. Recent updates include the roof (approx. 3 years) and well pump, offering peace of mind for years to come. Outdoors, enjoy summer entertaining on the newly built deck overlooking the expansive property. Ideally located directly across from Valley View Public School, this is a rare opportunity to enjoy tranquil country-style living without sacrificing proximity to everyday amenities. (id:61476)

Pickering, Ontario

There are properties that impress. And there are properties that change the way you live. Set across an extraordinary 62 acres, this custom-built estate offers something few properties can: the freedom to live without compromise. Completed in 2018, the residence was thoughtfully designed to complement the landscape rather than compete with it. Over 7400 sqft of living space which feels open, welcoming, and constantly connected to what lies beyond the glass. Expansive windows invite the outdoors in, while a chef's kitchen appointed with premium Miele appliances creates a natural gathering place for everyday living and effortless entertaining. Outside, the landscape becomes the true centerpiece. Your private man-made pond, complete with its own sandy beach, transforms ordinary afternoons into something that feels worlds away from the city. Whether you're enjoying a quiet morning by the water, hosting summer gatherings along the shoreline, or watching the sunset reflect across the pond, every day feels like a retreat. Beyond the home, an impressive 3200 square foot heated workshop opens the doors to endless possibilities. Whether you're a collector, craftsman, entrepreneur, or simply someone who values exceptional space, it offers the flexibility rarely found on residential properties -not to mention the cabin that is surrounded by lush green space which will have you camping in your own backyard. This is a property that grows with you. A place where children can roam freely, where generations gather for holidays, where passions have room to flourish, and where memories are made against a backdrop that will never go out of style. Because true luxury isn't measured in square footage. It's measured in mornings without noise. In evenings without interruption. In land that offers freedom today-and possibilities for generations to come. This is more than a beautiful home. It's a place your family will remember. It's a legacy property. (id:61476)

Scugog, Ontario

Welcome to this stunning two-story, three-bedroom home boasting breathtaking, unobstructed western views of Lake Scugog. Situated in the serene town of Caesarea, this property offers the charm of small-town living with a strong sense of community, access to parks, green spaces, and a variety of outdoor activities. Set on a spacious large lot, the property provides ample outdoor and indoor space to suit your lifestyle. The ground level features a large, unfinished 27x27 workshop with a separate entrance, offering incredible potential to be transformed into an in-law suite or additional living space. (id:61476)

Clarington, Ontario

Build your dream home on this premium, ready-to-go lot in the heart of Bowmanville! Ideally located at 7 Bradshaw St, just off highly sought-after Concession Street, this exceptional property offers a rare opportunity to secure a large building lot in an established, highly desirable area. Measuring approximately 39.88 x 145.44 feet, this fully fenced lot has already been cleared and is ready for construction - saving you time and upfront costs. With services conveniently available at the lot line, you can move forward with your plans with ease and confidence. Enjoy a family-friendly neighbourhood close to excellent schools, parks, and everyday amenities. Take a short walk to the nearby plaza featuring Circle K, Domino's Pizza, and the local favourite Frosty John's. You're also within walking distance to downtown Bowmanville, where you'll find unique restaurants, boutique shops, and convenient grocery options. Commuters will appreciate the quick and easy access to Highways 115, 401, and 407, making travel throughout the GTA seamless. Whether you're a builder or looking to create your custom dream home, this is a rare opportunity to secure a prime piece of land in a growing, in-demand community. **SEE VIRTUAL TOUR. (id:61476)

Cobourg, Ontario

Escape to the peace and privacy of country living with this beautiful 3-bedroom, 3-bathroom raised bungalow set on 10.8 picturesque acres at the end of a quiet dead-end road. Surrounded by mature trees and rolling hills, this property offers the perfect blend of nature, space, and tranquility. Inside, you'll find a bright and functional layout with spacious living areas, three generous bedrooms, and three bathrooms to accommodate family and guests. The unfinished walk-up basement is a blank canvas, ready for you to create the rec room, in-law suite, home gym, or additional living space you've always envisioned. Outside, the impressive workshop is ideal for hobbyists, contractors, car enthusiasts, or anyone in need of extra storage and workspace. Whether you're enjoying morning coffee overlooking the peaceful countryside, exploring your own acreage, or simply embracing the quiet of rural living, this property offers endless possibilities. If you've been dreaming of privacy, room to roam, and the opportunity to make a home truly your own, this exceptional country property is one you won't want to miss. (id:61476)

Port Hope, Ontario

Welcome to this thoughtfully updated four-bedroom, three-bathroom two-storey home, offering three finished levels of living space on a generously sized lot. Originally built in 1976, this home blends classic charm with refreshed, modern finishes throughout. The bright main and upper levels offer a warm, functional layout with well sized principal rooms. While the fully finished basement adds valuable flexibility; a spacious rec room, home office, or guest space, with easy potential to create a fifth bedroom. Outside, the oversized backyard is a true highlight, featuring a charming gazebo and plenty of room to relax or entertain. An attached garage plus additional parking rounds out the everyday convenience. Ideally located close to schools, parks, and local amenities, and just minutes to Highway 401, this home offers comfort, character, and room to grow in one of the area's most welcoming neighborhoods. (Listing Realtor related to Sellers) (id:61476)

Ajax, Ontario

Lovely 3-Bedroom Condo in a desirable location! Walking distance to shopping, including Sobeys, Shoppers Drug Mart, and more. Perfect for empty nesters or first-time buyers. Bright and spacious living room with a walkout to a west-facing balcony. Functional eat-in kitchen and convenient in-suite laundry. The primary bedroom features a 3-piece ensuite washroom, plus there is an additional 4-piece washroom. This freshly painted corner unit offers approximately 1,157 sq. ft. as per MPAC. The third bedroom is currently being used as a dining room but can easily be converted back to a bedroom, as the door is conveniently stored in the locker. Freshly Painted. Outdoor Pool Is Heated. (id:61476)

Uxbridge, Ontario

Location!!! Two Houses In One Roof. If You've Been Looking For The Perfect Multi-Generational Home Where Everyone In The Family Has Their Own Space, Your Search Ends Here! This Exceptional Estate Home Is Situated On A Beautifully Manicured 1-Acre Property In Goodwood Just Outside Of Stouffville And Uxbridge In The Trail Capital Of Canada. 2 Separate Homes In 1! With Over 5100 Sq-Ft This Home Is A 2 Storey 4 Bed, 4 Baths On One Side & A Bungalow With 2 Beds & 2 Baths On The Other. 2 Full Kitchens That Walk Out To The Huge Entertainers' Yard. Fabulous Decking & 2 Separate Entrances To Each Side. Perfect Setup For The Growing Family Or Nanny Suite. Circular Drive With An Oversized 3 Car Garage. On A Quiet Crescent & Just 30 Min To Toronto. A True Must See Home! Offers Are Welcome Anytime. (id:61476)

Pickering, Ontario

Welcome to 692 Sultana Square, nestled in the highly sought-after Amberlea community of Pickering. The open-concept layout is perfect for modern living and entertaining, featuring a dream kitchen designed for both functionality and gatherings with family and friends. The finished basement provides valuable additional living space, ideal for a recreation room, home office, gym, or guest accommodations. Conveniently located near schools, parks, shopping, transit, and major highways, this home offers the perfect blend of comfort, style, and location. (id:61476)

Oshawa, Ontario

Experience modern living in this beautifully updated 3-bedroom, 2-bathroom condo in North Oshawa, offering 1,144 sq ft of stylish comfort and breathtaking sunset views. Step into a welcoming foyer that leads to a bright, upgraded kitchen with ample counter space and a chic backsplash. The expansive living area flows effortlessly onto a private 19-foot balcony, perfect for unwinding with a view. The master bedroom boasts a 2-piece ensuite, while all bedrooms are generously sized with abundant closet space. Additional features include a convenient storage/pantry area and secure underground parking. Recent updates shine throughout, including the kitchen, bathrooms, flooring, doors, and light fixtures. Enjoy Public transit at your doorstep, shopping & parks nearby. (id:61476)

Clarington, Ontario

Welcome to 305 Sandringham Dr., a well-appointed bungalow located in a desirable, family-friendly Courtice neighbourhood. This home offers 2+3 spacious bedrooms and a fully finished basement, providing excellent living space for families, guests, or extended living. The main level features hardwood and tile flooring throughout. Enjoy two gas fireplaces, one upstairs and the other, with stone surround, downstairs. The kitchen featuring quartz countertops walks out to a bright sunroom offering beautiful views and a relaxing space to unwind year-round. Complete with a double car garage and close proximity to schools, parks, shopping, and commuter routes, this home presents a fantastic opportunity in a growing community. ** This is a linked property.** (id:61476)

Cobourg, Ontario

Located In One Of East Cobourg's Most Established Neighbourhoods, This Spacious 4-Bedroom, 3-Bath Home Is Situated In A Desirable Area Close To Downtown, Cobourg Beach, Parks, Schools, And Local Amenities. The Main Floor Offers 2 Bedrooms, A Full Bath, Living Room, Dining Room, Family Room, And Kitchen. A Two-Sided Gas Fireplace Separates The Living And Dining Areas, Adding Warmth And Character. Bright kitchen With Concrete Countertops And Sunroom Off The Kitchen. Partially Finished Basement With Rec Room Offers Additional Living Space. A Great Opportunity In A Prime Cobourg Location On A 100 x 110 Foot Lot. (id:61476)

Brighton, Ontario

Welcome to 56 Royal Gala Drive, a stunning all-brick & stone, 3 bedroom bungalow nestled in the heart of Brighton's highly sought-after Orchard Gate Estates. Backing directly onto serene greenspace with no rear neighbours, this home elevates everyday living, offering a sophisticated and stylish design that goes far beyond builder-basic finishes. Inside, the bright & airy open-concept living area centers around a chef-inspired kitchen featuring white cabinetry, gas stove, SS appliances, a chic designer backsplash and a spacious breakfast bar-perfect for hosting. The adjacent dining area is defined by a beautiful tray ceiling, adding an extra touch of elegance. Access the rear deck that overlooks the backyard and greenspace through patio doors. The Primary suite is a true retreat, complete with a walk-in closet and a 3-piece ensuite with WI shower. A versatile second bedroom is perfect for guests, or functions ideally as a dedicated home office or den, with fibre internet connectivity available. Convenient main-floor laundry with additional cabinetry and direct inside access from the garage. The lower level offers additional space for family or guests with a cozy Rec Room, bedroom, office space, 2 pc bathroom, storage room plus a large utility room with laundry sink. Premium features: Gorgeous landscaping & gardens, California Blinds, Central Air, HRV, Air Exchanger and a high-efficiency furnace ensure year-round comfort. Located in a quiet, friendly neighbourhood, and just a short walk or bike ride to Brighton's boutique shops, cafes, library, community centre, curling, YMCA, schools, tennis & pickleball courts. Nature lovers will love the proximity to conservation parks and beautiful Presqu'ile Provincial Park, offering hiking trails, renowned bird watching, swimming and sandy beaches. With easy access to the 401 corridor, you are perfectly positioned just an hour from the GTA or Kingston, or a 20 min drive to Cobourg to access the VIA. ** CLICK MORE TO VIEW VIDEO** (id:61476)

Scugog, Ontario

Welcome to your dream waterfront escape with 153 ft of Waterfront! This Exceptional, fully reno'd bungalow offering luxurious year-round living or the perfect season retreat. Extensively renovated from the ground up, this spectacular home began its transformation in 2023 and was completed in 2025, offering the look, feel, and peace of mind of a new home. Showcasing breath taking lake views, pristine, clear water ideal for swimming, boating and making lasting memories. Premium top grade ultra efficient windows by Marvin & Andersen, Exterior pot lights. Newer Dock. Thoughtfully redesigned home, main floor offers an open concept living/dining/kitchen areas perfectly positioned to capture spectacular waterfront views and fill the rooms w/lots of natural light. The Dining room has a w/o to deck O/L lake-an ideal setting for entertaining or relaxing. Two spacious bedrooms, including a spectacular primary retreat off to the side w/panoramic lake views, w/o to private patio with a custom standalone sauna, architecturally designed to blend seamlessly with the home's stone and Hardi board exterior, spa-inspired 4pc ensuite. Hardwood and cork flooring, throughout main floor, 2 Gas Fireplaces, Kitchen offers Granite Countertops and huge center island with additional sink and tons of counter space and cabinetry. The fully finished lower level provides incredible flexibility with a self contained one bdrm suite featuring a full kitchen, sep living and dining with w/o to patio o/l lake, 3 pce bath, additional 2 Gas fireplaces. Ideal for extended family, guests or multi-generational living. Outside, the impressive stone and Hardi board exterior is complemented by a stunning open wood gabled Porch, beautiful gardens, generous parking for 6+ and professionally designed outdoor living spaces that embrace the waterfront lifestyle. Property community water system is serviced and maintained by Shel's Wood, Owners billed yearly $1000.00 for unlimited water & maint free. Insulation R60. (id:61476)

Ajax, Ontario

Welcome to 936 Audley Rd, a bright and spacious 3-bedroom, 2-bathroom freehold townhouse nestled in one of Northeast Ajax's most desirable family-friendly neighbourhoods. Step inside to discover a functional, carpet-free layout offering generous living spaces, perfect for growing families, first-time buyers, or those working from home. Thoughtfully maintained, this home features numerous major updates, including a beautifully renovated main bathroom (2026), new windows (2024), roof (2022), and furnace and central air conditioning (2021), providing peace of mind for years to come. Ideally situated just minutes from Highways 401 and 412, commuting is a breeze. Enjoy the convenience of being close to the Ajax Sportsplex, Ajax Community Centre, Deer Creek Golf Club, parks, schools, restaurants, and everyday shopping, including Costco, Home Depot, and many other popular amenities. Don't miss your opportunity to own this move-in-ready home in a fantastic location! (id:61476)

Pickering, Ontario

Fantastic townhome within walking distance to pickering town centre, Pickering Recreation centre and Pickering Go Station! Recently painted and ready to move in! front porch with sunset views, backyard deck and two full washrooms. Private driveway and Garage with access to the home. (id:61476)

Cobourg, Ontario

Welcome to 400 Westwood Drive - A3, a move-in ready 3-bedroom, 2-bathroom townhome condo offering exceptional value in one of Cobourg's most desirable communities. Pride of ownership is evident throughout this beautifully maintained home, featuring a functional layout, tasteful updates, and a brand-new professionally renovated basement that adds incredible living space and versatility.The bright main floor offers spacious living and dining areas filled with natural light, creating a warm and inviting atmosphere for everyday living and entertaining. The well-designed kitchen flows seamlessly into the main living space, making it both practical and functional.Upstairs you'll find three generous bedrooms (one currently used as a home office) along with an updated full bathroom featuring a new vanity and modern fixtures. The newly renovated basement is a true highlight, offering the perfect space for a family room, recreation area, home gym, office, or playroom, complete with a stylish 2-piece bathroom. Enjoy the ease of low-maintenance condo living just minutes from Cobourg's waterfront, parks, walking trails, schools, shopping, and everyday amenities. Whether you're a first-time buyer, young family, commuter, or investor, this is an outstanding opportunity to own an updated, move-in ready home offering exceptional value in today's market. (id:61476)

Brighton, Ontario

Set on an impressive 50 acres of open land and forested trails, this distinctive Mid-Century Modern roundhouse offers a rare blend of character, privacy, and versatility. An ideal setting for a hobby farm, nature retreat, or those seeking room to explore. Inside, the open principal living space showcases vertical wood walls, a carpet-free layout, and exposed beams along the peaked ceiling. The bright living room features a striking floor-to-ceiling brick fireplace surround and walkout to the wraparound deck, where incredible views create a seamless connection to the surrounding landscape. The open dining area provides ample space for large family dinners and entertaining, while the spacious kitchen offers sleek countertops, generous cabinetry, stainless steel appliances, and a breakfast bar illuminated by pendant lighting. Off the kitchen, a sunken hot tub with walkout to the deck creates the perfect spot to unwind while blurring the lines between indoor and outdoor living. The main floor is complete with two well-appointed bedrooms and a spacious bathroom. The finished lower level offers excellent flexibility with a separate entrance, spacious recreation room with stove-style fireplace and walkout, large bedroom with oversized windows, bathroom, and laundry room. A generator provides added peace of mind no matter the weather. Outside, enjoy expansive outdoor living from the wraparound deck and side deck leading toward the gardens and a meandering path to the detached garage and workshop. Explore forested trails, enjoy the cultivated land, or embrace the possibilities that come with 50 acres of private rural space. All this, while remaining a short distance to local amenities and convenient access to Highway 401. (id:61476)

Cobourg, Ontario

Enjoy the very best of Cobourg's waterfront lifestyle just steps from the lake, marina, beach, and vibrant downtown core. Morning walks along the harbour, afternoons at Victoria Park beach, boating from the nearby marina, and evenings dining at local cafs and restaurants are all right outside your door. This sought-after location offers the perfect blend of scenic lakeside living and everyday convenience with truly low-maintenance condo living. Inside, this bright and beautifully maintained 2 bed/2 bath condo offers a functional layout with spacious principal rooms and an inviting open-concept living area. The living room features large windows and a walkout to a private balcony, offering a comfortable outdoor space to relax, overlooking Downtown Cobourg. The kitchen showcases maple cabinetry, a full appliance package, and ample prep space on the quartz countertops, flowing seamlessly into the formal dining area-ideal for entertaining. The primary bedroom provides generous double closets and an updated 4-piece ensuite, while the secondary bedroom is conveniently located on the other side of the unit, serviced by a 3-piece main bathroom and access to in-suite laundry. Additional highlights include fresh paint, premium laminate flooring, one underground parking space and a storage locker. A wonderful opportunity to enjoy carefree condo living in one of Cobourg's most desirable waterfront communities. (id:61476)