Open House

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

Manhasset Area Single Family Home

Active

9 Sequoia Circle Manhasset, NY 11030

5 Bed
5 Baths
3630 sqft
MLS# 955004
Welcome to Manhasset Crest, Long Island’s premier gated new-home community. This exceptional 2025 new construction residence is move-in ready and thoughtfully designed for today’s lifestyle.

A dramatic foyer welcomes you with stunning sightlines through the main living space to the rear yard, creating an immediate sense of openness and light. The open-concept kitchen and great room provide the perfect setting for entertaining, seamlessly connected to the outdoor patio and private backyard for effortless indoor-outdoor living.

The first floor features a functional mudroom and a private home office, ideal for modern living. The home offers five bedrooms and four and a half baths, delivering both comfort and flexibility.

The second level showcases a luxurious primary suite with his-and-hers custom walk-in closets and a spa-inspired bath complete with an oversized soaking tub. Sizable secondary bedrooms include a shared ensuite bath, along with a 2rd bedroom with ensuite private bath.

The finished daylight basement is an entertainer’s dream, featuring a wet bar, a guest bedroom with full bath, designer-appointed finishes, and a walkout to the exterior for a private entrance.

Additional highlights include a two-car garage, professionally landscaped grounds, a spacious backyard, and a large outdoor living patio designed for seamless flow between interior and exterior spaces.

Manhasset Crest gated community is Ideally located near premier shopping, fine dining, highly acclaimed Manhasset school district, and all the lifestyle amenities the North Shore is known for—this is luxury living at its finest in Manhasset Crest.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Alissa Kirk
$1,650,000 (USD)
Active

North Caldwell Boro Area Single Family Home

Active

6 Colony Drive North Caldwell Boro, NJ 07006

5 Bed
3 Baths
sqft
MLS# 4010871
Beautifully Renovated Custom Colonial with a Welcoming Wrap-Around Porch, located on a quiet, dead-end street. Modern Luxury and Classic Charm. Hardwood Floors Throughout. Living Room features a wood-burning fireplace w/Detailed Mantle and an Impressive Formal Dining Room with Coffered Ceilings. The Updated Chef's Kitchen offers high-end SS Appliances, Quartz Counters, Center Island w/Seating and new Cabinetry. Family room with Vaulted Ceilings and Sliding Doors leading to a Deck overlooking a Level Backyard. Convenient first-floor bedroom or home office and a full bath, plus a Mudroom with Storage and attached Two-Car Garage. A second floor Luxurious Primary Retreat with Two Walk-in Closets and a Spa Bath w/ Soaking Tub, Double Vanity, Water Closet and Oversized Shower. Three additional Large Guest Bedrooms, Hall Bath, Linen Closet and Access to Walk-up Attic with Plenty of Storage. The Finished Lower Level expands your living space with two Recreation Rooms, Oversized Laundry Room, Custom Shelving and an Entertainers Dream Bar w/Quartz Counters, two Wine Refrigerators, Custom Cabinetry and direct access to Backyard. This Turnkey Home blends Thoughtful Updates, Spacious Living and Premium Finishes in one of North Caldwell's finest locations. Note: Wood Burning Fireplace AS-IS.
Listing Courtesy of GARDEN STATE MLS - IDX / Howard Hanna | Rand Realty / Karen Treacy
$1,650,000 (USD)
Active

North Caldwell Area Single Family Home

Active

6 Colony North Caldwell, NJ 07006

