luxury real estate for sale Idaho, United States (page 18)

Spectacular shop-home with Selkirk mountain views on nearly 10 private acres with southwest exposure and exceptional landscaping. Property abuts several hundred acres of partially clear cut woods permissible for hunting and hiking. Located between Coeur d'Alene and Sandpoint, just minutes from Highway 95 and approximately 10 minutes to Silverwood Theme Park, store, and multi retail services at Athol Crossings. Home features 5 bed 3 bath, one bedroom is non-conforming, two floor accessible by a commercial elevator and dual laundry areas. A massive shop and 2 car garage with 400 amp service and RV electric hookup can accommodate a class A motor home and other toys. Two bedrooms and a bathroom configured as separate living areas with potential for guests, multi-generational living, or income producing opportunities. Many custom upgrades, breathtaking views, usable acreage, privacy and recreation, and versatility in one remarkable purchase. Experience the North Idaho lifestyle you dream of

Built in 2021 on over 6 acres, this custom Post Falls estate blends modern yet timeless elegance with the freedom of North Idaho acreage living. The 5-bedroom, 3.5-bath main residence features warm organic finishes, modern farmhouse-inspired designer details, soaring 19' vaulted ceilings in the main living areas, 10' ceilings throughout, and 8ft doors. A newly finished 40x60 shop offers office/storage space plus a 1,140 SF, 2-bedroom, 1.5-bath guest residence ideal for multigenerational living or guest accommodations. Approximately one acre of professionally landscaped grounds creates a park-like setting, while additional acreage offers room for animals, recreation, ATVs, and future improvements. A 35+ GPM well provides abundant water for farm, orchard, equestrian, or garden needs. This rare turnkey luxury estate bordering the Centennial Trail offers unlimited potential with no HOA just minutes from Coeur d'Alene and all of North Idaho's amenities!

Schweitzer Mountain and filtered lake views, deeded sandy beach access, sauna, hot tub and so much more, this stunning property offers luxury North Idaho living with the perfect blend of privacy, space and standout amenities. Vaulted ceilings and exposed beams create an inviting open feel, complemented by a beautifully designed kitchen with granite countertops, propane gas stove, wine closet and large pantry, flowing into a warm living space with a gas fireplace, built in speakers, wired smart home features and interior electric blinds. The main floor master suite features a relaxing garden tub, while outdoor living shines with a large covered porch, gas fire feature & complete outdoor barbecue kitchen, ideal for entertaining or unwinding in a peaceful setting. Additional highlights include raised garden beds, fruit trees and an impressive shop with radiant heat and additional living space. A rare opportunity to enjoy acreage, beach access and luxury North Idaho living

Boasting 742 feet of stunning creek frontage, this exceptional turn-key estate and fully operational RV park offers the perfect blend of luxury, privacy, recreation, and income potential in a highly sought-after North Idaho location just minutes from Sandpoint and area golf courses. The beautifully designed 6-bedroom home features vaulted ceilings, rich wood accents, and a dramatic floor-to-ceiling hand-laid stone fireplace with a massive tree-hewn mantel that serves as a striking focal point and showcases the home's exceptional custom craftsmanship. The chef's kitchen is equipped with premium Dacor appliances, Huntwood cabinetry, double ovens, a commercial refrigerator, and an oversized island with gas cooktop. Thoughtful upgrades throughout include a home security system and abundant storage. Outside, the property shines with Trex decking, extensive parking, an insulated garage/shop with oversized doors, and a peaceful creekside setting ideal for recreation, or relaxation.

Experience luxury living in this exquisite 6,590 sqft custom home on 10 private acres just east of Moscow, ID. Perfectly situated atop a hill, it was designed to offer unmatched views of the Palouse and mountains beyond. Entertain outdoors on the newly redone deck and spacious lower patio, complete with outdoor shower. Inside, enjoy 4 beds, 4 baths, a luxurious master suite, vaulted ceilings throughout, elegant wood trim, fresh paint and Restoration Hardware fixtures. New quartz counters in the well appointed kitchen with Wolf ovens and a Sub Zero fridge. The light filled walk-out basement features a second full kitchen and laundry. A 3-car garage, dual geothermal HVAC, whole-home generator, and two wells with irrigation add convenience to country living. The huge 3,576 sqft shop includes a bathroom, bedroom, and potential for a full apartment with space for all your toys. The beautiful acreage provides equestrian potential. This hilltop gem is a must-see!

