Rand Realty Open Houses

$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,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 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,299,900 (USD)
Active

Hoboken Area Condominium

Active

1301 Adams St 311 Hoboken, NJ 07030

2 Bed
2 Baths
1161 sqft
MLS# 260004210
Virtual Tour
Fully renovated in 2019/20, this exceptional 1,161 SF Upper Grand home is the largest two-bedroom, two-bathroom floor plan in the building. This premiere residence features 17 south- and west-facing windows overlooking Hobokens largest park and is filled with all-day sun and beautiful sunsets. The interior showcases premium custom millwork, including 7-foot solid wood doors, modern crown and baseboard moldings, and indestructible NuWood wide-plank flooring. The custom kitchen is a standout, boasting a massive 10-foot island with dual-sided storage, stainless steel appliances, Shaker-style cabinetry with a pantry, quartz countertops, and stylish pendant lighting. The primary suite offers a tranquil escape with a luxurious bathroom featuring timeless stone details. A fun and fashionable second bathroom features a deep soaking tub, custom vanity, and contemporary tilework. Additional upgrades include a recently replaced HVAC system with a Nest thermostat, a water heater, and an LG Laundry Tower. This home purchase includes a full-size garage parking spot (#80). 1300 Grand Street (also known as 1301 Adams Street) is a concrete-and-steel constructed building featuring two lobbies, two elevators, a fitness center, a beautiful courtyard, and a strong HOA. Residents enjoy easy access to the bus, ferry, highways, and Hobokens free HOP shuttle to the PATH. The vibrant neighborhood features playgrounds, Trader Joes, a seasonal farmers market, a dog park, and numerous shops and restaurants. The North End of the Mile Square is where everything is happening.
Listing Courtesy of HUDSON COUNTY / Howard Hanna | Rand Realty / Dana Minturn
$1,050,000 (USD)
Active

Hoboken Area Condominium

Active

1301 Adams St 610 Hoboken, NJ 07030

2 Bed
2 Baths
1038 sqft
MLS# 260004104
Virtual Tour
Experience top-floor living in the highly sought-after Upper Grand. This meticulous two-bedroom, two-bathroom residence features 9.5-foot ceilings, crown molding, a skylight, wide-plank flooring, six oversized windows, and a three-panel French glass door that leads directly to your private balcony. Unit 610 boasts a beautifully appointed kitchen equipped with shaker cabinetry, granite countertops, a tile backsplash, stainless steel appliances, and a large peninsula. The king-size primary suite includes a spacious walk-in closet and an ensuite bath with a double vanity. Additional premium upgrades include curated lighting, USB outlets, a recently replaced HVAC system, water heater, windows, an LG Laundry Tower, and a brand-new, never-used LG ThinQ gas range and dishwasher. An SUV-sized garage parking space (#81) is also included. 1300 Grand Street (also known as 1301 Adams Street) is a concrete-and-steel building with two lobbies, two elevators, a fitness center, a lush courtyard, and a strong HOA. This turnkey home is located in the vibrant North End and is across the street from Hobokens largest park. Residents enjoy easy access to a dog park, playgrounds, shops, restaurants, cafes, a seasonal farmer's market, and Trader Joe's. The location offers a convenient commute via bus, ferry, highways, and the free HOP shuttle to the PATH. (virtually staged for illustration purposes)
Listing Courtesy of HUDSON COUNTY / Howard Hanna | Rand Realty / Dana Minturn