5 Bed
3 Baths
sqft
MLS# 26005813
Beautifully Renovated Custom Colonial with a Welcoming Wrap-Around Porch, located on a quiet, dead-end street. Modern Luxury and Classic Charm. Hardwood Floors Throughout. Living Room features a wood-burning fireplace w/Detailed Mantle and an Impressive Formal Dining with Coffered Ceilings. The Updated Chef's Kitchen offers high-end SS Appliances, Quartz Counters, Center Island w/Seating and new Cabinetry. Family room with Vaulted Ceilings and Sliding Doors leading to a Deck overlooking a Level Backyard. Convenient first-floor bedroom or home office and a full bath, plus a Mudroom with Storage and attached Two-Car Garage. A second floor Luxurious Primary Retreat with Two Walk-in Closets and a Spa Bath w/ Soaking Tub, Double Vanity, Water Closet and Oversized Shower. Three additional Large Guest Bedrooms, Hall Bath, Linen Closet and Access to Walk-up Attic with Plenty of Storage. The Finished Lower Level expands your living space with two Recreation Rooms, Oversized Laundry Room, Custom Shelving and an Entertainers Dream Bar w/Quartz Counters, two Wine Refrigerators, Custom Cabinetry and direct access to Backyard. This Turnkey Home blends Thoughtful Updates, Spacious Living and Premium Finishes in one of North Caldwell's finest locations. Note: Wood Burning Fireplace AS-IS.
Listing Courtesy of NJMLS / Howard Hanna | Rand Realty / Karen Treacy
$1,475,000 (USD)
Active

New City Area Single Family Home

Active

255 Congers Road New City, NY 10956

4 Bed
3 Baths
3186 sqft
MLS# 930906
Virtual Tour
New construction Colonial in the heart of New City offering timeless design, quality craftsmanship, and a spacious layout ideal for today’s lifestyle. Located in the Clarkstown North School District and set on .75 acres, this beautifully designed home combines classic architecture with modern finishes and open, light-filled living spaces. The first floor features a formal living room and dining room, perfect for entertaining and everyday gatherings. A versatile home office or multipurpose room provides flexibility for remote work, study, or additional living space. The kitchen is both stylish and functional with generous quartz countertops, stainless steel appliances including refrigerator, range, vent hood, and microwave, plus a walk-in pantry. A cozy kitchenette area with sliding doors leads to a Trex deck, creating seamless indoor-outdoor flow for dining or relaxation. The spacious family room is bright and inviting, centered around a gas fireplace. An expansive bonus great room filled with natural light adds even more living space, ideal for recreation, media, or extended gatherings. Beautiful hardwood floors run throughout the main level. Upstairs, you will find four generously sized bedrooms. The primary suite offers tray ceilings, a walk-in closet with custom shelving and washer/dryer hookup, and a luxurious bath featuring a soaking tub, glass-enclosed shower, double vanity, and custom mirror. Three additional bedrooms provide hardwood floors and ample closet space. Additional highlights include a two-car garage and a full unfinished walkout basement with sliding doors, offering excellent potential for future expansion, recreation, gym space, or storage. Conveniently located near shopping, restaurants, parks, and public transportation, this brand new home delivers space, function, and modern comfort in a highly desirable New City location.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Samantha Ortiz
$1,045,000 (USD)
Active

New City Area Single Family Home

Active

Address Not Disclosed New City, NY 10956

6 Bed
4 Baths
2688 sqft
MLS# 966678
Virtual Tour
Welcome to 15 Central Highway in New City - a residence where timeless Colonial architecture meets modern comfort, all wrapped in the tranquility of one of Rockland County's most desirable settings. Perfectly positioned on 1.3 acres, this move-in ready center-hall colonial offers the rare combination of privacy, space and convenience within the acclaimed Clarkstown School District.
Step inside and you're greeted by a gracious foyer that sets the tone for the entire home: warm, inviting, and thoughtfully designed. With six generously sized bedrooms, there is room for everyone, whether you're hosting guests, creating multi-generational living setup, or simply craving extra space to spread out. The dedicated home office provides the ideal environment for remote work, study, or creative pursuits.
The home features 3.5 tastefully updated bathrooms, each blending style with functionality. Energy-conscious buyers will appreciate the leased solar panels and energy-efficient appliances, offering both sustainability and long-term savings. The finished basement expands your living space even further - perfect for a media room, gym, playroom, or hobby areas.
Designed for both relaxed living and memorable entertaining, the layout flows effortlessly from room to room. Whether you're hosting holiday gatherings, summer barbecues, or quiet evenings at home, this property adapts beautifully to every occasion. The expansive ground offer endless possibilities - from gathering and outdoor dining to future enhancements like a patio oasis.
Lovingly maintained by its current owners, the home reflects pride of ownership at every turn. Now, it's ready for someone new to appreciate its comfort and charm.
Why wait - your next chapter begins here. Schedule your private showing today.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Maria Lavarino