German-Inspired Hill Country Estate with large guesthouse/ multi use space - Unrestricted and Just Off the 290 Wine Trail. Luxury, flexibility, and timeless design come together on this stunning 6.85 acre Fredericksburg estate-ideal for private living, short-term rental, or commercial use such as a tasting room or event space. Located along the sought-after 290 Wine Trail, this gated 2-story property offers an exceptional lifestyle and income opportunity with no restrictions. The main residence showcases a light-filled, open layout with vaulted wood-beam ceilings, travertine floors, and a floor-to-ceiling limestone fireplace. The chefs kitchen features custom cabinetry, glass-front uppers, a farmhouse sink, and premium Wolf appliances, all centered around a stylish butcher block island. The main house also has an attached double garage. The spacious dining and living areas offer panoramic views and effortless flow-perfect for entertaining or relaxing. A grand entry with bead board ceilings leads to the main-level primary suite, which includes a generous layout and a spa-inspired bath with soaking tub, walk-in shower, and dual vanities. Upstairs, enjoy a versatile game/media room and private office space with 3 bedrooms and 2 bathrooms. The detached guest house features 3 bedrooms, 3.5 bathrooms, a full kitchen, and an expansive living area. Downstairs, a massive workshop/game area and oversized garage add serious functionality-whether for hobbies, events, or business use. Outdoors, unwind under the covered pergola with stone fireplace, soak in the private hot tub, or take in scenic views from the second-story balcony. Whether youre looking for a multi-generational retreat, an STR investment, or a commercial vision in a top-tier location, this property delivers.

Located in the heart of downtown Los Angeles, this contemporary and spacious residence presents a rare opportunity to own a highly coveted home in the prestigious Ritz-Carlton Residences. The stunning haven, which is one of the buildings largest units, has been thoughtfully redesigned to combine sophisticated elegance with modern functionality. As soon as you step inside the breathtaking 47th-floor unit, you will be greeted by a vibrant interior adorned with impeccable high-end finishes. Every detail has been carefully curated, from the gleaming hardwood flooring to the handcrafted tiled accent walls and striking designer wallpaper. Enhanced with upgraded spotlighting, the high ceilings create an airy and open atmosphere above the main gathering areas. The floor-to-ceiling curtain glass walls frame sweeping city views, providing a stunning backdrop for entertaining in the living room and dining area. The opulent lighting sets the mood for intimate dinner parties, while the mirrored accent wall adds a touch of glamour and visually expands the space. The exceptional kitchen is a culinary enthusiasts dream, featuring a suite of state-of-the-art Gaggenau stainless steel appliances, sleek European-inspired cabinetry, and luxurious quartz countertops. Guests can sip drinks at the oversized, multi-seater bar with two convenient wine refrigerators while you showcase your culinary skills. The thoughtfully designed bedrooms offer an inspiring start to your day, each equipped with built-in organizers in the closets for the discerning fashionista. One bedroom is ensuite, while the others share a well-appointed bathroom. The generous primary suite offers both comfort and style, with a seating area by the picture window where you can unwind and enjoy a nightcap while watching the sunset paint brilliant streaks across the sky. The luxurious 5-piece ensuite bathroom features a double vanity, Robern medicine cabinets, a separate shower, and a spa-like soaking tub overlooking the horizon. A deep walk-in closet completes this private sanctuary. Glass barn doors imported from Germany reveal abundant storage space, ensuring a clutter-free environment. Other notable features include an in-unit washer/dryer for added convenience. Living in this residence grants you access to the world-class amenities that the Ritz-Carlton is renowned for, including a resort-like pool and spa, two levels of community lounges, a private conference room, an exercise room, and room service. Additionally, you can enjoy the benefits of the Ritz-Carlton Hotel. The unbeatable location at LA Live, downtown LAs vibrant shopping, dining, and entertainment district, puts everything you need right at your doorstep.

