Open House

Some or all of the listings below are provided by the Stony Point office.
$5,695,000 (USD)
Active

New Rochelle Area Single Family Home

Active

135 Kensington Oval New Rochelle, NY 10805

8 Bed
6 Baths
10022 sqft
MLS# 928565
Perched to capture sweeping, unobstructed vistas of the Long Island Sound, this extraordinary waterfront estate offers a rare combination of scale, craftsmanship, and resort-style amenities. A commanding 135-foot seawall—complete with a built-in sitting area—gracefully wraps the property, creating a private vantage point for enjoying the ever-changing coastal panorama.
The main level with radiant heated floors, is 4,231 square feet of refined living space, with a welcoming entrance foyer with a powder room, elevator and door to the garage. Anchored by a dramatic great room with soaring 30-foot vaulted ceilings and a wall of glass framing the water beyond. The primary suite is a true sanctuary, featuring panoramic water views, a spacious walk-in closet, dedicated dressing area, and a luxurious spa-inspired bath. A private den and office provide quiet retreats for work or relaxation. The main level also includes a generously sized kitchen outfitted with stainless steel appliances, a laundry room, a guest suite with its own bath, an inviting family room designed for everyday living and entertaining, and a conveniently located powder room. A grand staircase leads to the 1,560 sq ft. upper level, where a striking catwalk overlooks the great room below—an architectural focal point perfectly suited for a baby grand piano, creating a dramatic and elegant setting. This level also features two large bedrooms, each with its own ensuite bath, offering comfort and privacy for family or guests. The additional 4,231 sq. ft. garden level is thoughtfully designed throughout. This level opens via sliding doors to a covered patio, seamlessly connecting to the pool and landscaped yard. It also features a full bath, second laundry room, ample storage, utility room, and a fully equipped summer kitchen—ideal for seamless indoor-outdoor entertaining. The elevator stops at garden level, garage, main and level 2. Outdoors, the property is equally impressive. A 20' x 40' heated gunite pool anchors the backyard, complemented by expansive entertaining areas. The exterior showcases elegant stonework, enhanced by copper gutters and leaders, while all decking, railings, and seawall railings are constructed of durable hot-dipped galvanized steel for longevity in a coastal environment. Additional features include a 100KW natural gas generator, a 10-zone lawn sprinkler system, 400-amp electrical service, and a full-service elevator with stops at the basement, 3 car (861 sq ft.) garage, main level, and upper level—ensuring convenience and accessibility throughout the home. Set within an exclusive waterfront community of just 125 homes, residents enjoy access to exceptional shared amenities, including a private beach, community pool, tennis facilities, and boating opportunities—delivering a lifestyle that feels like a year-round retreat.
Listing by: ONEKEY as distributed by MLS GRID / Howard Hanna | Rand Realty / Scott Cohen
$1,750,000 (USD)
Coming Soon

Ulster Park Area Single Family Home

Coming Soon

81 Union Center Road Ulster Park, NY 12487

3 Bed
2 Baths
1813 sqft
Set on 18.3 scenic acres, this inviting 3-bedroom 1,813 square foot home offers a rare blend of privacy, natural beauty, and functional space. The property features four stocked ponds, peaceful wooded surroundings, and beautiful mountain views—creating a serene retreat just 80 miles from New York City. At the heart of the home is a spacious kitchen designed for gathering and entertaining, featuring generous counter space and an easy flow to the outdoors. Step onto the expansive two-tiered deck and take in peaceful views of your own ponds and a picturesque waterfall—activated effortlessly with the flip of a switch. The first floor features a versatile flex room, ideal for working from home, hosting guests, or creating a cozy den or studio. In the living room, a warm fireplace invites you to unwind on crisp winter evenings. Upstairs, you’ll find three well-sized bedrooms with generous closet space along with an open sitting area that showcases stunning views of the surrounding landscape—perfect for quiet mornings, winding down at the end of the day or additional work and study space. Enjoy the luxury of a 2 car attached garage to keep your car out of the elements. This home has ample storage with attic space, garage storage, and a full unfinished walkout basement. As you venture outdoors, you will find a three-stall barn complete with a tack room, electric, and water, providing excellent space for horses, hobbies, or additional storage. A large 40'x60' detached garage adds even more flexibility for vehicles and equipment. Whether you’re seeking a full-time residence or a weekend escape, this property delivers privacy, tranquility, and a deep connection to nature—all within easy reach of the Hudson Valley’s most charming destinations.
Listing by: ONEKEY as distributed by MLS GRID / Howard Hanna | Rand Realty / Maureen Mayone
$1,750,000 (USD)
Coming Soon

