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,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, within the Clarkstown North School District. This beautiful home offers timeless design, quality craftsmanship, and a spacious layout perfect for modern living.

The first floor features a formal living room and dining room, ideal for entertaining or gatherings. A versatile home office or multipurpose room provides flexibility for today’s lifestyle. The kitchen is both stylish and functional, offering generous quartz countertops, stainless steel appliances including a refrigerator, range, vent hood, and microwave, along with a walk-in pantry and a cozy kitchenette area with sliding doors leading to the Trex deck. The large family room is bright and inviting, centered around a gas fireplace. Completing the main level is an expansive bonus great room filled with natural light and beautiful hardwood floors throughout.

Upstairs, you’ll find four spacious bedrooms. The primary suite features tray ceilings, a walk-in closet with custom shelving and a washer/dryer hookup, and a luxurious bathroom with a soaking tub, glass-enclosed shower, double vanity, and custom mirror. Three additional bedrooms all feature hardwood floors and ample closet space.

Additional highlights include a two-car garage and a full unfinished walkout basement with sliding doors—offering endless possibilities for future expansion or recreation space. Situated on .75 acres, this property provides both space and convenience, close to shopping, restaurants, parks, and public transportation.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Samantha Ortiz
$1,299,900 (USD)
Active

South Orange Village Twp Area Single Family Home

Active

570 Cameron Rd South Orange Village Twp., NJ 07079

5 Bed
5 Baths
3588 sqft
MLS# 4005402
Stunning, Fully Renovated Corner Colonial in Tuxedo Park, South Orange. Welcome to 570 Cameron Road, a beautifully re-imagined single-family home set in one of Essex County's most sought-after communities. This charming custom corner colonial perfectly blends timeless architecture with modern elegance and refined comfort. Step inside to discover sun-drench, spacious living areas that flow seamlessly, ideal for entertaining, working from home, or relaxing in style. Gorgeous hardwood floors and a lovely, functional fireplace in the living room. The chef's kitchen is a showstopper, featuring custom cabinetry, Quartz counter tops, and premium finishes. The Master bedroom offers thoughtful design details, including a modern ceiling light with fan and a dedicated makeup counter. Exudes luxury, highlighted by the suite's stunning spa-like bath complete with a freestanding soaking tub and an advanced LED Panel Tower Shower System with multiple body jets, rainfall features, and a sleek tub spout. The finished basement adds exceptional functionality with a full shower bath, new washer and dryer, two large walk-in closets, and abundant storage. This move-in-ready masterpiece offers the ideal balance of suburban tranquility and urban accessibility, set on a quiet street just minutes from the Midtown Direct train station, Seton Hall University, So Orange Performing Arts Center, downtown dining and shops, parks, and major highways. A Must See!!!! This won't last long!
Listing Courtesy of GARDEN STATE MLS - IDX / Howard Hanna | Rand Realty / Essie Williams
$880,000 (USD)
Active

White Plains Area Single Family Home

Active

122 Greenacres Avenue White Plains, NY 10606

4 Bed
3 Baths
2112 sqft
MLS# 958469
As if invited in by the sun itself, this charming 1923 Colonial is drenched in natural light throughout. Rich period details—classic moldings, built-ins, and gleaming hardwood floors—set the tone as you enter the spacious living room boasting a wood burning fireplace, ideal for family gatherings and entertaining guests. Just beyond, the sunroom/family room offers a tranquil retreat, bathed in sunlight and perfect for reading, relaxing, or unwinding. The formal dining room provides a welcoming setting for memorable meals and meaningful conversations with friends. The modern eat-in kitchen is thoughtfully designed with custom cabinetry, granite countertops, stainless steel appliances, and a separate butler’s prep area/coffee station, along with a conveniently located powder room. Upstairs, you’ll find three spacious bedrooms, a renovated hall bath, and a serene primary suite featuring a renovated en-suite bathroom and a versatile exercise/dressing room or optional walk-in closet. A rare and delightful bonus for a 1920s home: a dedicated second-floor laundry room. The lower level offers abundant storage, a flexible multifunctional space ideal for a home office or playroom, and direct access to the one-car garage. Step outside to discover lush plantings and a beautifully landscaped, fenced backyard that perfectly balances privacy and open space—ideal for pets, or enjoying a quiet evening with a bottle of wine. Conveniently located near downtown White Plains, this vibrant city offers a wealth of entertainment, dining, shopping, and transportation options. Just one mile to either the White Plains or Hartsdale Metro-North stations (approximately 35 min to GCT), this home delivers an easy commute and the best of city amenities within a suburban setting. More than just a place to live, this home offers a lifestyle waiting to be embraced. Experience the perfect blend of comfort, convenience, and timeless charm. Welcome home.
Listing by: ONEKEY / Howard Hanna | Rand Realty / David Calabrese
$873,000 (USD)
Active

Nyack Area Single Family Home

Active

52 Glen Byron Avenue Nyack, NY 10960

3 Bed
2 Baths
1268 sqft
MLS# 955266
This is the kind of South Nyack property people wait years for -and almost never get. Set on a rare, flat .29 acre lot, at the end of a quiet dead end street, this 1910 Colonial delivers the kind of space , light and vibe we all wish for. Ten minutes on foot gets you to Nyack's cafes, shops, the Hudson River and -live your life energy -then you come home to total calm. Inside it is airy, open and effortlessly cool. Original hardwood floors, custom radiator covers and a wood burning stove anchor the soul of the home , while a Chef level kitchen with commercial range, stone counters and stainless appliances keep things modern and social. Morning light floods this east facing home with effortless access to two patios and a front porch made for coffee, cocktails and conversation. The finished basement is next level flexible . A Murphy bed for guests, new bath, space to work out or play plus a hidden built-in nook that feels straight out of a design magazine ( or a kids dream) . New ductless a/c and new central a/c , new first floor windows and sliders, recently painted exterior, new water softener and new hot water heater .The detached garage offers up many possibilities depending on what you want. Move right in or dream bigger. This home comes with fully designed expansion plans crafted by a top local architect ready to submit when you are. Quiet street, flat land , walk to everything lifestyle. This is South Nyack at its best. Showings start 2/5.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Nancy Blaker Weber
$848,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
$799,900 (USD)
Active

White Plains Area Single Family Home

Active

93 Smith Avenue White Plains, NY 10605

3 Bed
1 Baths
1652 sqft
MLS# 954333
Virtual Tour
Picture-perfect Cape Cod situated on a desirable corner lot in the heart of the Highlands neighborhood of White Plains. Completely renovated, this brick home features all-new windows and new vinyl siding, offering timeless curb appeal paired with modern efficiency. A spacious entry foyer welcomes you into sun-filled interiors highlighted by gleaming hardwood floors throughout. The inviting living room is enhanced by a large picture window, while the elegant dining area opens to a wood deck and stone patio, ideal for indoor-outdoor entertaining. The private backyard is fully fenced with stockade fencing and enhanced by newly added landscaping shrubs, creating an enchanting and tranquil setting. The charming kitchen showcases white cabinetry, granite countertops, stainless steel appliances, and classic country appeal. Three generously sized bedrooms are complemented by a versatile den/home office, allowing the home to live like a four-bedroom. An impeccably updated hall bath completes the main level. The lower-level basement offers a versatile, multi-functional recreation space, laundry area, and convenient access to the garage. Fixed plumbing is already in place, presenting an excellent opportunity to add a bathroom and further enhance the space. Ideally located close to Metro-North, shopping, fine dining, parks, schools, and major highways, this exceptional home delivers privacy, flexibility, and convenience in one of White Plains’ most desirable neighborhoods.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Gino Bello