Open House

Some or all of the listings below are provided by the Stony Point office.
$2,375,000
Active

N/A Area Single Family Home

Active

13 Cove Road Brookfield, CT 06804

5 Bed
5 Baths
6461 sqft
MLS# 24078512
Virtual Tour
Welcome to this stunning custom-built contemporary home, nestled on over 300 feet of pristine waterfront along Lake Lillinonah in the Barkwood Falls subdivision of Brookfield. This one-owner estate on over 2 acres is the epitome of luxury living, offering unparalleled privacy and breathtaking views of the lake. The grand two-story foyer is adorned with Carrera marble, setting the tone for the elegance that flows throughout the home. With 5 spacious bedrooms and 5 full bathrooms, this home is designed for both grand entertaining and comfortable everyday living. The 2010 addition features a huge vaulted great room with bay windows, wet bar, and a lower level walkout with full bathroom. The large, bright eat-in kitchen, remodeled in 2010, is a chef's dream with modern finishes and ample space for gathering. Entertain guests on the vast stone patio/terrace that wraps around the front of the home, offering unobstructed lake views and direct access via sliders from the dining room, kitchen, and home office. The vaulted primary suite offers a private sanctuary with one of the home's four fireplaces, a private deck, and a spa-like bathroom, creating the ultimate retreat. Outside, professionally landscaped grounds include a serene man-made pond, an inground gunite pool with built-in hot tub, a dock for boating and swimming, and direct access to the water for endless summer enjoyment.
Listing Courtesy of SMART MLS / Howard Hanna | Rand Realty / Jennifer Carbone
$1,195,000
Active

Blauvelt Area Single Family Home

Active

69 Leber Road Blauvelt, NY 10913

4 Bed
4 Baths
3204 sqft
MLS# 835336
Virtual Tour
This exceptional home has been updated over the years while maintaining it's originality and detail. The great room features a stone fireplace, and vaulted ceilings. There is a sunroom off the great room featuring French doors with stain glass and a slate floor. The sunroom leads directly out to the private backyard and onto the large deck. The custom country kitchen is large and has a slate floor. The kitchen also has a large island, stainless steel appliances, stone backsplash and a pot filler over the range. The master suite is complete with a private bath and is on the main level. There is a shower and soaking tub in the master bath.. A washer and dryer was recently installed in the mudroom so there is no reason to go up or down stairs. The main level also has a private office and half bath. The second level has 9 foot ceilings, three additional large bedrooms and a bath.. There is a large front porch and stone accents on the home as well as an attached oversized two car garage. The basement has been finished with approx 2000 sq for storage along with a full bath. There is a second laundry in the basement as well. Both laundries have a washer and dryer. The property is magnificent, level, private and serene. The location couldn't be better. This unique home is close to schools shopping, and highways. NYC is thirty five minutes away making this home not only beautiful, but practical as well. Chita Rivera known for her Tony award winning performances on Broadway loving maintained this house.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Theresa Budich
$1,175,000
Active

Harrison Area Multi-Family Home

Active

7 Madison Street Harrison, NY 10604

6 Bed
4 Baths
3140 sqft
MLS# 846021
Virtual Tour
Welcome to this beautifully renovated two-family home in highly sought-after West Harrison! Whether you're searching for the perfect place to call home or a fantastic investment opportunity, this meticulously updated property offers both comfort and versatility. The first floor unit greets you with gleaming hardwood floors that flow seamlessly throughout the spacious layout. The large living room and formal dining room create a welcoming space for family and guests. The stunning kitchen features crisp white cabinetry, quartz countertops, and stainless-steel appliances, providing access to a beautiful deck and a generously sized backyard—ideal for entertaining, outdoor activities, or simply enjoying your own private oasis. Down the hallway, you’ll find a luxurious tiled bathroom and three spacious bedrooms, including a master suite with a private en-suite bath. The second floor unit also showcases hardwood floors and a thoughtfully designed layout. It includes a spacious living room, formal dining room, and a custom kitchen with granite countertops and stainless-steel appliances. Three well-sized bedrooms and an updated full bath complete this charming space. The walk-out lower level adds incredible flexibility with a large multifunctional space ,summer kitchenette and tiled full bath—perfect for extended family, a home office, or a recreational area. Other features include individual gas, heat and electric for each unit, an oversized 2 car garage with 2 electric car charging ports, private on-sight laundry and plenty of storage. Ideally situated close to highways, schools, parks, eateries, and shops, this home combines modern living with everyday convenience. What an exceptional opportunity to own a move-in-ready, multi-family gem in one of West Harrison’s most desirable neighborhoods!
Listing by: ONEKEY / Howard Hanna | Rand Realty / David Calabrese
$1,100,000
Active

Jc Downtown Area Condominium

Active

234 10th St 511 Jc, Downtown, NJ 07302

