My Company's Active Listings

$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

Olive Area Single Family Home

Active

18 Jomar Olivebridge, NY 12461

3 Bed
2 Baths
1485 sqft
MLS# 20251765
You'll understand just how special this 41 Acre property is once you arrive. Just driving down the country road to get here is already a treat. Situated at the base of the majestic High Point Mountain you'll find a private driveway that takes you through a beautiful forest and then it opens up to acres of your own open farmlands.....the open fields are perfectly suited to horses and with an amazing newly painted Gambrel Roof Horse Barn, you can move them right in and start enjoying every aspect of country life. The peaceful feeling this private property gives is unmatched. The home is nestled perfectly along the woodlands with great views of the open fields. Watch your horses, cows or goats grazing or just relax on the open front porch and breath in all the fresh air! The home has been very well maintained and features a charming stone fireplace, pretty solid wood six panel doors, a kitchen with multiple wood cabinets including an integrated pantry, Corian countertops, a gas stove and peninsula open to a dining area with large windows overlooking those gorgeous views. The split floor plan has two bedrooms on one side of the house while the Primary Bedroom Suite is on the other side which offers some privacy from the kiddos or guests. Just off the living room you'll find a charming enclosed porch with wide board knotty pine floors and large windows overlooking your own pristine forest. The oversized two car garage has ample space for a workbench, contains a storage closet and the entrance to the poured concrete crawl space which houses the utilities. Once you step foot in the barn, your imagination will light up.... what a great space on the ground level for horses or other livestock with a center isle and several stalls that can be used in a variety of ways, high ceilings with exposed beams and four entrance/exit doors for ease in cleaning or moving animals. The Second floor of the barn contains an exterior hay door PLUS there is a full interior staircase to a HUGE open space with lots of headroom for hay storage, tack, etc. This barn offers so many possibilities.... it is such a great building for other dreams as well.... Possibly convert it to your own personal artist studio or workshop....it contains its own electric service. Take your time to walk around this lovely property, you will find there are two small streams, beautiful old growth trees along the perimeter and tons of space to enjoy. This large, sub-dividable lot contains such a diversity of land types including heavily and lightly forested areas, open meadows, wetlands, rock outcroppings, charming natural streams and pretty landscaping around the house. This beautiful property is in close proximity to the picturesque Ashokan Reservoir that features a pedestrian only paved walking/biking promenade showcasing vast views of the surrounding Catskill Mountains and breathtaking Ashokan Reservoir and also the Ashokan Rail Trail which meanders through miles of beautiful forest alongside the shoreline of the reservoir and Esopus Creek. In addition, the Mohonk Preserve with its amazing trails and swimming lake are a short drive away. The Catskills offer so much to enjoy between all the hiking trails and high peak vistas, but also all the charming small villages with quaint shops and restaurants. You'll never feel bored and you'll always feel relaxed and at peace in this special area.
Come see this exceptional property as soon as possible...it is such a rare find.... once you see it, you will absolutely love it!!
Listing by: Hudson Valley Catskills MLS / Howard Hanna | Rand Realty / Edwin Maldonado
$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