Result Area Single Family Home

Coming Soon

81 Union Center Ulster Park, NY 12487

3 Bed
2 Baths
1813 sqft
Set on 18.3 scenic acres, this inviting 3-bedroom 1,813 square foot home offers a rare blend of privacy, natural beauty, and functional space. The property features four stocked ponds, peaceful wooded surroundings, and beautiful mountain views--creating a serene retreat just 80 miles from New York City. At the heart of the home is a spacious kitchen designed for gathering and entertaining, featuring generous counter space and an easy flow to the outdoors. Step onto the expansive two-tiered deck and take in peaceful views of your own ponds and a picturesque waterfall--activated effortlessly with the flip of a switch. The first floor features a versatile flex room, ideal for working from home, hosting guests, or creating a cozy den or studio. In the living room, a warm fireplace invites you to unwind on crisp winter evenings. Upstairs, you'll find three well-sized bedrooms with generous closet space along with an open sitting area that showcases stunning views of the surrounding landscape--perfect for quiet mornings, winding down at the end of the day or additional work and study space. Enjoy the luxury of a 2 car attached garage to keep your car out of the elements. This home has ample storage with attic space, garage storage, and a full unfinished walkout basement. As you venture outdoors, you will find a three-stall barn complete with a tack room, electric, and water, providing excellent space for horses, hobbies, or additional storage. A large 40'x60' detached garage adds even more flexibility for vehicles and equipment. Whether you're seeking a full-time residence or a weekend escape, this property delivers privacy, tranquility, and a deep connection to nature--all within easy reach of the Hudson Valley's most charming destinations.
Listing by: Hudson Valley Catskills MLS / Howard Hanna | Rand Realty / Maureen Mayone
$1,650,000 (USD)
Active

North Ridgefield Area Single Family Home

Active

35 Aarons Court Ridgefield, CT 06877

6 Bed
6 Baths
4818 sqft
MLS# 24168249
Gracefully set at the end of a quiet cul-de-sac on 1.7 lush acres, this custom-built 6-bedroom Colonial Saltbox offers an exceptional blend of timeless elegance, warmth, and modern comfort. Ideally located near Ridgefield Golf Course with access to Pleasant View Recreation Area, this home is designed for both relaxed living and effortless entertaining.The main level showcases a beautifully updated kitchen with granite countertops, high-end stainless steel appliances, and a spacious dining area that flows into a stunning family room with soaring cathedral ceilings, skylights, and a custom stone fireplace. Formal living and dining rooms, a private study, and a second sunlit family room with a built-in bar and fireplace provide versatile spaces for gatherings. Additional highlights include two powder rooms, expansive decks, a 4-car garage, and a full-house generator.Upstairs, the luxurious primary suite features a tray ceiling, dual closets, and a spa-like bath with jacuzzi and double vanities. Multiple bedroom wings offer flexibility, including an in-law or nanny suite with private living space. A walk-up attic and recent upgrades such as new roof, new boiler and water heater, new a/c condenser, new well, new half bath in basement, new washer/dryer and induction stove top just to name a few. Waiting for your personal touches.
Listing Courtesy of SMART MLS / Howard Hanna | Rand Realty / Kathleen Berg
$1,300,000 (USD)
Active

Hurley Area Single Family Home

Active