Experience the pinnacle of North Idaho living in this masterfully designed residence located within the prestigious Rimrock Meadows community of Hayden. Surrounded by pristine natural landscapes and custom homes, this property presents an unmatched blend of sophisticated comfort and refined style. The interior boasts an open-concept layout characterized by high-end finishes and meticulous attention to detail throughout. The gourmet kitchen is a chef's dream, featuring premium-grade appliances, custom cabinetry, a generous center island, and a dedicated wine refrigerator--perfect for hosting elegant gatherings or enjoying your personal collection. Seamlessly integrated, the living and dining areas offer a warm and inviting atmosphere. The primary suite serves as a serene retreat with a spa-like bathroom, a spacious walk-in closet, and heated floors. Additional bedrooms provide generous flexible space suitable for family, guests, or a dedicated home office. The upper level includes an expansive bonus room, complete with a private bedroom and a full bath, making it an ideal media room, guest suite, or entertaining hub. Step outside to discover a serene professionally landscaped outdoor oasis, complete with a hot tub. This property perfectly captures the North Idaho lifestyle, with easy access to premier outdoor recreation and the stunning Hayden Lake nearby.

The Schweitzer Castle and Château de Melusine. 2 residences. True ski-in/ski-out convenience at Schweitzer Mountain Resort, with balconies offering spectacular views of the ski resort, village, and Lake Pend Oreille. Modern Amenities: Equipped with hydronic heat, high-speed internet, and a private hot tub room overlooking the slopes and a garage. Four levels feature 5+ bedrooms, 4 bathrooms, 22-inch thick stone walls, and curved staircases. Fairytale Interiors: Adorned with hand-carved statues, armor, mounted swords, custom lighting, stained glass, and curated antiques spanning the 15th to 16th centuries. Just outside of Sandpoint, Idaho, and perched on an Alpine mountain spur, these towering stone structures feature striking hand-laid stone facades, turrets, ramparts, and arrow-slit windows, offering a seamless blend of old-world charm and modern luxury. Great trophy property or vacation rental. Whether you enjoy skiing the slopes in the winter or hiking and mountain biking the nearby trails in the summer, this property offers an unparalleled experience for a VRBO or your dream of living like royalty in your personal Castle.

Fully remodeled with an incredible new addition, this 10-acre estate offers refined North Idaho living with views from nearly every room. The gourmet kitchen features quartz countertops, gas range, stainless appliances, and a butler's pantry. Vaulted ceilings, a custom staircase, and a gas fireplace elevate the main living space, opening to a covered patio for seamless indoor-outdoor living. This home offers two primary suites, one on each level. The main-floor suite includes a floor to ceiling stunning fireplace, spa-like bath with a soaking tub, walk-in shower, double vanities, walk-in closet, and an attached office with private access. The upper suite features similar finishes plus a private covered deck. Additional highlights include all new windows, heated attached 3-car garage, 800 sq. ft. detached garage/shop, fenced garden space, and a partially finished basement ideal for a media room or additional living space.

Experience the best of country living on this exceptional Middleton acreage, where panoramic valley views meet luxury living and true hobby farm potential. Extensively transformed with more than $700,000 in upgrades completed from mid-2024 through early-2025, this one-of-a-kind estate offers the freedom to raise horses, livestock, chickens, or other animals-all with NO HOA. Outside, you'll find a new roof, fresh interior and exterior paint, an expanded concrete driveway and patios, professionally designed rock landscaping with 37 newly planted trees, and a new 2025 irrigation system ready to support gardens, pasture, or both. A newly constructed 2,400 SF temperature-controlled RV/toy garage and shop with epoxy floors, paired with the attached garage, provides exceptional space for RVs, equipment, trailers, and recreational vehicles. Inside, thoughtful renovations include new wood flooring throughout the primary suite, main living areas, and three upstairs bedrooms, a stunning remodeled primary suite, and beautifully redesigned pantry, laundry, and mudroom spaces. Additional improvements include a tankless water heater, whole-house humidifier, security system with cameras, and tinted main-level windows. This is a rare opportunity to enjoy modern luxury, wide-open space, and the flexibility of country living just minutes from Middleton, Star, and the Treasure Valley.

