My Company's Active Listings

$875,000 (USD)
Pending

New Rochelle Area Condominium

Pending

175 Huguenot Street 2403 New Rochelle, NY 10801

2 Bed
3 Baths
1494 sqft
MLS# 930561
Unquestionably the finest home and the largest of the two Bed Room layouts available in Trump Plaza. This stunning corner unit is perfectly situated for panoramic views of the Long Island Sound and the Manhattan skyline. With 9 ft. floor to ceiling windows you will feel as though you are living in a glass house in the sky! Renowned Trump luxury and amenities, terrific urban conveniences and elegant city life complete the package for this fine home. Beautifully updated throughout, this move-in–ready home features new engineered wood flooring, fresh paint, modern lighting, solar shades, smart thermostats, and upgraded HVAC units. The living and dining areas feel bright and open, complemented by LED recessed lighting and updated fixtures.
The kitchen was fully remodeled with porcelain floors, high-end cherry wood cabinetry, quartzite countertops and backsplash, under-cabinet lighting, a redesigned soffit, and premium stainless-steel appliances, including a 30-inch range, four-door refrigerator, dishwasher, and stainless/glass hood. Both bathrooms have been completely renovated with floor-to-ceiling porcelain tile, premium glass enclosures, new vanities, upgraded fixtures, recessed medicine cabinets, LED lighting, new exhaust fans, and modern switches. The secondary bathroom includes heated floors, while the primary features a cast-iron tub with quartz surround and double sinks. Additional upgrades include new smoke detectors, pocket doors, new HVAC in multiple rooms, and thoughtful finishes throughout. Parking is optional and not included with the purchase of the unit. Monthly cost is $208 per car. THIS UNIT HAS AN ACCEPTED OFFER.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: John Oliveri, Howard Hanna | Rand Realty
$875,000 (USD)
Active

Bardonia Area Single Family Home

Active

143 Pineview Avenue Bardonia, NY 10954

5 Bed
3 Baths
2544 sqft
MLS# 1027093
Welcome to this beautifully maintained mother/daughter home with separate entrance that offers space, versatility, and endless possibilities. The lower level features 2 bedrooms, a spacious open-concept living room, an eat-in kitchen, in unit washer and dryer, and sliding glass doors leading to a private patio and backyard perfect for extended family or guests.

The main level offers 3 generously sized bedrooms, a bonus room convenient for den or office space, and 2 full bathrooms. The livingroom is a warm and inviting featuring cathedral ceilings with exposed wood beams along with a stunning 45,000 BTU natural gas stone fireplace which serves as the focal point of the room. Oversized windows flood the home with an abundance of natural light, pristine hardwood floors flow throughout, adding timeless charm and elegance.

Off the kitchen you will find a covered porch, which leads to a large, flat, level backyard a blank canvas ready to create your dream outdoor retreat. The yard also features two storage sheds and a private custom-built deck surrounding a hot tub, a peaceful space to relax and unwind.

This home is conveniently located close to shopping, parks, schools, and 5 minutes to the Palisades Pkwy. offering easy access for commuters while providing the perfect blend of comfort, flexibility, and everyday convenience. Don’t miss this incredible opportunity!
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Christine Bongiovanni, Howard Hanna | Rand Realty
$875,000 (USD)
Pending

Wayne Area Single Family Home

Pending

54 Church Lane Wayne, NJ 07470

4 Bed
3 Baths
sqft
MLS# 26024485
Welcome home to this expansive 4-bedroom, 2.5-bath Center Hall Colonial, gracefully set on a beautifully manicured lot in the heart of Wayne. A dramatic two-story foyer welcomes you into a thoughtfully designed floor plan filled with natural light and generous living spaces. The elegant formal dining room is ideal for intimate dining and entertaining, while the sun-drenched living room flows seamlessly into the stunning two-story great room featuring soaring vaulted ceilings, oversized windows, a gas fireplace, and sliding doors to the spacious rear deck. The oversized eat-in kitchen offers custom cabinetry, granite countertops, white appliances, and a bright dining area overlooking the backyard. A powder room and convenient first-floor laundry complete the main level. Retreat upstairs to discover, the spacious primary suite features a large walk in closet and private en suite bath. Three additional generously sized bedrooms and a full bath provide exceptional comfort and flexibility. The full unfinished basement offers abundant storage and endless potential for future living space. Step outside to an expansive deck designed for effortless entertaining, outdoor dining, and relaxing while overlooking the private, wooded backyard. Completing this exceptional home are a two-car attached garage, ample driveway parking, and an unbeatable location close to NYC transportation, premier shopping, dining, and top-rated schools.
Listing Courtesy of NJMLS / Listed By: Eugene Lowe, Howard Hanna | Rand Realty
$875,000 (USD)
Active