2 Bed
2 Baths
1236 sqft
MLS# 250003514
Experience Elevated Living at Schroeder Lofts! Welcome to this exquisite 2 bedroom, 2-bath loft with 1,240 square feet of flexible living space, one of Hamilton Parks most sought-after addresses. Boasting 10 foot high ceilings with tons of natual light, this exceptional residence masterfully blends modern sophistication with industrial charm. Rich bamboo floors flow throughout the open-concept layout, creating an inviting yet elegant ambiance. Designed for both effortless living and stylish entertaining, the kitchen is a masterpiece of form and function featuring stainless steel appliances, sleek cabinetry, spacious breakfast bar, and ample quartz countertops makeing entertaining a delight. Each generously sized bedroom is a serene retreat with extra large framed windows. Thoughtfully designed closets provide abundant storage, ensuring a seamless blend of style and practicality. The primary suite features a walk-in closet and a private en-suite bathroom with radiant heated flooring. The generously sized second bathroom, adorned with natural stone tiles, is accessible from both the second bedroom and foyer. Additional conveniences include an in-unit front-loading washer/dryer and central air for year-round comfort. Schroeder Lofts elevates your lifestyle with a stunning rooftop deck, offering priceless panoramic city views and gas grills for al fresco dining. Secured access, a part-time doorman, and elevator service provide the ultimate in urban convenience. Located in the heart of Hamilton Park, youll enjoy lush green spaces, charming cafs & restaurants, boutique shopping, and a vibrant neighborhood atmosphere just steps from your door. With effortless access to the PATH, bus, ferry, and NJ Turnpike, commuting to Manhattan is a breeze! Rental parking is available within the building for added convenience. Discover the pinnacle of sophisticated city livingwhere elegance, comfort, and unparalleled location converge.
Listing Courtesy of HUDSON COUNTY / Howard Hanna | Rand Realty / Elizabeth Manna
$1,099,000
Active

Montclair Area Multi-Family Home

Active

38 Willowdale Ave Montclair, NJ 07042

5 Bed
3 Baths
sqft
MLS# 250007123
Opportunity knocks! Gut-renovated in 2020, this 2-family home on an oversized 49x140 lot offers the perfect combination of modern living, an unbeatable location, and income potential. Located a few blocks from Bay St and Glen Ridge train stations w/ direct service to NYC, this home is a commuter's dream. Steps away, the beautifully renovated Glenfield Park features state-of-the-art playgrounds, lush green spaces, sports facilities, and a new $10M community center. Enjoy a short walk to the nearby Bloomfield Ave arts district and new Ironbound Farmer's Market at Lackawanna Plaza! Perfect for owner-occupants, live in one unit while generating rental income from the other. The property includes off-street parking for 8+ cars, creating additional income opportunities. The oversized lot is ideal for constructing an Accessory Dwelling Unit (ADU) under newly enacted municipal code 347-8. Inside, modern updates blend with timeless charm: loft-like ceilings, abundant natural light, stainless steel appliances, quartz countertops, energy-efficient mini-split HVAC, and exposed brick for added character. Unit 1:1400 sq. ft. duplex w/ 3 bedrooms, 2 full baths, and a private fenced yard with low-maintenance artificial grass.Unit2: Bright 700 sq. ft. open-concept unit w/ 2 bedrooms and 1 full bath. Capitalize on Montclair's thriving rental market while enjoying top-rated schools, vibrant dining, and a welcoming community. This rare opportunity checks every box for living and investing!
Listing Courtesy of HUDSON COUNTY / Howard Hanna | Rand Realty / Ian Cramsey
$1,099,000
Active

Montclair Twp Area Multi-Family Home

Active

38 Willowdale Ave Montclair Twp., NJ 07042

5 Bed
3 Baths
sqft
MLS# 3946536
Opportunity knocks! Gut-renovated in 2020, this 2-family home on an oversized 49x140 lot offers the perfect combination of modern living, an unbeatable location, and income potential. Located a few blocks from Bay St and Glen Ridge train stations w/ direct service to NYC, this home is a commuter's dream. Steps away, the beautifully renovated Glenfield Park features state-of-the-art playgrounds, lush green spaces, sports facilities, and a new $10M community center. Enjoy a short walk to the nearby Bloomfield Ave arts district and new Ironbound Farmer's Market at Lackawanna Plaza! Perfect for owner-occupants, live in one unit while generating rental income from the other. The property includes off-street parking for 8+ cars, creating additional income opportunities. The oversized lot is ideal for constructing an Accessory Dwelling Unit (ADU) under newly enacted municipal code 347-8. Inside, modern updates blend with timeless charm: loft-like ceilings, abundant natural light, stainless steel appliances, quartz countertops, energy-efficient mini-split HVAC, and exposed brick for added character. Unit 1:1400 sq. ft. duplex w/ 3 bedrooms, 2 full baths, and a private fenced yard with low-maintenance artificial grass.Unit2: Bright 700 sq. ft. open-concept unit w/ 2 bedrooms and 1 full bath. Capitalize on Montclair's thriving rental market while enjoying top-rated schools, vibrant dining, and a welcoming community. This rare opportunity checks every box for living and investing!
Listing Courtesy of GARDEN STATE MLS - IDX / Howard Hanna | Rand Realty / Ian Cramsey