Perfectly positioned across from the prestigious Hayden Lake Country Club, this custom residence offers a unique blend of architectural character, thoughtful updates, and an unmatched lifestyle. Framed by towering pines and expansive walls of glass, the home embraces its natural surroundings with light-filled living spaces, custom built-ins, striking stonework, and a seamless connection between indoors and out. For golf enthusiasts, the location is second to none. A transferable Hayden Lake Country Club membership is available, allowing the next owner to bypass the club's current three-year waiting list. Just outside, the iconic hand-carved ''Stuey'' golf statue welcomes members and guests at the entrance to the club-an unmistakable landmark that has become part of Hayden Lake's golfing tradition. Designed for comfortable main-floor living, the home features five bedrooms, four bathrooms, a dedicated office, and generous gathering spaces that are equally suited for entertaining... or quiet evenings overlooking the beautifully landscaped grounds. The spacious primary suite is a true retreat, complete with two walk-in closets, dual vanities, a walk-in shower, private laundry, and a well-appointed ensuite bath.The kitchen opens naturally to the dining and living areas where oversized windows frame peaceful views of the surrounding landscape. A wet bar enhances entertaining, while the lower level provides additional bedrooms, a second laundry and storage room, offering flexibility for guests, hobbies, or multigenerational living.The impressive front patio is an extension of the home's living space, offering a welcoming setting for morning coffee, evening gatherings, or entertaining friends around the gas fire pit. Custom lighting creates a warm evening ambiance, while the built-in gas connection for the BBQ makes outdoor dining effortless.Meticulously maintained flower gardens adorn the backyard, while practical amenities include an attached workshop and RV parking with water and electrical hookups. Major improvements include paver driveway plus new roof, gutters, and interior paint completed in 2021.This is more than a home--it's a rare opportunity to own one of Hayden Lake's distinctive residences in one of North Idaho's most coveted golf course communities.

Experience elevated waterfront living in one of Coeur'd'Alene's most sought-after locations. This beautifully furnished Bellerive Condo is part of only two waterfront residential buildings currently available in the coveted Riverstone community. Perched on the third floor, floor to ceiling windows frame stunning Spokane River views while filling the home with natural light. Designed for both comfort and style, the open-concept layout features a granite kitchen with stainless steel appliances, a cozy gas fireplace, a 5.1 entertainment system, a Nest smart thermostat, and exquisite furnishings thoughtfully curated throughout. Unique designer luxury vinyl flooring adds character and sophistication, creating a truly one-of-a-kind living space. Step outside to your private riverfront deck, finished with elegant wood-tile flooring, a propane grill, outdoor couches, and perfectly positioned to enjoy morning coffee, evening sunsets, and the ever-changing beauty of the Spokane River. The spacious floor plan offers 2 Bedrooms, 2 Bathrooms including a generous primary suite with a walk-in closet and ensuite bath, plus convenient in-unit laundry. The second bedroom has a fold down murphy bed and can be transformed from a bedroom to an office effortlessly. Ceiling fans adorn both bedrooms and living room. The living room and Master Bedroom contain blackout curtains. HOA amenities include water, sewer, garbage, landscaping, shared dock access, fitness, and conference rooms. Your gated secure garage parking spot also incudes private storage. Just steps from restaurants, shopping, Atlas Water Park, The Centennial Trail, a public beach, dog park, and Downtown Coeur d'Alene. Flexible rental opportunities, including short term rentals, make this an exceptional primary residence, second home, or investment property. Current bookings may be transferable to the new owner.

A rare Hayden Lake offering, this luxury waterfront estate boasts 380' of private lake frontage, 3.9 acres, and a 4,682 SF, 5-bedroom and 4.5-bath completely remodeled home designed for entertaining and family gatherings. The chic, elegant interior features honed granite and quartz countertops and beautifully finished living and entertaining spaces. The lake view primary suite is on the main level along with two guest ensuites, while the basement offers 2 additional bedrooms with a full bath. Lush, meticulously landscaped grounds lead to a sandy beach, private dock, and dual covered boat slips for boating, paddleboarding, and magnificent sunset evenings. The property includes a separately parceled 1-acre lot providing potential for a future guest cabin or ADU. This North Idaho waterfront retreat combines acreage, exceptional frontage, modern luxury, and privacy that is difficult to find on Hayden Lake.

