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 / Listed By: Scott Cohen, Howard Hanna | Rand Realty
$1,349,500 (USD)
Active

North Ridgefield Area Single Family Home

Active

35 Aarons Court Ridgefield, CT 06877

6 Bed
6 Baths
4818 sqft
MLS# 24168249
Motivated sellers! Please present all offers. 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 deeded rights 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 / Listed By: Kathleen Berg, Howard Hanna | Rand Realty
$1,200,000 (USD)
Active

New City Area Single Family Home

Active

20 Sandstone Trail New City, NY 10956

5 Bed
3 Baths
3284 sqft
MLS# 991039
Virtual Tour
NEW CITY, NY: Experience the elegance of this beautiful 5-bedroom, 3-bath 3200+ sq. Ft Contemporary Colonial, an oasis of privacy nestled on nearly an acre of manicured, park-like property. Located in coveted Renella subdivision of North New City. This lovely home offers timeless sophistication, expansive living spaces, and an ideal layout for both everyday living and entertaining all at the historic foothills of South Mountain Road.
Gracious sized, bright eat-in kitchen features a center island, abundant light cabinetry, granite countertops, stainless steel appliances, and French doors leading to a sprawling deck — perfect for outdoor gatherings and backyard entertaining. Open to the kitchen is the grand-sized Den ( 20 X 32) with soaring ceilings, walls of glass, dramatic trapezoid windows, rich wood flooring, Adorned with a beautiful wood-burning fireplace. French doors to the picturesque backyard, level rear yard prime for an installing an In-Ground pool, tennis court or an outdoor kitchen.
A dramatic, two-story foyer steaming with abundance of natural daylight, welcomes you with marble flooring and a graceful winding staircase. The elegant formal dining room showcases wood floors and crown moldings, while the formal living room provides the perfect setting for entertaining guests in style.
The spacious primary en-suite features a bright spa-like bath with a skylight for abundant natural light, a relaxing soaking tub, and a separate shower, double vanity. Soaring ceilings and walk in closet. Full finished walk out basement boasts -private home gym, second Den and space for a home office. Expansive (3) car garage for ultimate storage space with newly finished epoxy flooring. Additional highlights include: new central air conditioning, Roof approx. 2017, generously sized bedrooms, newly installed driveway 2024, and beautifully maintained grounds that create a true private retreat.
38 miles to NYC, Approx. 8 miles to NJ transit train in Nanuet, access to all major roadways - NYS Thruway, Palisades Parkway and Garden State Parkway. Minutes to Bear Mtn State park for hiking, picnics and majestic Hudson River views from the top of Perkins Drive. Clarkstown amenities include: access to (3) town pools, athletic fields, hiking paths, family events, holiday celebrations and so much more. Dog Friendly Zukor Park minutes away offer walking paths alongside babbling brook. Come experience the allure of this beautiful home.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Valerie Moldow, Howard Hanna | Rand Realty
$999,000 (USD)
Active

Mahopac Area Single Family Home

Active

266 Shear Hill Road Mahopac, NY 10541

5 Bed
5 Baths
5200 sqft
MLS# 1004364
Exceptional custom built house on a majestic tranquil piece of property. Legally approved for one bedroom apartment with walk out in lower level. The beautifully landscaped property features a resort-style backyard for your private oasis or entertaining. The architect designed, built and lived in this home since new. Open floor plan with seamless flow for kitchen, dinning room and family room. Large center island kitchen. Dinning room with vaulted ceiling and stunning glass chandelier. Large windows and sliding glass door to look over the landscaped gardens. Family room with fireplace. Huge formal dinning room and half bath. Attached 2 car garage and mud room make up the first floor. Second floor primary suite with massive walk in closet. Big spa like primary bathroom with stand up shower and soaking tub. Three more bedrooms and two full baths. Ample sized laundry room with folding table and new machines. House has new central A/C and fairly new boiler. The serene back yard is private and perfect for entertaining. Pavers and garden paths. Tiered flower beds and ornamental trees. Sprawling front manicured lawn make for dramatic entry. This home comes with membership to beautiful Lake Cassie for swimming, fishing boating and club house. Close to Train, highways, shops and restaurants.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Richard Castro, Howard Hanna | Rand Realty
$975,000 (USD)
Active