32 Pro Court Hurley, NY 12443

4 Bed
3 Baths
3400 sqft
MLS# 972014
Set on six private acres surrounded by mature trees, natural rock outcroppings, and the quiet beauty of the Hudson Valley, this newly constructed 2026 contemporary estate delivers a refined blend of modern design and organic elegance. A striking exterior of Everlast Storm Grey siding paired with warm natural wood accents and expansive windows creates a dramatic first impression while inviting natural light into every corner of the home.

Inside, five inch white oak flooring flows seamlessly throughout the main level, guiding you into a sun drenched living room designed for both relaxation and entertaining. The kitchen is a true centerpiece, thoughtfully curated with a generous center island, custom cabinetry, and an intimate reading nook. A concealed pantry complete with wine cooler, shelving, and prep space offers the perfect hidden hub for hosting, while easy access to the expansive deck invites effortless indoor outdoor living with peaceful woodland views.

The primary suite offers a tranquil retreat with a spa inspired bath featuring a luxurious wet room designed to restore and recharge. A second main level suite with soaring ceilings and a full bath provides exceptional flexibility for guests or multigenerational living. The morning room enhances daily routines with built in cubbies, lounging space, and an organized transition into the day.

Upstairs, two additional bedrooms with oversized closets share a well appointed full bath. Dual staircases add architectural intrigue and lead to unexpected hidden spaces that can serve as reading nooks, creative studios, or private escapes. Custom millwork, designer fixtures, built in shelving, and bespoke doors elevate every detail.

A full walkout basement expands the living possibilities, while state of the art geothermal heating and cooling ensures year round comfort with energy efficiency.

Ideally positioned in the Hudson Valley, this property offers convenient access to the vibrant energy of Uptown Kingston, explore the historic streets, acclaimed dining, and cultural attractions found Uptown. A short drive to Kingston's Rondout area with it's riverfront activities along the Rondout Creek and the Hudson River is another destination with its eateries, shops and museums. Enjoy touring Hurley's Stone House Historic District or play a round at the prestigious Wiltwyck Golf Club. Outdoor enthusiasts will appreciate nearby access to the scenic Hudson Valley Rail Trail, along with hiking, biking and more!

A rare offering that seamlessly blends luxury, privacy, and access to some of the Hudson Valley's most desirable destinations, this home delivers an elevated lifestyle in a truly exceptional setting.
Listing by: ONEKEY as distributed by MLS GRID / Howard Hanna | Rand Realty / Mary Orapello
$1,300,000 (USD)
Active

Hurley Area Single Family Home

Active

32 Pro Hurley, NY 12443

4 Bed
3 Baths
3400 sqft
MLS# 20261014
Set on six private acres surrounded by mature trees, natural rock outcroppings, and the quiet beauty of the Hudson Valley, this newly constructed 2026 contemporary estate delivers a refined blend of modern design and organic elegance. A striking exterior of Everlast Storm Grey siding paired with warm natural wood accents and expansive windows creates a dramatic first impression while inviting natural light into every corner of the home.

Inside, five inch white oak flooring flows seamlessly throughout the main level, guiding you into a sun drenched living room designed for both relaxation and entertaining. The kitchen is a true centerpiece, thoughtfully curated with a generous center island, custom cabinetry, and an intimate reading nook. A concealed pantry complete with wine cooler, shelving, and prep space offers the perfect hidden hub for hosting, while easy access to the expansive deck invites effortless indoor outdoor living with peaceful woodland views.

The primary suite offers a tranquil retreat with a spa inspired bath featuring a luxurious wet room designed to restore and recharge. A second main level suite with soaring ceilings and a full bath provides exceptional flexibility for guests or multigenerational living. The morning room enhances daily routines with built in cubbies, lounging space, and an organized transition into the day.

Upstairs, two additional bedrooms with oversized closets share a well appointed full bath. Dual staircases add architectural intrigue and lead to unexpected hidden spaces that can serve as reading nooks, creative studios, or private escapes. Custom millwork, designer fixtures, built in shelving, and bespoke doors elevate every detail.