Nestled in one of Hayden Lake's most coveted close-in locations, this exceptional waterfront retreat offers 75 feet of pristine shoreline in the peaceful waters of Berven Bay. Recently transformed with a high-end remodel, this 4,457 SF home features 4 bedrooms, 3 beautifully updated baths, quartz countertops, engineered wood flooring, and premium finishes throughout. The open-concept design showcases soaring tongue-and-groove ceilings, a striking stone fireplace, and expansive windows framing breathtaking lake views. The chef's kitchen is appointed with premium appliances, while the main-level primary suite offers a private deck overlooking the lake. A dedicated office with custom built-ins adds flexibility. Just minutes from Hayden Lake Country Club, golf, and town, this is North Idaho waterfront living at its finest. The walkout lower level includes two additional bedrooms, a shared bath, and a spacious family and game room. A charming seasonal guest cottage provides added versatility with 1 bedroom, 1 bath, kitchenette, and living area. A newer dock (2022) completes the waterfront lifestyle, along with a finished 3-car garage with workshop space. Located just minutes from Hayden Lake Country Club, Avondale Golf Course, and local amenities, this is a rare opportunity to own a fully updated luxury waterfront retreat.

Move in ready! Luxury downtown living on 3rd and Front at The Thomas George offering 3 bedrooms, 3 bathrooms + a Den, spanning 2,408 sqft. Primary suite includes a large walk-in closet, soaking tub and walk-in shower. The chef's kitchen includes a large island with seating for 6, plenty of cabinetry and a walk-in pantry. The great room includes a 2 sided gas fireplace and access to the massive wrap around terrace with built-in BBQ. A private and secure 2 car garage and all the benefits of life on Lake Coeur d'Alene are literally at your doorstep. Amenities include a 24 hour gym, golf simulator, indoor/outdoor pool and lakeview community terrace. Photos are of actual unit.

CUSTOM BUILT ESTATE IN COUGAR GULCH! This property is the definition of the North Idaho Dream Property! Location is close to town and all CDA has to offer all while enjoying the privacy of the big country rural setting, some call this location the ''illusion of seclusion''. Catch your own private show of the fireworks over the lake every 4th of July! The large main floor is perfect for easy living and entertaining with views of the mountains and surroundings from every window. Large master suite with two walk in closets and large master bath. Down to the basement is a multi generational setting with its own kitchenette, full bath and bedroom. Walk out of the basement into the garage for easy access in and out. Outdoors there is an included play house and 40x40 shop with lean to. Enjoy a dip in the hot tub after a long day and take in the surroundings! The acreage included in this property is truly diverse with room for more outbuildings, seasonal creek and rare Cedar Grove to take a walk through. This is the one to call home and live the North Idaho Lifestyle! This home is shown by appointment only.

**Seller financing is available**, creating a unique opportunity to acquire one of the most extraordinary lakefront properties on Lake Coeur d’Alene. Encompassing 52 pristine acres with nearly 1,400 feet of coveted shoreline, this remarkable property offers an exceptional setting for an iconic legacy estate. Positioned along what is often called the Riviera of the lake, the land rests on a natural shelf of forest and meadow with sweeping, unobstructed water views.Believed to be the third largest privately held waterfront parcel remaining on the highly sought after north shore, this rare offering presents extraordinary possibilities for a private family compound or thoughtfully developed retreat. Above all, it is a once in a lifetime opportunity to create a generational lakefront legacy. Envision a timeless estate where generations gather, a place where architecture, nature, and lifestyle come together to create something enduring and irreplaceable.With its rare size, commanding presence, and extraordinary frontage, this is more than land, it is the foundation for a legacy that will stand for decades to come. A property of this caliber offers the unique opportunity to create not just a home, but a destination, a sanctuary, and a lasting piece of Coeur d'Alene history.

Experience modern luxury in the coveted Harris North community of the East Boise foothills. This exceptional 4,535-square-foot home offers 5 bedrooms, 4.5 bathrooms, 2 laundry rooms, wine/zoom room, and an oversized 4-car garage with breathtaking views of downtown Boise and the surrounding foothills, all just 10 minutes from downtown. A striking contemporary design showcases a flat roofline, glass garage doors, floating stairs, and dramatic floor-to-ceiling windows that fill the home with natural light and capture the incredible views. The open great room features dual multi-slide glass doors, an enclosed glass wine room, and a chef's kitchen with premium Wolf and Sub-Zero appliances. The main-level primary suite is a private retreat with expansive views, a spa-inspired bath, oversized walk-in closet, and direct access to the laundry room. Complete with a full upscale landscaping package, this home offers luxury living just minutes from downtown Boise, the Boise River, Lucky Peak, and endless hiking and biking trails.

