My Company's Active Listings

$899,900 (USD)
Active

Windham Area Land

Active

Tbd Boulder Brook Lot 33-38 Windham, NY 12496

Bed
0 Baths
sqft
MLS# 20252835
A Rare Opportunity in the Heart of Windham, NY. Welcome to Boulder Brook, an extraordinary and rare offering in the majestic Catskills. Just minutes from the slopes of Windham Ski Resort, this private subdivision presents a unique chance to own an entire mountain retreat or select from six individually surveyed lots, all nestled along a quiet, established country road. Boulder Brook is a blend of wooded privacy with serenity.

Whether you're a developer with a vision for a luxury mountain enclave or a discerning buyer dreaming of a multi-generational family compound, this property is a true canvas for inspired living. The gently rolling terrain, mature trees, and tranquil setting provide the perfect backdrop for building with both intention and elegance.

Located just 2.5 hours from New York City, Boulder Brook offers the best of both worlds: ultimate seclusion surrounded by nature, with close proximity to world-class skiing, scenic hiking trails, golf, dining, and the charming village of Windham. Each lot boasts its own distinct character and potential, making this an ideal investment whether you're buying one parcel or the entire subdivision.

This is a once-in-a-lifetime opportunity to create something remarkable be it a legacy estate, a thoughtfully designed development, or your own private escape. In a market where demand for mountain living continues to rise, Boulder Brook stands out as a rare gem waiting to be discovered.

Buy one, buy them all, either way, Boulder Brook is your gateway to mountain living at its finest.
Listing by: Hudson Valley Catskills MLS / Howard Hanna | Rand Realty / Kyla Thomas
$899,000 (USD)
Active

Union City Area Multi-Family Home

Active

1709 Palisade Ave Union City, NJ 07087

6 Bed
3 Baths
sqft
MLS# 250020486
Dont miss this incredible opportunity to own a beautifully renovated two-family home in one of Union Citys most desirable locations! Perfect for investors or owner-occupants seeking rental income, this historic townhouse combines modern upgrades with exceptional convenience. The gut-renovated first-floor unit features three spacious bedrooms, two full bathrooms, a modern open kitchen, and a private walk-out backyard. The second-floor unit offers three bright bedrooms, a full bathroom, and a charming greenhouse that doubles as a light-filled breakfast room. Recent property improvements include a new sewer line, a new hot water heater, and a newly built masonry front porch and stairs. A full-height basement provides excellent storage and utility space, while the NYC express bus stops right outside the property for a quick commute to Port Authority. Situated on charming Palisade Avenueprized for its newly paved stone sidewalks, tree-lined streets, updated roadways, and classic street lighting that keeps the neighborhood bright and invitingthis home also sits just around the corner from the Union City Reservoir Park and scenic walking path. With quick access to the Lincoln Tunnel, Hobokens Trader Joes, shopping, dining, and vibrant nightlife, the property blends historic character with modern comfort and strong investment potential. Adding to its appeal, the home is fully metered with two electric meters, two gas meters, and two water meters, providing efficient utility management for each unit.
Listing Courtesy of HUDSON COUNTY / Howard Hanna | Rand Realty / Lisandra Sosa
$895,000 (USD)
Active

Throggs Neck Area Multi-Family Home

Active

4175 E. Tremont Ave Bronx, NY 10465