Timeless elegance in Westports renowned Old Hill. Set on 2.22 bucolic acres w/a heated Gunite pool & picturesque pond, this expansive 5-6 bedroom,4.5 bath farmhouse blends classic charm w/thoughtful recent enhancements that delivers a renewed sense of style & energy to the home. A renovated kitchen remains the heart of the home, featuring a generous center island & a stunning, glass-walled breakfast nook which allows for basking in natures splendor while savoring a meal. Fresh interior updates incl. a newly painted family room, updated lighting w/two new chandeliers, a modern backdrop for comfortable everyday living. This precious home has been refreshed throughout to highlight its impressive scale, open flow, & architectural character. The sun drenched primary ste is a true retreat w/a fireplace, spa like bath & generous walk in closet. A flexible floor plan offers multiple living areas & a potential in law suite-ideal for multi generational living, guests, or work from home needs. Four wood burning fireplaces add to the homes timeless appeal. Outdoors, enjoy a thoughtfully landscaped property, the pool & spa, set amidst such soothing natural surroundings. Additional highlights: city water & sewer, a whole house generator, & the bonus of exceptional privacy just moments from town. Old Hill is one of Westports most coveted neighborhoods, known for its quiet, tree lined streets & unbeatable proximity to town, schools, & commuting. A rare opportunity to own a special home.

Experience true luxury in this meticulously remodeled 5-bedroom, 5.2 bath, 4,983 sq.ft. colonial located in an exclusive gated community. The homes all-limestone exterior and newly painted interior/exterior create a timeless, elegant look. Inside, discover a state-of-the-art kitchen outfitted with Bertazzoni appliances, stunning Calacatta Berlin granite countertops, and custom Ridge cabinetry with glass inserts, alongside a sleek new concrete deck and patio with glass railings. The homes design includes high-end upgrades in every space, including the expansive master suite, with a spa-like bath featuring White Crystalla granite and his-and-hers walk-in closets. The fully finished walk-out basement adds an entertainment hub with a luxurious wet bar, Rose Gold Crystalla granite, a new theater room with top-tier projector, screen, and recliner seating, plus a basement kitchenette. Cutting-edge technology runs throughout the property, including an advanced security system with a dedicated control room and whole-home Bluetooth integration. Smart bidet toilets, stylish blackout roller shades in all bedrooms, premium carpeting, and custom lighting by Royce Lighting add touches of convenience and sophistication. Outdoors, enjoy beautifully landscaped grounds with hydrangeas, Green Giant Arborvitae, and fresh mulch in a private, tranquil setting. This homes extensive updates and prime location make it an exceptional opportunity in luxury living.

DIRECT WATERFRONT WITH 100 of PRIVATE BEACHFRONT AND RARE OPPORTUNITY TO BUILD A STUNNING HOME ON COMPO MILL COVE WITH A POOL. This is the lifestyle you have been dreaming of. A little slice of Paradise. Come breathe in the saltwater air and see all that this hidden jewel has to offer located on Compo Mill Cove, a gated private waterfront enclave of 19 homes. This property offers the rare opportunity to build on one of the most iconic oceanfront estates in all of Westport on one of the largest lots on the Cove just steps from the footbridge. A four-season canvas of nature painted by sun and tide, breathtaking panoramic views are the hallmarks of this prominently sited property with water views of the Long Island Sound and Sherwood Mill Pond on both sides. Sunsets, abundant wildlife including Blue heron, egrets and butterflies grace the landscape and are guaranteed to make the background of your phone and computer!! Enjoy your coveted private access to the Long Island Sound and your own sandy beach, whether by swimming in the glorious water, playing in the sandbars, embarking on a paddle board adventure, or taking a sunset sail. Return to your waterfront sanctuary to dine & dance under the stars, and enjoy a nightcap while taking a stroll around your glorious, manicured property while admiring the pristine shoreline. Live like you are on vacation year-round on your own private sanctuary in the perfect place.