Only minutes to downtown Boise, BSU, Ann Morrison Park, Kathryn Albertson Park, freeway access, and large local area employers. The Morris Hill Apartment complex is a collection of 4 fourplex buildings (16 units total), each building individually parceled to offer flexibility with financing and/or future subdivision. Each building has 2 units on the main level (w/ slab patio) and 2 units upstairs (w/ deck). Each unit offers: 780 SF, 2 bedrooms, 1 full bathroom, living room, kitchen, dining room, washer/dryer hookups/closet, patio/deck, covered parking, & exterior storage closet. Recent updates include: Front stairs/landings replaced at all buildings within last 5 years; Exterior paint at 3701 in 2022; Exterior paint at 3695, 3697, and 3703 in 2015; Fascia and gutters at 3701 in 2024; New HVAC in units 10, 11, and 12 in 2024; new water heaters in units 6, 10, and 14 in 2024-2025. When units turn over, generally we replace carpet/flooring as needed, freshen interior paint, and evaluate appliances.

For the most discriminating buyer, this 4000 sf custom build by respected Legacy Homes exceeds all expectations w its fine features & finishes, brilliant design, & tasteful combinations of neutral & bold colors. Better-than-new condition on a sprawling .46 acre lot in Eagle's coveted Creighton Woods community. Homeowner added $140k after-market upgrades to make this home functional & impressive. See attached list of specific features. An impressive foyer welcomes friends & family into an open gathering area, the heart of the home - kitchen, eating & great room- perfect for entertaining. A wide hallway leads to a private office & a lovely guest suite suitable for multi-generational, a 2nd primary, or teen living. The kitchen is a chef's delight with a superior appliance package. And don't miss the best butler's pantry ever w built-in wine rack, wine cooler, refrigerator & freezer drawer units & another full size stainless sink. The huge rec room is around the corner with a wall of windows. After a game of billiards & an adult beverage, slip out to grill dinner then drop the screen & start your fav movie. Upstairs is where you'll find the luxurious primary en-suite with gorgeous views of the private pond, a loft bonus & 2 large secondary bedrooms. A massive 4-car with RV bay will capture his attention-epoxied floor, 2-220V to charge Evehicles, solar battery storage, custom shelving.

Perched above the shimmering waters of Lake Coeur d'Alene in the desirable gated community of Harbor View, this extraordinary home offers everything you need to live a beautiful North Idaho lifestyle. Located just south of downtown Coeur d'Alene, the property combines privacy, luxury, and truly jaw dropping lake views. Completely remodeled with thoughtful design and elevated finishes, the home captures spectacular views from nearly every room. From Gozzer Ranch Golf & Lake Club across the water to Sanders Beach and the surrounding mountains, the scenery is simply breathtaking. The spacious floor plan offers just under 4,500 square feet with 4 bedrooms and 3.5 bathrooms, creating the perfect balance of comfort and functionality. The luxurious primary suite is a private retreat featuring a stunning en suite bathroom and peaceful lake views that greet you each morning. Expansive living spaces are designed to maximize the scenery, with large windows and open gathering areas that bring the outdoors in. Whether you are entertaining guests or enjoying a quiet evening at home, the setting is unforgettable.For those who work remotely, the home provides ideal spaces for a private office or creative workspace, all while surrounded by inspiring lake and mountain views.This Harbor View residence is a rare opportunity to enjoy refined living overlooking one of the most beautiful lakes in the Pacific Northwest. Just minutes from downtown Coeur d'Alene, yet tucked away in a private gated community, it is the perfect blend of luxury, serenity, and convenience.

