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

Pelham Area Single Family Home

Active

4 Lawrence Place Pelham, NY 10803

5 Bed
4 Baths
1890 sqft
MLS# 966543
Nestled in the heart of exclusive Pelham Manor, this exceptional, light-filled custom renovated colonial seamlessly blends modern luxury with exceptional craftsmanship. Every inch of this 5 bedroom, 3.5 bath house has been meticulously reimagined with new windows, doors, siding, upgraded electric, updated plumbing, two laundry rooms, central alarm and a flat, landscaped backyard yard with a Trek deck that is perfect for large gatherings and cherished family moments. This house checks all the boxes.
The heart of the home is the expansive, open-concept chef's kitchen with quartz countertops and stainless steel appliances which leads into the dining room, living room and family room or home office. The second level is a sanctuary of comfort. The luxurious primary suite features a spacious bedroom, ample closet space, and an ensuite bathroom with a double vanity. Down the hall are three additional bedrooms, your first laundry room and an additional oversized bathroom featuring both a tub and shower. Rounding out this home is the impressive finished walk-out lower level featuring a full bathroom, bedroom, large laundry room, garage, and an oversized playroom or gym.
Walking distance to Pelham's award winning schools, including Siwonay Elementary, Pelham Middle and Pelham Memorial High School. This home is a commuter's dream with only a short walk to Pelham's Metro-North station and a 30 minute commute into NYC. As a Pelham Manor resident you also have exclusive access to Shore Park which is perfect for morning jogs, picnics overlooking the Long Island Sound, 4th of July fireworks, and playdates at the expansive playground. Welcome home.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Arlene Tejeda
$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,199,000 (USD)
Active

Mount Vernon Area Single Family Home

Active

54 Vernon Parkway Mount Vernon, NY 10552

3 Bed
4 Baths
2472 sqft
MLS# 965244
In the coveted Hunt Woods neighborhood, you will find this storybook English Tudor. Cherished by one family for five decades this home exudes timeless charm - from its stately slate roof celebrated for its enduring longevity to the beautifully refinished original oak hardwood flooring throughout. Expertly renovated and freshly painted, the main level features a formal living room with recessed lighting centered around a classic wood burning fireplace framed with candelabra sconces. An elegant formal dining room with modern statement lighting. Tudor inspired diamond paned Pella windows add visual interest and sophistication.
The updated kitchen features stainless steel appliances, contemporary hardware, and luxury vinyl plank flooring that extends to the breakfast area and Den designed for style and durability.
The second story consists of a primary bedroom with en suite bath, custom double closets and shelves. Two well-proportioned bedrooms with ample closet space and a hallway full bathroom with ceramic tub. The walk-up attic provides 2 additional rooms and a closet easily transformable into separate guest accommodations, a recreational area, private offices or just a place to retreat.
Outdoor living is equally delightful with an expansive Trex deck with retractable awning that tempers the sun and weather. A dedicated gas line feeds the outdoor grill ensuring uninterrupted meal preparation and a hot/cold water spigot elevates the space further adding year-round practicality from rinsing gear to a simple clean up. The Hunt Woods area is desirable for its sidewalk streets canopied by its massive oak and maple trees and its 26 acre natural wooded preserve providing walking trails and outdoor enjoyment. New York City commuters will appreciate the convenience of the Fleetwood and Bronxville Metro North stations both within 1.2 miles, offering a ride to Grand Central Terminal in under 30 minutes. Enjoy streamlined travel with convenient access to major arteries connecting upstate, Westchester and NYC. Experience an impressive selection of cuisines, shops and boutiques in the surrounding area.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Gianna Bonsignore
$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