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

Nyack Area Single Family Home

Active

17 1st Avenue Nyack, NY 10960

4 Bed
4 Baths
2600 sqft
MLS# 951130
This 1900's Vintage Victorian with river views sits just steps from the river and the Nyack Boat Club on one of Nyack's prettiest blocks lined with beautifully preserved Victorians and offering a true walk-to-village lifestyle. With over 3400 sf of light filled living space this home has been restored and re-imagined from top to bottom, honoring original details while layering in bold, high function upgrades.The latest renovation transformed the original barn into a dramatic light filled studio with soaking tub and french bathroom above and a garage below-perfect for creative work, guests or a home office. Other features include a wide river view wraparound porch, open concept restaurant style kitchen in stainless steel anchored by a pizza oven imported from Italy. French doors leading to a well designed outdoor kitchen with grill and sink and raised well garden beds . The private primary bedroom is ensuite and has a sweet south facing balcony. The walkout lower level has a home gym area, laundry, media room , office and a half bath. Modern comforts are fully dialed in with a 50 year roof, energy efficient furnace and water heater, central air and radiant heat in baths. Historic, hip and 100% Nyack with a rare blend of architectural gravitas and creative edge . Upper Nyack Elementary.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Nancy Blaker Weber
$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
$650,000 (USD)
Active

Rockaway Twp Area Single Family Home

Active

47 Cherokee Ave Rockaway Twp., NJ 07866

4 Bed
2 Baths
1800 sqft
MLS# 4006317
Renovated, Modern, and Move-In Ready. Beautifully updated 4BR, 2BA raised ranch offering approximately 1,800 sq ft in White Meadow Lake. The ground level opens with an oversized entry foyer and generous closets, leading to a large rec room, a renovated full bath with hinged glass that converts the shower into a steam-shower, and a private first bedroom ideal for guests or a home office. Upstairs, the remodeled kitchen flows seamlessly into the dining and living areas, creating an open, bright layout perfect for everyday living. Three additional bedrooms and a second updated full bath complete the upper level. Major improvements include gas conversion, plumbing updates, flooring, newer windows, newer roof, newer central AC, irrigation system, security system, and a freshly paved and expansive driveway accommodating up to five or more cars. Sliding doors lead to an open, continuous covered paver patio that begins at the rear sliders and steps up to an elevated section, all protected under a full roof. This year-round outdoor living space overlooks a usable backyard extending to a finished shed/gym with mini-split HVAC, mirrored, and flexible use as a studio, office, or fitness room. Public sewer and access to White Meadow Lake's beaches, boating, clubhouse, and year-round activities make this a rare turnkey opportunity in a highly desirable community. Too much to list! Ask for highlights list.
Listing Courtesy of GARDEN STATE MLS - IDX / Howard Hanna | Rand Realty / Joseph Goetchius
$580,000 (USD)
Active

Soundview Area Condominium

Active

197 Surf Drive 123 Bronx, NY 10473

3 Bed
2 Baths
1206 sqft
MLS# 931557
Introducing 197 Surf Drive, a three-bedroom condominium corner unit in the gated Harbour Pointe at Shorehaven community. This property offers A 25 YEAR TAX ABATEMENT FROM YEAR BUILT, LOW TAXES UNTIL 2031. comfort, privacy, and numerous amenities. This walk-in unit has direct access to a private backyard. This first-floor features new flooring, fresh paint, a master bedroom, a Jack and Jill bathroom, a laundry room, a modern kitchen with open concept, and a living room. The upper floor includes two additional bedrooms with new flooring throughout and an additional bath or full guest bathroom. Harbour Pointe at Shorehaven provides 24-hour security. Residents can enjoy a clubhouse with a media room, playroom, gym, and yoga studios. Outdoor amenities include swimming pools, a playground, grilling areas, and courts for basketball and tennis. The location is convenient for commuting and leisure. It is home to the first ferry stop at the Soundview/Clason Point hub station, offering quick access to Manhattan or Ferry Point Park. The Bx27 and Bx39 bus routes are just outside the complex. The Bruckner Shopping Center and Hutchinson Parkway Shopping are minutes away, and the Whitestone Bridge and Throggs Neck Bridge provide easy access to Long Island and Queens. *** STILL HOLDING A YEAR TAX ABATMENT FROM YEAR BUILT!
Listing by: ONEKEY / Howard Hanna | Rand Realty / Mildred Valentin