A full walkout basement expands the living possibilities, while state of the art geothermal heating and cooling ensures year round comfort with energy efficiency.

Ideally positioned in the Hudson Valley, this property offers convenient access to the vibrant energy of Uptown Kingston, explore the historic streets, acclaimed dining, and cultural attractions found Uptown. A short drive to Kingston's Rondout area with it's riverfront activities along the Rondout Creek and the Hudson River is another destination with its eateries, shops and museums. Enjoy touring Hurley's Stone House Historic District or play a round at the prestigious Wiltwyck Golf Club. Outdoor enthusiasts will appreciate nearby access to the scenic Hudson Valley Rail Trail, along with hiking, biking and more!

A rare offering that seamlessly blends luxury, privacy, and access to some of the Hudson Valley's most desirable destinations, this home delivers an elevated lifestyle in a truly exceptional setting.
Listing by: Hudson Valley Catskills MLS / Howard Hanna | Rand Realty / Mary Orapello
$1,295,000 (USD)
Active

Olive Area Single Family Home

Active

269 Watson Hollow West Shokan, NY 12494

4 Bed
3 Baths
2955 sqft
MLS# 20261714
Set in the quiet, storied hills of West Shokan, 269 Watson Hollow Road offers a rare blend of historic character and natural beauty. Originally constructed in the 1800s as a barn, this distinctive home was thoughtfully relocated across the stream approximately 40 years ago, where it now rests gracefully against the mountain backdrop.16.5 acres extend to the top of the ridge behind the house. Beyond that is NYC property.
Inside, the home showcases its heritage with stunning original chestnut beams--many of which remain structural and weight-bearing--bringing warmth, authenticity, and architectural significance to the living space. A striking chimney, masterfully crafted both inside and out by a local mason, serves as a centerpiece, anchoring the home with timeless craftsmanship.
The setting is equally compelling. A pristine, swimmable spring-fed pond invites peaceful afternoons and reflects the surrounding mountain landscape, creating a private retreat-like atmosphere. The property is accessed by a DOT-approved bridge, accommodating oil and propane deliveries with ease--an important and valuable feature for year-round living.
This is a truly special offering where history, craftsmanship, and nature converge--ideal for those seeking a one-of-a-kind Catskills escape or full-time residence steeped in charm and character.
Listing by: Hudson Valley Catskills MLS / Howard Hanna | Rand Realty / Jeanne Boice
$1,295,000 (USD)
Active

West Shokan Area Single Family Home

Active

269 Watson Hollow Road West Shokan, NY 12494

4 Bed
3 Baths
2955 sqft
MLS# 985068
Set in the quiet, storied hills of West Shokan, 269 Watson Hollow Road offers a rare blend of historic character and natural beauty. Originally constructed in the 1800s as a barn, this distinctive home was thoughtfully relocated across the stream approximately 40 years ago, where it now rests gracefully against the mountain backdrop.16.5 acres extend to the top of the ridge behind the house. Beyond that is NYC property.
Inside, the home showcases its heritage with stunning original chestnut beams--many of which remain structural and weight-bearing--bringing warmth, authenticity, and architectural significance to the living space. A striking chimney, masterfully crafted both inside and out by a local mason, serves as a centerpiece, anchoring the home with timeless craftsmanship.
The setting is equally compelling. A pristine, swimmable spring-fed pond invites peaceful afternoons and reflects the surrounding mountain landscape, creating a private retreat-like atmosphere. The property is accessed by a DOT-approved bridge, accommodating oil and propane deliveries with ease--an important and valuable feature for year-round living.
This is a truly special offering where history, craftsmanship, and nature converge--ideal for those seeking a one-of-a-kind Catskills escape or full-time residence steeped in charm and character.
Listing by: ONEKEY as distributed by MLS GRID / Howard Hanna | Rand Realty / Jeanne Boice