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
$899,000 (USD)
Active

Monroe Area Single Family Home

Active

32 Mansion Ridge Boulevard Monroe, NY 10950

4 Bed
4 Baths
3462 sqft
MLS# 951179
Welcome to this stunning Horizon model in the prestigious Mansion Ridge community of Monroe, NY, set on a Jack Nicklaus Signature Golf Course, offering elegant design, privacy, and gorgeous panoramic mountain views from all three levels of the home. Ideally positioned away from traffic and golf course activity, this 4-bedroom Colonial enjoys a quieter, more private setting while showcasing exceptional craftsmanship throughout.
The grand two-story foyer, accented by a beautiful chandelier, creates an impressive entry and sets the tone for the home’s refined interiors. The main level is thoughtfully designed for both everyday living and entertaining, featuring a spacious kitchen with abundant cabinetry and pantry, opening to a breakfast nook with direct access to the expanded deck—perfect for casual dining and seamless indoor-outdoor living while taking in the sweeping mountain vistas. The two-story family room offers soaring ceilings and a fireplace, creating a warm yet impressive gathering space. A den on the main level, ideal for a home office, study, or flexible work-from-home space, is complemented by a convenient half bath. The laundry room is conveniently located just off the kitchen on the main level for added practicality.
The double staircase leads to the second level, where all four bedrooms are located, including the expansive primary suite with gleaming hardwood floors, vaulted ceiling, and sitting area framed by breathtaking mountain views. The suite features two walk-in closets plus an additional closet and linen closet. The spa-like ensuite bath includes a jetted tub, large shower, and dual sinks. A private guest suite with a full bath provides ideal accommodations for visitors, while two additional generously sized bedrooms share a third full bath, creating a well-balanced and functional layout.
Outdoor living is elevated by the home’s scenic setting, with panoramic mountain views enjoyed from every level, including the walk-out lower level. The professionally fertilized lawn and full sprinkler system make maintenance effortless. Additional highlights include a 3-car garage and convenient driveway access to the oversized deck. The full, unfinished walk-out basement with rough plumbing offers endless potential to create additional living, recreation, or entertaining space tailored to your needs—all while enjoying the same stunning views.
Conveniently located just minutes from the town of Monroe, shopping, dining, and everyday amenities, this home also offers excellent commuter access to Route 17 and the Palisades Parkway, making it easy to balance work, travel, and leisure.
This exceptional home combines a well-designed layout, privacy, and resort-style living with unmatched panoramic mountain views in one of Orange County’s most desirable golf course communities.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Lauren Kelly
$828,000 (USD)
Active

North Bergen Area Single Family Home

Active

6500 Durham Ave North Bergen, NJ 07047

4 Bed
4 Baths
sqft
MLS# 250017516
Virtual Tour
Stunning Warehouse Conversion Expansive Mother-Daughter Home with Designer Finishes Welcome to this beautifully converted warehouse, now a breathtaking mother-daughter residence offering approximately 3,400 sq/ft of thoughtfully designed living space. Soaring 10-foot ceilings and 8-foot doors on the main level create a grand and airy ambiance, while oversized windows and three skylights flood the space with natural light. The heart of the home is the custom chefs kitchen, featuring a large island with seating for six, sleek Dacor appliances including a 36" gas range, counter-depth refrigerator, and integrated dishwasherall seamlessly clad in matching cabinetry. The open-concept layout connects the kitchen to an expansive living and dining area, ideal for entertaining. A stylish half bath is conveniently located for guests. Throughout the home, you'll find 5" wide-plank hardwood and imported Italian tile flooring. The luxurious primary suite includes a walk-in closet and private en-suite bath, while two additional bedrooms share a spacious Jack and Jill bathroom. Step outside to a fully finished backyard oasis complete with pavers, privacy fencing, and both gas and electric hook-upsperfect for outdoor gatherings. The lower level offers a separate living space, ideal for extended family or guests, with its own bedroom, full bath, kitchenette, laundry room, and a massive entertainment area surrounded by custom cabinetry and storage. Every inch of this home has been meticulously updatednew HVAC, roof, windows, plumbing, electrical, and more. The builder has truly thought of everything. This one-of-a-kind property is a must-see!
Listing Courtesy of HUDSON COUNTY / Howard Hanna | Rand Realty / Constantine Marakas
$828,000 (USD)
Active

North Bergen Area Single Family Home

Active

6500 Durham Avenue North Bergen, NJ 07047

4 Bed
4 Baths
sqft
MLS# 25031833
Welcome to this beautifully converted warehouse, now a breathtaking mother-daughter residence offering approximately 3,400 sq/ft of thoughtfully designed living space. Soaring 10-foot ceilings and 8-foot doors on the main level create a grand and airy ambiance. The heart of the home is the custom chef’s kitchen, featuring a large island with seating for six, sleek Dacor appliances including a 36 gas range, counter-depth refrigerator, and integrated dishwasher—all seamlessly clad in matching cabinetry. The open-concept layout connects the kitchen to an expansive living and dining area, ideal for entertaining. Throughout the home, you'll find 5 wide-plank hardwood and imported Italian tile flooring. The luxurious primary suite includes a walk-in closet and private en-suite bath, while two additional bedrooms share a spacious Jack and Jill bathroom. Step outside to a fully finished backyard oasis complete with pavers, privacy fencing, and both gas and electric hook-ups—perfect for outdoor gatherings. The lower level offers a separate living space, ideal for extended family or guests, with its own bedroom, full bath, kitchenette, laundry room, and a massive entertainment area surrounded by custom cabinetry and storage. Every inch of this home has been meticulously updated—new HVAC, roof, windows, plumbing, electrical, and more. This one-of-a-kind property is a must-see! Wow!!
Listing Courtesy of NJMLS / Howard Hanna | Rand Realty / Constantine Marakas
$639,000 (USD)
Active

Norwood Area Single Family Home

Active

410 Tappan Road Norwood, NJ 07648

2 Bed
1 Baths
sqft
MLS# 26006076
Welcome to effortless, one-level living in this pristine 2-bedroom ranch with bonus office space perfectly designed for comfort, convenience, and today’s lifestyle. This meticulously maintained home offers a bright and inviting layout all on one floor. The spacious living areas flow seamlessly, creating an ideal setting for both relaxing and entertaining. A dedicated office provides the perfect work-from-home solution or flexible space for hobbies or guests. The serene primary bedroom is a true retreat, featuring sliding glass doors that open directly to a stunning, oversized deck—ideal for morning coffee, outdoor dining, or simply unwinding while overlooking the peaceful surroundings. Pristine hardwood flooring throughout. Downstairs, the expansive basement offers exceptional versatility with abundant storage space and a separate exercise room, giving you all the room you need to stay organized and active. Driveway can fit approximately 6 cars. Move-in ready and meticulously cared for, this home delivers easy living at its best. Ideally situated near vibrant towns offering fantastic shopping, beautiful parkland, and convenient public transportation. Enjoy the charm of nearby river communities just minutes from the New York border, with approximately 14 miles to New York City, making commuting or weekend adventures a breeze.
Listing Courtesy of NJMLS / Howard Hanna | Rand Realty / Rita Van Buren