Welcome to a one-of-a-kind lakefront sanctuary, where every detail has been thoughtfully designed to create an inviting and cozy haven. Nestled along Lake Hartwell and spanning over 4 acres combining the 2.9 parcel and the 1.5 corps owned, this exceptional home offers a perfect blend of warmth and charm, providing a peaceful escape from the everyday. Step outside to experience outdoor living with expansive porches providing breathtaking lake views, a covered dock, and a custom pool set in North Carolina flagstone. The private in-ground pool, surrounded by greenery, creates a peaceful setting for relaxation and entertainment, with every room in the home overlooking this oasis, perfect for hosting or quiet enjoyment. Upon arrival, you are greeted by the grandness of the estate. Spanning over 4300 sq ft in the main home, this estate is perfect for full time residency or family vacation home. As you cross the threshold through majestic double doors, the stunning wood burning stone fireplace commands your attention soaring to an impressive 22 feet. Everyone loves the smell of a wood fire. Each stone in this estate was meticulously transported by train, taking months to place; testament to the craftsmanship invested in creating such an architectural masterpiece. The newly remodeled kitchen combines modern functionality with timeless style, featuring a sleek tile backsplash that adds a touch of elegance and a high performance gas stove for the passionate cook. A standalone refrigerator and freezer provide generous space for all your culinary needs, complemented by a large pantry and ample storage solutions. An oversized window above the double sink offers a beautiful view of the gardens, fishpond, waterfall, allowing natural light to flood the space. The owners suite is a private retreat within this spatial estate. You escape reality when you sink into bed overlooking the lake with a stunning oversized window. This main level suite also features separate his and hers bathrooms and a large walk-in closet. Working, crafting, or any hobby can easily be enjoyed tucked away from the home in the attached office which opens onto the lower porch where you can savor the tranquil views of the lake. The home boasts two additional suites on the upper level, each equipped with its own full bathroom and walk-in closet, providing privacy and comfort for both family members and guests. This level also includes a flexible sleeping loft and a library overlooking to the spacious gardens. The upstairs loft offers a stunning vantage point overlooking the grand expanse of the great room below, creating a sense of openness and connection throughout the home. The loft is a versatile space perfect for a playroom, sitting area, extra sleeping space or game room. Sunlight pours in through the large windows, enhancing the lofts airy ambiance. Double doors open to a sprawling 750 square foot second story deck, where you are greeted by breathtaking views of the pool and Lake Hartwell. The deck becomes an ideal spot for outdoor dining, morning coffee, or unwinding with the tranquility of water views and gentle breezes. The main house has an attached 2 car garage. Below the guest house, a spacious 10-car garage offers extensive room for an auto collection, indoor storage for boats, or workshop with a private half-bath and laundry. Attached to this lower-level garage is a charming greenhouse, ideal for cultivating plants and gardening. The guest house oasis has a large front porch overlooking the estate gardens and pool. This large apartment is an ideal space for guests with its open layout. Within the 850 sq ft you will find a large bedroom, a full bath, living space, dining area and full kitchen with a large island with laundry access below. You truly have to see this home in person to experience every magnificent detail that is offered. Full 1 Year Transferable Home Warranty includes pool and guest house. SC Licensed Agent is related to the seller.