New Windsor Area Single Family Home

Active

28 Bethlehem Road New Windsor, NY 12553

3 Bed
3 Baths
2903 sqft
MLS# 1004367
Set way back on 2.5 beautifully landscaped acres, within the sought-after Cornwall Central School District, this custom Center Hall Colonial offers the rare combination of timeless architecture, quality craftsmanship, and modern comfort. Built in 2011 and spanning just under 3,000 square feet, the home is thoughtfully designed with generous living spaces, refined finishes, and an ideal layout for both everyday living and entertaining.
A long 550-foot blacktop driveway winds through the property, creating a true sense of arrival. Outside, the wraparound deck overlooks the expansive grounds complete with mature landscaping and a dedicated bonfire area, offering a peaceful setting with exceptional privacy.
Inside, the main level features a flexible and functional layout anchored by an open-concept living room and custom kitchen. Rich maple hardwood floors run throughout, complemented by 9-foot ceilings, oversized 8-foot doors, and oversized Pella double-hung windows that flood the home with natural light. The kitchen was designed with both style and practicality in mind, featuring stainless steel appliances, premium cabinetry, detailed millwork, a pantry, breakfast booth nook, and dry bar area. A formal dining room, full bathroom, and flexible guest bedroom or office complete the first floor, while the authentic wood-burning fireplace adds warmth and character to the heart of the home.
Upstairs, the spacious primary suite serves as a private retreat with a large walk-in closet and spa-like bath featuring a jacuzzi tub, stand-up shower, private water closet, and dual sink vanity. Two additional bedrooms offer large closets and maple flooring, while an additional nursery or private office provides even more flexibility. A second-floor laundry room adds everyday convenience, and pull-down attic access offers additional storage space.
The walk-out basement features a poured concrete foundation, 8-foot ceilings, abundant storage space, and plumbing already in place for a future bathroom, presenting endless possibilities for expansion or finishing.
Additional features include two-zone central air, two-zone hydro forced-air heat, a UV light water purification system, municipal sewer service, and a drilled private well.
A private and exceptionally well-built Cornwall property offering the space, setting, and quality that rarely come to market.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Vincent Nastro, Howard Hanna | Rand Realty
$875,000 (USD)
Pending

Wayne Twp Area Single Family Home

Pending

54 Church Ln Wayne Twp., NJ 07470

4 Bed
3 Baths
sqft
MLS# 4037728
Welcome home to this expansive 4-bedroom, 2.5-bath Center Hall Colonial, gracefully set on a beautifully manicured lot in the heart of Wayne. A dramatic two-story foyer welcomes you into a thoughtfully designed floor plan filled with natural light and generous living spaces. The elegant formal dining room is ideal for intimate dining and entertaining, while the sun-drenched living room flows seamlessly into the stunning two-story great room featuring soaring vaulted ceilings, oversized windows, a gas fireplace, and sliding doors to the spacious rear deck. The oversized eat-in kitchen offers custom cabinetry, granite countertops, white appliances, and a bright dining area overlooking the backyard. A powder room and convenient first-floor laundry complete the main level. Retreat upstairs to discover, the spacious primary suite features a large walk in closet and private en suite bath. Three additional generously sized bedrooms and a full bath provide exceptional comfort and flexibility. The full unfinished basement offers abundant storage and endless potential for future living space. Step outside to an expansive deck designed for effortless entertaining, outdoor dining, and relaxing while overlooking the private, wooded backyard. Completing this exceptional home are a two-car attached garage, ample driveway parking, and an unbeatable location close to NYC transportation, premier shopping, dining, and top-rated schools.
Listing Courtesy of GARDEN STATE MLS - IDX / Listed By: Eugene Lowe, Howard Hanna | Rand Realty