Castle Hill Area Multi-Family Home

Active

437 Torry Avenue Bronx, NY 10473

7 Bed
3 Baths
2314 sqft
MLS# 1005811
I am excited to introduce you to 437 Torry Avenue, a beautifully refreshed and fully renovated two-family brick home located in the desirable Castle Hill vicinity of the Bronx.
This charming residence has been thoughtfully restored to its original beauty, featuring a classic brick Two family, a spacious backyard, and a convenient two-car driveway. The property also boasts a newly coated roof, installed this past summer, and new stainless steel front gates, all meticulously maintained.
The first-floor duplex unit offers four generously sized bedrooms and two bathrooms, providing ample space for comfortable living. The top-floor unit features three bedrooms and one bathroom, complete with a brand-new kitchen, updated bathrooms, and fresh paint throughout. Both units benefit from an abundance of natural sunlight, contributing to a warm and inviting atmosphere.
Situated on a serene, tree-lined block, this home offers excellent access to local amenities. Just down the street, you'll find Pugsley Creek Park and the Castle Hill YMCA, perfect for recreation and community activities. The location is also conveniently within walking distance to local shops, grocery stores, and bus transportation.
For broader shopping and entertainment, nearby attractions include Bruckner Plaza Mall and Hutchinson Parkway Mall. Additionally, Ferry Point Park is close by, offering access to the NYC Ferry for an easy commute or a scenic day outdoors.
This property presents a fantastic opportunity, whether you're looking for a comfortable family home with rental income potential or an investment in a vibrant Bronx neighborhood. HOUSE CAN'T BE DELIVERED VACANT +++ ONLY ONE VACANY THE 3 BEDROOM.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Mildred Valentin, Howard Hanna | Rand Realty
$949,999 (USD)
Active

Monroe Area Single Family Home

Active

18 Windmill Court Monroe, NY 10950

4 Bed
4 Baths
4209 sqft
MLS# 1003199
Location, location, location!
Welcome to Carriage Hill Estates, one of the area's most sought-after neighborhoods, where this exceptional Center Hall Colonial is perfectly situated on a quiet cul-de-sac surrounded by mature trees, professional landscaping, and an atmosphere of complete privacy and serenity. From the moment you arrive, you'll appreciate the sprawling front and backyard setting, oversized driveway, two-car garage, and inviting full front porch—the perfect place to enjoy morning coffee or unwind in the evening while taking in the peaceful surroundings.
Designed for both everyday living and memorable entertaining, the home offers a thoughtfully crafted floor plan filled with natural light and timeless details. The elegant living room features gleaming hardwood floors and custom crown molding, while the oversized dining room showcases chair rail and crown molding accents and flows seamlessly into the kitchen. The heart of the home is the stunning kitchen, complete with granite countertops, stainless steel appliances, custom cabinetry, pantry, peninsula breakfast bar, and a spacious dining area with sliders leading to the expansive deck. Open to the kitchen, the warm and welcoming family room boasts hardwood oak flooring, a beautiful stone gas fireplace, and a dramatic wall of windows that fills the space with natural light.
Upstairs, the luxurious primary suite serves as a private retreat with vaulted ceilings, a spa-like ensuite bath featuring a soaking tub and tiled shower, and an incredible bonus room located over the garage—ideal as a home office, nursery, dressing room, fitness space, or private sitting room. Three additional generously sized bedrooms provide comfort and flexibility, including one with a large California closet and vaulted ceiling, another with a deep closet, and a third featuring a walk-in closet. A full walk-up attic provides abundant storage and future possibilities.
The fully finished walk-out basement offers an impressive extension of living space, complete with a gas fireplace, custom bar area, recessed lighting, half bath, and endless opportunities for recreation, entertaining, or relaxing. Step outside to your own backyard oasis featuring an oversized tiered deck with custom lighting, a stone patio, a beautifully tiered lawn perfect for games and gatherings, and an above-ground swimming pool. Whether hosting summer celebrations or enjoying a quiet evening under the stars, this remarkable property offers the perfect blend of comfort, elegance, and outdoor enjoyment. This is more than a home—it's a lifestyle.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Gina Dudgeon, Howard Hanna | Rand Realty