Welcome to a one-of-a-kind lakefront sanctuary, where every detail has been thoughtfully designed to create an inviting and cozy haven. Nestled along Lake Hartwell and spanning over 4 acres combining the 2.9 parcel and the 1.5 corps owned, this exceptional home offers a perfect blend of warmth and charm, providing a peaceful escape from the everyday. Step outside to experience outdoor living with expansive porches providing breathtaking lake views, a covered dock, and a custom pool set in North Carolina flagstone. The private in-ground pool, surrounded by greenery, creates a peaceful setting for relaxation and entertainment, with every room in the home overlooking this oasis, perfect for hosting or quiet enjoyment. Upon arrival, you are greeted by the grandness of the estate. Spanning over 4300 sq ft in the main home, this estate is perfect for full time residency or family vacation home. As you cross the threshold through majestic double doors, the stunning wood burning stone fireplace commands your attention soaring to an impressive 22 feet. Everyone loves the smell of a wood fire. Each stone in this estate was meticulously transported by train, taking months to place; testament to the craftsmanship invested in creating such an architectural masterpiece. The newly remodeled kitchen combines modern functionality with timeless style, featuring a sleek tile backsplash that adds a touch of elegance and a high performance gas stove for the passionate cook. A standalone refrigerator and freezer provide generous space for all your culinary needs, complemented by a large pantry and ample storage solutions. An oversized window above the double sink offers a beautiful view of the gardens, fishpond, waterfall, allowing natural light to flood the space. The owners suite is a private retreat within this spatial estate. You escape reality when you sink into bed overlooking the lake with a stunning oversized window. This main level suite also features separate his and hers bathrooms and a large walk-in closet. Working, crafting, or any hobby can easily be enjoyed tucked away from the home in the attached office which opens onto the lower porch where you can savor the tranquil views of the lake. The home boasts two additional suites on the upper level, each equipped with its own full bathroom and walk-in closet, providing privacy and comfort for both family members and guests. This level also includes a flexible sleeping loft and a library overlooking to the spacious gardens. The upstairs loft offers a stunning vantage point overlooking the grand expanse of the great room below, creating a sense of openness and connection throughout the home. The loft is a versatile space perfect for a playroom, sitting area, extra sleeping space or game room. Sunlight pours in through the large windows, enhancing the lofts airy ambiance. Double doors open to a sprawling 750 square foot second story deck, where you are greeted by breathtaking views of the pool and Lake Hartwell. The deck becomes an ideal spot for outdoor dining, morning coffee, or unwinding with the tranquility of water views and gentle breezes. The main house has an attached 2 car garage. Below the guest house, a spacious 10-car garage offers extensive room for an auto collection, indoor storage for boats, or workshop with a private half-bath and laundry. Attached to this lower-level garage is a charming greenhouse, ideal for cultivating plants and gardening. The guest house oasis has a large front porch overlooking the estate gardens and pool. This large apartment is an ideal space for guests with its open layout. Within the 850 sq ft you will find a large bedroom, a full bath, living space, dining area and full kitchen with a large island with laundry access below. You truly have to see this home in person to experience every magnificent detail that is offered. Full 1 Year Transferable Home Warranty includes pool and guest house. SC Licensed Agent is related to the seller.

Iconic stately colonial on 1.5 lusciously landscaped acres! Walking distance to Westfields hustling & bustling downtown. Undeniably gorgeous, spacious, private, & luxurious. Elegant entertaining at its finest, both indoors & out. Beautiful covered blue stone patio for outdoor gatherings or relaxing evenings. 8 gracious bedrooms, including 3 bedrooms & full bath on 3rd level offering privacy for guests. Gourmet chef kitchen with expansive island, breakfast bar, & adjoining family room with fireplace & exquisite cabinetry. Sport court on the rear of property.Understated classic elegance coupled with todays luxuries & conveniences.

Soak up the sun and skyline views from your private rooftop deck, accessed via a fully retractable skydoor-just one of the many standout features of this meticulously updated brownstone at 271 Decatur Street in Stuyvesant Heights. In a city where private outdoor space is rare, this home offers multiple opportunities to enjoy the outdoors in style. The parlor level welcomes you with striking contrast: natural light fills the space while black wainscoting, moldings, and original restored staircase banisters add bold sophistication. Wide archways create a gracious flow from the living room to the formal dining area and into a sleek, modern kitchen outfitted with black cabinetry, geometric tilework, and a full suite of stainless steel appliances. On the garden level, an oversized bedroom, full bath, and a versatile recreation space offers ultimate flexibility-perfect as a guest suite, home office, or additional sleeping quarters. Step outside to your private backyard retreat for al fresco entertaining or quiet morning coffee. The second floor features two spacious bedrooms, a stylishly tiled full bath, and a bonus room ideal for a study or additional bedroom. Upstairs, the third floor mirrors the layout with three more bedrooms, another full bath, and abundant closet space throughout. One more flight brings you to your rooftop-a true urban oasis-perfect for lounging, entertaining, or taking in panoramic Brooklyn views. Conveniently located near the A and C trains at Utica Avenue and surrounded by beloved neighborhood favorites like Peaches and Saraghina, this home offers the perfect blend of charm, space, and connectivity.