Luxurious sanctuary with river access and resort-style living on a rare one-acre estate in one of Eagle’s most coveted locations with no HOA. Originally built as a former builder’s personal residence, this home offers a level of quality construction and architectural substance rarely found in today’s new builds. The spacious single-level-plus-bonus floorplan features fresh interior paint, refinished walnut hardwood floors, soaring ceilings, and 8-foot interior doors. The gourmet kitchen with Thermador and Viking appliances opens to the great room with views of the pool and fully stocked private pond. Additional features include a junior suite, home office, media room, built-in Sonos sound system, and large bonus room that can serve as an additional bedroom. Outdoor living is designed for entertaining with an approximate 3,000 SF patio, heated 20’x50’ saltwater pool, built-in outdoor kitchen with premium Memphis grill, and custom firepit at the water’s edge. Enjoy your own fishing rock overlooking the pond or take a short stroll to the Boise River. Expansive 6-car garage includes oversized bays with room for multiple vehicles, boat, or RV parking. Neighboring home recently sold for $3.65M, making this an exceptional opportunity to own a legacy property in one of Eagle’s finest settings.

Welcome to Dude Dewalt Cellars & Event Center – a rare opportunity to own a piece of Idaho history on a gorgeous hilltop estate with 360-degree Treasure Valley views. Located in the rugged Eagle foothills, this award-winning winery was established in 2011 and named to honor the pioneers of this incredible region. The 5,615 SF custom home sits on 34.60 acres of rolling hills, offers endless views and borders BLM land. Recently updated with new carpet, lights, and paint, the home is move-in ready. Ideally positioned off HWY 16 with a dedicated turn lane, the property is a premier and unique event center, approved for up to 24 events annually with 250 guests and unlimited gatherings under 125. Even more, it has been approved for additional buildings—creating exceptional opportunity for future expansion and growth. A 50x60 shop includes 3 RV bays, half bath, office, and generous storage. Vineyards feature Malbec, Tempranillo, Cabernet Sauvignon, Cabernet Franc, and Syrah. Follow your dreams today!

***MEMBERSHIP INCLUDED*** with this BRAND NEW LUXURY TERRACE AT PRESTIGIOUS BLACK ROCK. An ideal golf getaway with two bedroom suites, 2.5 baths and 1,832 sq ft of living space. Open & inviting great room and chef's kitchen with soaring two-story ceilings, stunning stone fireplace and large sliding doors to incorporate the expansive back patio. The primary master suite offers main level convenience with direct outdoor access. The secondary suite on the upper level is perfect for extended-stay guests. Attached golf cart garage plus detached 1-car garage. Conveniently located near the clubhouse with easy access to Club amenities. Income earning potential in the Club's rental program for Club members. ***Agents, please see private remarks regarding membership.

CLOSE-IN LAKE LIVING WITH PANORAMIC COEUR D'ALENE LAKE VIEWS. Perfectly positioned above the shoreline just minutes from downtown Coeur d'Alene, this exceptional retreat offers 67' of waterfront, a private dock, and the ideal balance of privacy and convenience. The thoughtfully designed 5-bedroom, 4.5-bath residence is oriented to maximize spectacular lake views, with expansive windows and generous wraparound covered decks creating an effortless connection to the lake and unforgettable sunsets. A private one-bedroom guest apartment above the garage provides exceptional flexibility for visitors, multi-generational living, or income potential. Enjoy boating and paddleboarding on Coeur d'Alene Lake, nearby access to the Centennial Trail for year-round outdoor recreation, and the convenience of downtown Coeur d'Alene just minutes away.

First time offered in 28 years, this well-maintained legacy Spokane River waterfront estate presents a rare opportunity to own one of Coeur d'Alene's most coveted waterfront properties. The home offers 4 bedrooms and 2.5 bathrooms and an office (or 5th bedroom) with a custom open-concept entertainer's kitchen, dining, and sunken living room with water views. Situated on 70 feet of prime Spokane River frontage, this residence offers a year-round paradise with generous indoor and outdoor spaces for entertaining, relaxing, and making lasting memories. Enjoy the sauna, sandy beach, and boating or water sports from your own custom dock with a powerboat lift and a jet ski slip with a lift. Set on a .35-acre lot with an attached two-car garage and an 1100 square foot detached shop/garage, this unique property is ready to make your own. Just minutes from downtown Coeur d'Alene, Post Falls, Spokane Airport, golf courses, dining, and recreation, don't miss this one; it will go fast! Whether preserving its timeless character or creating your dream waterfront retreat, this is a once-in-a-lifetime opportunity to own exceptional waterfront in CDA-don't miss this one!