- Overlooking the Bay
- Saint Barthelemy
- Unique Homes Ultimate Cover Home
Sort by
- Price - High To Low
- Newest
- Lot area - High To Low
- Sqft - High To Low
- Favorites
▾
- Price - Low To High
- Price - High To Low
- Newest
- Lot area - Low To High
- Lot area - High To Low
- Sqft - Low To High
- Sqft - High To Low
- Favorites
$1,797,500
5Beds
5Baths
COLUMBIA, Missouri, 65203, United States
Inspired by the relaxed elegance of Blackberry Farm, this remarkable estate invites you to slow down and savor the beauty of home. Nestled on 10 private acres in prestigious Providence Point, this nearly 4,000 sq ft retreat offers 5 bedrooms, 4.5 baths, and timeless craftsmanship throughout.
CENTURY 21
$1,797,500
7875 S SMITH HATCHERY RD
5Beds
5Baths
COLUMBIA, Missouri, 65203, United States
Inspired by the relaxed elegance of Blackberry Farm, this remarkable estate invites you to slow down and savor the beauty of home. Nestled on 10 private acres in prestigious Providence Point, this nearly 4,000 sq ft retreat offers 5 bedrooms, 4.5 baths, and timeless craftsmanship throughout. The chefs kitchen features Cambria quartz, Viking appliances, Sub-Zero refrigeration, and a custom white oak dinette. White oak floors, custom cabinetry, wainscoting, and a stone fireplace create warmth and sophistication. Enjoy sunrise and sunset views from the covered porches with outdoor fireplace, surrounded by peaceful acreage and the quiet luxury of country living.
Read More
CENTURY 21
$1,797,500
7875 S SMITH HATCHERY RD
5Beds
5Baths
$1,797,500
COLUMBIA, Missouri, 65203, United States
$1,797,000
5Beds
3,270Sqft
Sandpoint, Idaho, 83864, United States
Welcome to your private storybook escape on 10 pristine acres with Grouse Creek frontage. This extraordinary stone estate, built by a renowned castle builder, blends old-world craftsmanship with modern comfort.
CENTURY 21
$1,797,000
Lot 2A Country Meadows
5Beds
3,270Sqft
Sandpoint, Idaho, 83864, United States
Welcome to your private storybook escape on 10 pristine acres with Grouse Creek frontage. This extraordinary stone estate, built by a renowned castle builder, blends old-world craftsmanship with modern comfort. Set at the end of a private drive in Sandpoint’s picturesque Selle Valley, the home captivates with its dramatic rooflines, hand-laid shingles, and porte cochere entry, all surrounded by fenced meadows, treed horizons, and serene creek frontage. A 40x50 gravel pad is already in place, ideal for a future barn, shop, or additional structure. A propane Generac generator, supported by two 1,000-gallon propane tanks, provides exceptional peace of mind during wind and snow storms, ensuring reliable power to the property year-round. Crafted entirely of timeless materials, the residence features double wall construction with river rock exterior, stone interior walls, solid oak and quartzite slate floors with in-floor hydronic heating, a tankless on demand gas water heater for hot water all the time and an additional 50-gallon backup hot water heater. The entire system of the home can run on a backup gas powered generator or tie into solar power for self-reliability at all times. Inside, every detail reflects artistry: custom dark walnut cabinetry, walnut-trimmed windows and porcelain countertops, Norman wood shutters, Hunter Pirouette shades, solid wood doors, and exquisite hand-carved accents including a detailed banister and arches. A Russian inspired dual-use open flame brick fireplace and woodstove adds extra warmth on those long cold winter nights emitting heat from the thermal stone mass of custom laid bricks. Imported Bertazzoni ovens from Italy enhance both the homes function and design. Adding to the magic, the gothic-inspired garage features front and back handcrafted carriage-style doors that swing open, whimsical wide-plank man doors, and an additional attached carport. Above the garage, a sunlit studio and spa retreat await. The studio showcases floor-to-ceiling picture windows, a mini woodstove, artist loft, wet bar with wine fridge, and a spa-inspired bath with soaker tub and full sauna. A hand-carved balcony overlooking the property completes this retreat, while the porte cochere with an expansive open deck seamlessly connects the studio to the main house. This is a home where castles inspire, fairy tales begin, and old-world charm awaits. A one-of-a-kind estate crafted with a level of artistry that cannot be replicated. A rare residence that evokes timeless European charm for generations to come. With its private setting and separate studio retreat, the property also offers exceptional potential as a bed and breakfast or short-term rental destination.
Read More
CENTURY 21
$1,795,900
4Beds
5Baths
0.70Sqft
Greensburg, Pennsylvania, 15601, United States
Experience refined living in this custom-built modern ranch overlooking the scenic Totteridge Golf Course, offering panoramic fairway & mountain views. Designed as the builders personal residence, this home showcases superior construction & elegant design throughout.The open floor plan features soaring ceilings, stone fireplaces, & walls of glass framing the picturesque setting.
The REMAX Collection
$1,795,900
2099 Totteridge Dr
4Beds
5Baths
0.70Sqft
Greensburg, Pennsylvania, 15601, United States
Experience refined living in this custom-built modern ranch overlooking the scenic Totteridge Golf Course, offering panoramic fairway & mountain views. Designed as the builders personal residence, this home showcases superior construction & elegant design throughout.The open floor plan features soaring ceilings, stone fireplaces, & walls of glass framing the picturesque setting. The designer kitchen includes Omega cabinetry, GE Monogram appliances, & a twelve-foot waterfall quartz island. Two wet bars & beverage refrigerators make entertaining effortless.The primary suite offers tray ceilings, a spa-style bath with soaking tub, and a custom walk-in closet. The walk-out lower level includes a full bar & recreation space, while the nearly fifty-foot deck captures sweeping golf course views. Andersen windows, Sonos sound system, Nest thermostats, 2 EV chargers, & a 3-car epoxy garage complete this exceptional home in The Village of Banbury, minutes from major routes & Greensburg.
Read More
The REMAX Collection
$1,795,900
2099 Totteridge Dr
4Beds
5Baths
0.70Sqft
$1,795,900
Greensburg, Pennsylvania, 15601, United States
$1,795,000
5Beds
4Baths
0.32Sqft
Snohomish, Washington, 98296, United States
Ideally located in the desirable Gold Creek community an east facing grand entry welcomes you. This beautifully updated custom home offers a versatile floor plan creating a warm inviting atmosphere.
The REMAX Collection
$1,795,000
6417 158th St SE
5Beds
4Baths
0.32Sqft
Snohomish, Washington, 98296, United States
Ideally located in the desirable Gold Creek community an east facing grand entry welcomes you. This beautifully updated custom home offers a versatile floor plan creating a warm inviting atmosphere. Extensive hardwoods flow to the stunning remodeled kitchen with an abundance of cabinets featuring granite counters, upgraded appliances, designer lighting & an 11 x 5 center island - blending style & function. The open concept family room is enhanced by large west facing windows & floor to ceiling custom cabinetry. Rounding out the main level are formal living & dining rooms plus a private office with its own fireplace ideal for either a media or game room. Upstairs are four spacious secondary bedrooms (one with an en-suite) a laundry room & three quarter bath. The luxurious primary suite doubles as a retreat with its own sitting area & fireplace - the private spa-inspired bath has a heated tile floor, a freestanding tub, double sized shower & enormous walk in closet. The 3 car garage features professional grade amenities - perfect for the hobbyist. A private staircase off the main floor hall leads to a standing height crawl space of over 500 sq ft. Beautiful backyard is fenced with an entertaining size patio & covered area. The Gold Creek community offers parks, playfields, sport courts, & greenbelt walking trails. Only minutes to Willis Tucker County Park; plus a short jaunt to Mill Creek shopping or historic downtown Snohomish. This home is an exceptional property.
Read More
The REMAX Collection
$1,795,000
6417 158th St SE
5Beds
4Baths
0.32Sqft
$1,795,000
Snohomish, Washington, 98296, United States
$1,795,000
2Beds
2.5Baths
1,760Sqft
Pompano Beach, Florida, 33062, United States
Live Like Youre on Vacation Every Day in this stunning oceanfront corner unit w/ North, East & West exposures in one of Floridas most beautiful Beaches. Spacious 2 bedroom, 2.5 bath residence features a wrap-around balcony w/ 500 sq. ft. of outdoor living space-perfect for soaking in breathtaking views of the ocean, Intracoastal & city skyline through floor-to-ceiling windows.
Homes and Land
$1,795,000
730 N Ocean Boulevard E 1501
2Beds
2.5Baths
1,760Sqft
Pompano Beach, Florida, 33062, United States
Live Like Youre on Vacation Every Day in this stunning oceanfront corner unit w/ North, East & West exposures in one of Floridas most beautiful Beaches. Spacious 2 bedroom, 2.5 bath residence features a wrap-around balcony w/ 500 sq. ft. of outdoor living space-perfect for soaking in breathtaking views of the ocean, Intracoastal & city skyline through floor-to-ceiling windows. Open-concept layout, Italian cabinetry, quartz countertops w/waterfall-edge kitchen island & top-of-the-line Miele & Sub-Zero appliances. This Sabbia Beach residence redefines resort-style living w/ premium amenities. Located just minutes from Ft. Lauderdale Intl Airport & Two Private Airports. Pompano Beach Pier, Dining & entertainment & minutes to Las Olas Blvd fine dining, shopping & entertainment.
Read More
Homes and Land
$1,795,000
730 N Ocean Boulevard E 1501
2Beds
2.5Baths
1,760Sqft
$1,795,000
Pompano Beach, Florida, 33062, United States
$1,795,000
4Beds
4.5Baths
4,839Sqft
Sevierville, Tennessee, 37862, United States
Experience the ultimate in scenic luxury with this stunning home that truly has the wow factor. Revel in breathtaking long-range views of Cove Mountain and beyond, both from the home itself and the second building site on lot 68-perfect for a guest house or additional garage, spanning a total of 5.77 acres.
Homes and Land
$1,795,000
4476 Whetstone Road
4Beds
4.5Baths
4,839Sqft
Sevierville, Tennessee, 37862, United States
Experience the ultimate in scenic luxury with this stunning home that truly has the wow factor. Revel in breathtaking long-range views of Cove Mountain and beyond, both from the home itself and the second building site on lot 68-perfect for a guest house or additional garage, spanning a total of 5.77 acres. Situated on wide, county-maintained roads, this property offers four spacious bedrooms and 4.5 baths. The fireplaces add cozy ambiance, while the gourmet kitchen boasts a commercial oven and range, warming drawer, and more-carefully customized by the owners, with details available in the documents. Whether youre seeking a permanent residence, a second home, or an overnight rental, this home offers versatile living options. Elegant stained-glass windows, multiple decks, and inviting patios complete this exceptional property, making it a truly remarkable place to call home. Stack washer/dryer, dishwasher in basement stay Refrigerator in basement does not stay. Upstairs small new refrigerator in game room stays.
Read More
Homes and Land
$1,795,000
4476 Whetstone Road
4Beds
4.5Baths
4,839Sqft
$1,795,000
Sevierville, Tennessee, 37862, United States
C$1,795,000
3Beds
2Baths
Chatsworth, ON, N0H1K0, Canada
Set a ways back from the paved road, this farm has it all! 121 acres of pasture, workable farmland, mixed bush, a meandering creek, and well-equipped buildings for a variety of farming endeavors.
LUXVT Real Estate Marketing Real Estate Marketing
C$1,795,000
116826 GREY ROAD 3
3Beds
2Baths
Chatsworth, ON, N0H1K0, Canada
Set a ways back from the paved road, this farm has it all! 121 acres of pasture, workable farmland, mixed bush, a meandering creek, and well-equipped buildings for a variety of farming endeavors. Surrounded by mature trees with views of the horse paddocks from the veranda, the home blends the charm of the original farmhouse-pine floors, solid wood cabinets, and a cozy woodstove-with the added space of a bright, modern addition. The farmhouse includes a welcoming kitchen, family room, office or optional bedroom, and a three-piece bath, while the addition features a large, light-filled living room with deck access; a primary bedroom; a four-piece bath; a laundry room; and an attached double garage. Upstairs offers a loft sitting area and a second bedroom, and the basement boasts a spacious rec room with a built-in bar and pool table. Outbuildings include a 36 x 48 horse stable with four 12 x 12 box stalls; heated tack room with plumbing; a 43 x 50 bank cattle barn with concrete barnyard and separate well; a 266" x 466" driveshed; and a 40 x 566" coverall building. (id: 58753)
Read More
LUXVT Real Estate Marketing Real Estate Marketing
$1,795,000
3Beds
3Baths
3,648Sqft
Prescott, Arizona, 86305, United States
* SOCIAL MEMBERSHIP INCLUDED*From the moment you enter through the stately iron gate into the enclosed courtyard, youre greeted by a tranquil and peaceful atmosphere that sets the tone for this exceptional property.Inside, this home offers timeless architectural with a spacious, open, and airy floor plan--ready for you to create the living space youve always envisioned.
Homes and Land
$1,795,000
15345 N Badlands Circle
3Beds
3Baths
3,648Sqft
Prescott, Arizona, 86305, United States
* SOCIAL MEMBERSHIP INCLUDED*From the moment you enter through the stately iron gate into the enclosed courtyard, youre greeted by a tranquil and peaceful atmosphere that sets the tone for this exceptional property.Inside, this home offers timeless architectural with a spacious, open, and airy floor plan--ready for you to create the living space youve always envisioned. The living room features art niches, and Large windows frame stunning views of lush trees and the manicured greens beyond.The oversized kitchen is a dream for entertainers and culinary enthusiasts alike. The master suite is overlooking the serene landscape. The master bath and walk-in closet are generously sized and full of potential.Guests will appreciate the privacy of the detached 2 bedroom suite. The garage has extra room, it fits a large sized pick up truck as well as another car and golf cart or 2. There are also 3 storage or workrooms attached. Not your typical 2 car garage.
Read More
Homes and Land
$1,795,000
15345 N Badlands Circle
3Beds
3Baths
3,648Sqft
$1,795,000
Prescott, Arizona, 86305, United States
$1,795,000
5Beds
4Baths
0.34Sqft
Boulder, Colorado, 80301, United States
MULTI-GENERATIONAL LIVING OPPORTUNITY!! Welcome to 4398 Carter Trail, an exceptionally unique home in the highly sought-after Gunbarrel Green neighborhood backing to the Boulder Country Club Golf Course on a .34 ACRE lot offering a park-like backyard with mature landscaping and trees.
The REMAX Collection
$1,795,000
4398 Carter Trl
5Beds
4Baths
0.34Sqft
Boulder, Colorado, 80301, United States
MULTI-GENERATIONAL LIVING OPPORTUNITY!! Welcome to 4398 Carter Trail, an exceptionally unique home in the highly sought-after Gunbarrel Green neighborhood backing to the Boulder Country Club Golf Course on a .34 ACRE lot offering a park-like backyard with mature landscaping and trees. In addition to the main home, there is a 1,400 SQFT, fully equipped separate main-level living space with kitchen, dining area, spacious living room, large main floor bedroom with over-sized bath, huge walk-in closet, washer/dryer, private entrance and separate backyard ideal for parents, in-laws, guest suite or rental income. The 2-story main home offers a traditional style floor plan with thoughtful separation of living spaces, formal living/dining rooms, a dedicated office/study space ideal for remote work, eat-in kitchen equipped with cherry cabinetry, slab granite counters and stainless appliances and a huge family room with vaulted ceilings, fireplace and skylights that bring in plenty of natural light. For peaceful mornings or relaxing evenings retreat to the screened in back porch to relax and enjoy the view. The upper floor offers 4 generous sized bedrooms, 3 that share an updated full bath and the primary suite with walk-in closet and updated bath with walk-in shower. The finished basement offers an additional place to spread out and plenty of terrific storage space. With easy access to the Boulder Country Club and terrific Gunbarrel amenities including an extensive network of trails, shops, restaurants and breweries, 4398 Carter Trail offers a rare opportunity to enjoy refined living in a peaceful and picturesque setting. Choose between top-rated Fairview & Boulder High School.
Read More
The REMAX Collection
$1,795,000
5Baths
6,900Sqft
GAP, Pennsylvania, 17527, United States
Welcome to 6058 Buena Vista Road, a private estate where timeless craftsmanship and modern luxury converge. Set on 5.7 professionally landscaped acres spanning both Chester and Lancaster Counties, this remarkable property offers seclusion, panoramic countryside views, and convenient access to regional destinations.
BHHS Fox & Roach Realtors
$1,795,000
6058 BUENA VISTA ROAD
5Baths
6,900Sqft
GAP, Pennsylvania, 17527, United States
Welcome to 6058 Buena Vista Road, a private estate where timeless craftsmanship and modern luxury converge. Set on 5.7 professionally landscaped acres spanning both Chester and Lancaster Counties, this remarkable property offers seclusion, panoramic countryside views, and convenient access to regional destinations. From its locally sourced, hand-cut stone exterior to its resort-style outdoor living and extraordinary primary suite, every element has been thoughtfully curated. Offering more than 6,900 square feet of finished living space, this turn-key home is available due to relocation. Extensive investment in recent years has refined both form and function, creating a residence that feels grand yet welcoming.A landscaped, lighted flagstone walkway leads to a custom entry and into a dramatic two-story foyer with a 19-foot ceiling and cascading staircase. The space is anchored by custom judges paneling and wide 7.5-inch pecan hardwood floors throughout the main level. The former living room is now a billiards room with custom shelving, while the dining room features wall-to-wall cabinetry and updated lighting for entertaining or daily use. The kitchen, fully reimagined in 2023, features an expansive quartz island, custom cabinetry, dual Thermador ovens and induction cooktop, and two dishwashers. A see-through scullery/butlers pantry adds flexibility with an ice machine, bar sink, additional cabinetry, and Thermador refrigeration including wine, refrigerator, and freezer. The breakfast room includes one of four fireplaces and opens to a covered rear deck with sweeping views across Lancaster County. The adjoining family room features custom built-ins and a second fireplace. A vaulted sunroom with flagstone flooring, gas fireplace, and floor-to-ceiling windows offers a tranquil year-round retreat. The outdoor kitchen (2022) includes a Fire Magic grill, Evo cooktop, and Big Green Egg under a StruXure pergola. Completing the main level is a gym, mudroom with custom cubbies, and an additional refrigerator and freezer. The heated two-car garage was updated in 2025 with a speckled floor coating, storage walls, and new doors.Upstairs, the primary suite is a private retreat accessed through a sitting room with custom cabinetry and hidden refrigeration drawers. The bedroom sits behind sliding doors with four windows capturing countryside views. Two walk-in closets offer exceptional storage, with a relocated laundry room between them. The primary bath features dual vanities, a private wash closet, soaking tub, heated floors, and a custom Kohler shower with steam, multiple sprays, and a picture window overlooking the landscape.Three additional bedrooms complete the second floor, including one en suite and two sharing an updated hall bath. The daylight lower level is designed for entertaining with a golf simulator, family room, dining area, and wet bar with under counter refrigeration, ice machine, and dishwasher. A full bath and patio doors lead to a covered outdoor lounge with TV.The pool and spa, built in 2020, feature hydraulic covers and are surrounded by multiple outdoor living areas for year-round enjoyment. Additional highlights include a whole-house generator and fully floored unfinished walk-up attic. A cleared area across the driveway allows for a future 5-car garage.Conveniently located five minutes from Route 30 and within 30 minutes of Malvern, Lancaster, Reading, and Kennett Square, this property offers a rare blend of luxury, privacy, and accessibility.
Read More
BHHS Fox & Roach Realtors
$1,795,000
6058 BUENA VISTA ROAD
5Baths
6,900Sqft
$1,795,000
GAP, Pennsylvania, 17527, United States
$1,795,000
5Beds
7Baths
4,617Sqft
Graford, Texas, 76449, United States
Experience the best of lake living in this exceptional home located in the highly sought-after Harbor community. Perfectly positioned to capture stunning lake views, this fully furnished residence offers a seamless blend of luxury, comfort, and convenience.
CENTURY 21
$1,795,000
2141 Century Oak Drive
5Beds
7Baths
4,617Sqft
Graford, Texas, 76449, United States
Experience the best of lake living in this exceptional home located in the highly sought-after Harbor community. Perfectly positioned to capture stunning lake views, this fully furnished residence offers a seamless blend of luxury, comfort, and convenience. Designed with both entertaining and relaxation in mind, the home features 5 spacious bedrooms—each with its own private en suite—including multiple primary suites, ideal for hosting family and guests. Two expansive living areas provide plenty of space to gather, unwind, and enjoy the lake lifestyle. Step outside to your private backyard retreat complete with a spool, perfect for cooling off after a day on the water while taking in the breathtaking views. Offered fully furnished, this home is truly turnkey and ready for immediate enjoyment. Located just a short walk from the marina, you’ll have effortless access to boating, dining, and everything the Harbor has to offer. Whether youre searching for a full-time residence, or a weekend escape, this property checks every box.
Read More
CENTURY 21
$1,795,000
2141 Century Oak Drive
5Beds
7Baths
4,617Sqft
$1,795,000
Graford, Texas, 76449, United States
$1,795,000
3Beds
2.5Baths
4,743Sqft
Perris, California, 92570, United States
Searching for a luxury home in Lake Mathews on acreage with panoramic lake and mountain views? This 4,743 sqft custom estate on 2.85 acres at 20390 Christo Ct captures sweeping 180 degree views of Lake Mathews, an infinity edge pool, and expansive indoor outdoor living designed for elevated Southern California living.
Homes and Land
$1,795,000
20390 Christo Ct
3Beds
2.5Baths
4,743Sqft
Perris, California, 92570, United States
Searching for a luxury home in Lake Mathews on acreage with panoramic lake and mountain views? This 4,743 sqft custom estate on 2.85 acres at 20390 Christo Ct captures sweeping 180 degree views of Lake Mathews, an infinity edge pool, and expansive indoor outdoor living designed for elevated Southern California living. Set above the surrounding landscape, this fully custom designed estate blends architecture, craftsmanship, and breathtaking scenery. The property showcases 180 degree panoramic views over Lake Mathews, stretching toward Orange County in one direction and the San Bernardino Mountains and Big Bear in the other. Sunrises, sunsets, and evening lights create a dynamic and ever changing backdrop. The outdoor space is designed to highlight the view, featuring an infinity edge pool that visually connects to the horizon, along with custom water features, statues, and an outdoor bathroom and shower for poolside use. Multiple seating areas allow for both large scale entertaining and quiet moments overlooking the lake. A private front courtyard with a covered sitting area and fireplace offers an inviting space for relaxing or entertaining, adding a second outdoor living environment separate from the pool area. Inside, vaulted ceilings and natural stone flooring create a sense of scale and warmth throughout. Large windows and thoughtful orientation bring natural light into the living spaces while framing the surrounding views. The oversized kitchen includes a large pantry with butler prep area and opens to a formal dining space with a custom painted ceiling, ideal for hosting and everyday living. The primary suite features a fireplace, dual exterior access, a spa style bathroom with soaking tub and walk in shower, and an expansive walk in closet with a connected flex room for office, gym, or nursery. With 4,743 sqft, the layout offers flexibility to create additional bedrooms, guest suites, or multi generational living options. Additional features include a detached four car garage, oversized climate controlled attached garage, two HVAC systems updated approximately 1.5 years ago, and two water heaters. Luxury home in Lake Mathews on acreage opportunities with this combination of views, land, privacy, and scale are rare. Schedule a private tour to experience it in person.
Read More
Homes and Land
$1,795,000
20390 Christo Ct
3Beds
2.5Baths
4,743Sqft
$1,795,000
Perris, California, 92570, United States
Favorite this home
Enter your email to continue
or
By signing in you agree to UniqueHomes Terms of Use and Privacy Policy
Loading properties...