Looking for a newer townhome near Deer Valley that works as both a personal getaway and a nightly rental? Built in 2022, this 4-bedroom, 3.5-bath home offers mountain and lake views, open living spaces, and an easy connection to the outdoors. The great room features 18-foot ceilings and hardwood floors, creating a bright, open feel thats perfect for gathering after a day on the trails or the mountain. The kitchen is designed for real use, with Viking appliances, a gas range, quartz countertops, a built-in refrigerator, and a large island that comfortably seats three. Step outside to the private patio, already set up with a hot tub pad, and take in the views. An oversized two-car garage provides space for vehicles and gear. Nightly rentals are allowed, offering flexibility when youre not using the home yourself. Located minutes from Jordanelle Reservoir, the Jordanelle Perimeter Trail, and just three minutes from Deer Valley East Village, with Salt Lake City International Airport about 40 minutes away, this home makes it easy to enjoy every season.

Waterfront Italian Villa in The Cascades Experience timeless elegance and lakefront luxury in this stunning custom-built Italian Villa perfectly positioned on one acre in the prestigious Cascades community. With a stone exterior, tile roof, and meticulous craftsmanship throughout, this home blends classic European style with modern sophistication. Step inside to discover decorative ceilings in every room, beautiful flooring, and expansive windows framing breathtaking views of Bellwood Lake. The thoughtfully designed floor plan offers six bedrooms, five full baths, and two half baths, providing ample space for family and guests. The chefs kitchen is a culinary masterpiece, featuring Sub-Zero refrigerators and freezers, double ovens, double dishwashers, and a gas cooktop with griddle-perfect for entertaining or preparing family meals. A study offers a quiet retreat for work or reading, while the media room upstairs, complete with its own private bath, is ideal for movie nights or gaming. Step outdoors to your private paradise. The outdoor living area includes a stone fireplace, dining space, and a fully equipped outdoor kitchen-perfect for gatherings under the stars. Enjoy the infinity-edge pool with a separate hot tub, both overlooking the tranquil waters of Bellwood Lake. Every detail of this property reflects elegance, comfort, and sophistication, from the luxurious finishes to the breathtaking water views. This Italian-inspired villa offers a rare opportunity to own a true masterpiece of architecture and design in one of the areas most exclusive lakefront communities. Experience resort-style living every day-welcome home to The Cascades.

Located in the prestigious community of Silverhorn in Rocky View County, 61 Silverhorn Blvd is a custom-built modern bungalow that combines contemporary architecture with the serenity of nature. Built on a 1.5-acre lot, this home offers 5 bedrooms, 2.5 bathrooms, and a three-car heated garage with radiant in-floor heating. The exterior showcases a sophisticated mix of dark stone, white and charcoal stucco, and natural wood accents, while triple-pane black-framed windows frame the surrounding prairie landscape. Inside, soaring ceilings and southwest-facing windows create an airy, light-filled atmosphere grounded by wide-plank white oak floors. The great rooms 17-foot vaulted ceilings and full-height charcoal tile fireplace establish a dramatic yet welcoming focal point, connecting seamlessly to a refined kitchen featuring Legacy Dcor cabinetry, quartz counters, brass hardware, and a full suite of Wolf and Bosch appliances. The adjoining butlers pantry enhances convenience with extra workspace and storage. The primary suite serves as a tranquil retreat with vaulted ceilings, rolling hill views, and a spa-like ensuite complete with heated porcelain tile floors, dual vanities, a freestanding tub, and a glass-enclosed shower with dual rain heads. The walkout lower level extends the living experience with a wet bar and pass-through window for entertaining, a spacious recreation area with a porcelain fireplace wall, a private theatre room, a home gym, a spa-inspired bathroom, and guest accommodations. Outdoor living is equally impressive, with upper and lower patios overlooking two private ponds, complemented by glass railings, Duradek surfacing, natural wood soffits, and integrated lighting for year-round enjoyment. The heated three-car garage is designed for enthusiasts, offering epoxy floors, high ceilings, EV charging stations, and space for lifts or advanced storage systems. Thoughtful upgrades throughout include smart home systems, triple-pane windows, solid-core doors, radiant heat, air conditioning, and natural gas hookups on both patios. Backing onto protected greenspace with no possibility of future development, this property delivers privacy, craftsmanship, and modern luxury in perfect balance. Just minutes from northwest Calgary, Silverhorn offers 50 acres of natural reserve, scenic trails, and mountain vistas-creating a rare combination of architectural excellence, functional design, and connection to the landscape.