4 Bed
2 Baths
4032 sqft
MLS# 919300
Nestled in the desirable Throggs Neck area of the Bronx, this hidden gem awaits your discovery. Welcome to 4175 E. Tremont Avenue, a beautifully renovated two-family brick home.
The property boasts a meticulously manicured 25x125 lot, featuring a garage, a private driveway, and a spacious basement with endless possibilities.
The second floor houses a renovated three-bedroom unit with hardwood floors, a kitchen equipped with stainless steel appliances, an updated full bathroom, and ample storage. This unit also offers direct access to a spacious 20x14 deck, perfect for relaxation and entertaining.
The accessible walk-in unit includes a large one-bedroom, an eat-in kitchen, a full bathroom, an expansive living room, and ample storage options. Additionally, the property boasts a full walk-out basement with a separate entrance, providing even more space.
Beyond its living space, the property offers several amenities. It features an attached garage, extra parking in the private driveway, a gas boiler, and a large backyard ideal for private gatherings. The property also includes a new heating system, a new hot water tank, and a new roof. Conveniently located near major transportation, shops, and eateries, this home presents a fantastic opportunity. The property will be delivered vacant, ready for its new owner. Please contact me to schedule a viewing today!
Listing by: ONEKEY / Howard Hanna | Rand Realty / Jovani Giron
$884,900 (USD)
Active

Salisbury Mills Area Single Family Home

Active

2 Rosewood Lane Salisbury Mills, NY 12553

4 Bed
3 Baths
2805 sqft
MLS# 836023
Welcome to The Town of Cornwall and all it has to offer. This beautiful new enclave of 4 custom homes surrounded by the often photographed Storm King Mountains and one of the tallest Railroad Trestles in the US.. You are steps away from thousands of acres of walking trails mountains for climbing that is all part of the Land Trust and will remain pristine.. The award winning Cornwall school district and the charming town with it's shops and restaurants . The open floor plan is inviting and perfect for large gatherings or intimate get togethers. There wide oak hardwood floors throughout and a choice of carpet for the bedrooms and bonus room. The family room features a stone surround gas fireplace. The eat in kitchen with it's large island comes complete with custom cabinetry and a choice of stain or paint and quartz counter tops. The master suite has a tray ceiling, a large walk in closet and luxurious master bath with a 5 foot tiled shower and soaking tub. A choice of tiles are available for the baths and powder room. The full unfinished basement will have either a window and slider or Bilco door depending on the lot. You'll be all set if you want to finish the basement in the future. The picture and the tour are from a model in another development. These pictures depict the actual finishes that come standard with our homes.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Theresa Budich
$875,000 (USD)
Active

White Plains Area Single Family Home

Active

7 Gedney Terrace White Plains, NY 10605

3 Bed
3 Baths
1791 sqft
MLS# 923453
Welcome to a one-of-a-kind, fully reimagined Colonial masterpiece nestled in the heart of the prestigious Gedney Park section of White Plains. Renovated with the finest attention to detail, this home seamlessly blends timeless architecture with modern luxury. Clad in elegant granite stone and cedar shake-style vinyl siding, with a cobblestone apron and meticulously updated two-car garage, the curb appeal is simply unmatched. Inside, the open-concept design reveals a sophisticated living space adorned with illuminated tray ceilings, custom wainscoting, and a striking granite stone fireplace, anchored by the soft, natural tones of Nordic white washed oak flooring. The chef's kitchen is a true showpiece, featuring custom white shaker cabinetry, endless quartz countertops, a Wolf built-in microwave, premium stainless appliances, and a center island with designer pendant lighting, perfect for both everyday living and elegant entertaining. Upstairs, the luxurious primary suite boasts two walk-in closets and a spa-inspired ensuite bathroom, adorned with porcelain marble-look tiles. Two additional bedrooms share a beautifully finished hall bath with classic subway tile and a pedestal sink. The finished lower level offers versatile space ideal for a storage, game room, or home gym, and includes a separate laundry area with direct walk-out access to the backyard. Step outside to a lush, level backyard bordered by mature trees, offering natural beauty, privacy, and direct access to the Jack Harrington Greenway walking trail. The backyard also boasts a serene setting for outdoor dining, entertaining, or relaxation. Ideally located just over 3 miles from the White Plains Metro-North station, with seamless access to top-rated schools, acclaimed restaurants, luxury shopping at The Westchester, and all major highways, this residence offers an unparalleled lifestyle of convenience and sophistication. This is more than a home, it's a true statement of style and distinction!
Listing by: ONEKEY / Howard Hanna | Rand Realty / Gino Bello