My Company's Active Listings

$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
$879,000 (USD)
Active

Valhalla Area Single Family Home

Active

159 Prospect Avenue Valhalla, NY 10595

4 Bed
3 Baths
2670 sqft
MLS# 919541
Virtual Tour
Final and best Tuesday 10-21 at 12:00. This impeccably maintained Raised Ranch reflects true pride of ownership and boasts exceptional curb appeal. As you enter, you're immediately embraced by the warmth and comfort that make this house feel like home. The spacious living room seamlessly flows into a large dining area creating the perfect setting for family gatherings. The drop ceiling can be easily removed to reveal soaring cathedral ceilings in the living room, and under carpets are beautiful hardwood flooring. This expansive kitchen features abundant storage, cathedral ceiling/skylight and spacious eat-in area, with direct access to a covered deck overlooking a landscaped yard-ideal for relaxing outdoor dining. Down the hall, you'll find a full hall bath, 2 generously sized bedrooms, a spacious primary suite with its own private bath. The lower level was designed for entertaining and features a large family room with wet bar/refrigerator, and a separate entrance leading to yard. Additionally, there is a full bath and 4th bedroom, laundry and door to oversized 2 car garage. Amazing backyard with a 25 ft. strip of land extending to Madison Ave. Some of the recent updates include new central air-1 yr., driveway sealed, new refrigerator in lower level. Short distance from town, train, buses, Kensico Dam, and all major highways. A must see!
Listing by: ONEKEY / Howard Hanna | Rand Realty / Jeanne Beckley
$849,900 (USD)
Active

Monroe Area Single Family Home

Active

Lot 1 Lakes Road Monroe, NY 10950

4 Bed
3 Baths
2600 sqft
MLS# 846284
This property is a rare find that merges tranquility with convenience, promising a balanced lifestyle. Act now to personalize this home and make your lake-living dream a reality! Discover your dream home on Lakes Rd in scenic Monroe, NY. This brand-new, custom-built house boasts an impressive 2,600 sq ft of living space with 4 bedrooms and 2.5 bathrooms, perfect for growing families or those needing extra space for a home office. Imagine waking up every morning to stunning lake views with exclusive lake rights. Start your day with a coffee on your private deck or take a stroll down to the water's edge, all within the comfort of your own property. The outdoor space provides the perfect backdrop for entertaining or simply relaxing in nature. Inside, you’ll find a spacious layout that combines aesthetics with practicality. The basement offers additional room that could serve as a game room, workout space, or storage area. Quality of life is enhanced by proximity to key community features. Shop for groceries with ease at ShopRite, located just a brief drive away. For leisure, take your pet to the Monroe Dog Park, or indulge in a variety of nearby attractions that enrich the Monroe lifestyle. This is a to-be-built home photos are of a previously sold model. Custom home build only square footage will vary based on the floor plan you choose.
Listing by: ONEKEY / Howard Hanna | Rand Realty / Frank Golio
$849,000 (USD)
Active

Williamsbridge Area Multi-Family Home

Active

1149 East 219th Street Bronx, NY 10469

4 Bed
3 Baths
2125 sqft
MLS# 919922
Williamsbridge Corner Brick Two-Family — Turnkey & Income-Ready!
Welcome to this charming semi-attached brick corner property in the sought-after Williamsbridge section of the Bronx. Thoughtfully updated throughout, it features newly renovated kitchens with stainless steel appliances, refreshed baths, and beautiful hardwood floors—truly move-in ready.
Unit 1 (Duplex) Spacious layout with a sun-lit living room, formal dining room, and a stunning eat-in kitchen with brand-new stainless steel appliances (including dishwasher). A convenient half bath is located on the main level. Upstairs, the space offers three comfortable bedrooms and an updated full bathroom. Enjoy a private balcony plus direct access to the backyard—ideal for relaxing or entertaining.
Unit 2: Beautifully updated 1-bedroom apartment featuring a cozy living room, a fully renovated kitchen, an updated bath, and direct access to the backyard from the living area.
Property Highlights:
* Well-maintained natural gas boiler & water heater
* Digital-controlled garage door
* Private driveway plus garage parking
* Front porch & fenced backyard
* Semi-attached brick construction on a corner lot
Prime Location: Minutes to Bay Plaza Mall, local shops, local buses, Manhattan Express Bus, restaurants, buses & schools. Easy access to I-95, Hutchinson River Parkway, Bruckner Expressway, and the Throggs Neck & Whitestone Bridges. Whether you’re a home owner-occupant seeking supplemental rental income or an investor pursuing a strong Bronx opportunity, this property checks all the boxes. Don’t miss it—schedule your private showing today!
Listing by: ONEKEY / Howard Hanna | Rand Realty / Marianne Soler
$848,000 (USD)
Active

North Bergen Area Single Family Home

Active

6500 Durham Avenue North Bergen, NJ 07047

4 Bed
4 Baths
sqft
MLS# 25031833
Stunning Warehouse Conversion – Expansive Mother-Daughter Home with Designer Finishes Welcome to this beautifully converted warehouse, now a breathtaking mother-daughter residence offering approximately 3,400 sq/ft of thoughtfully designed living space. Soaring 10-foot ceilings and 8-foot doors on the main level create a grand and airy ambiance, while oversized windows and three skylights flood the space with natural light. The heart of the home is the custom chef’s kitchen, featuring a large island with seating for six, sleek Dacor appliances including a 36 gas range, counter-depth refrigerator, and integrated dishwasher—all seamlessly clad in matching cabinetry. The open-concept layout connects the kitchen to an expansive living and dining area, ideal for entertaining. A stylish half bath is conveniently located for guests. Throughout the home, you'll find 5 wide-plank hardwood and imported Italian tile flooring. The luxurious primary suite includes a walk-in closet and private en-suite bath, while two additional bedrooms share a spacious Jack and Jill bathroom. Step outside to a fully finished backyard oasis complete with pavers, privacy fencing, and both gas and electric hook-ups—perfect for outdoor gatherings. The lower level offers a separate living space, ideal for extended family or guests, with its own bedroom, full bath, kitchenette, laundry room, and a massive entertainment area surrounded by custom cabinetry and storage. Every inch of this home has been
Listing Courtesy of NJMLS / Howard Hanna | Rand Realty / Constantine Marakas
$848,000 (USD)
Active

North Bergen Area Single Family Home

Active

6500 Durham Ave North Bergen, NJ 07047

4 Bed
4 Baths
sqft
MLS# 250017516
Virtual Tour
Stunning Warehouse Conversion Expansive Mother-Daughter Home with Designer Finishes Welcome to this beautifully converted warehouse, now a breathtaking mother-daughter residence offering approximately 3,400 sq/ft of thoughtfully designed living space. Soaring 10-foot ceilings and 8-foot doors on the main level create a grand and airy ambiance, while oversized windows and three skylights flood the space with natural light. The heart of the home is the custom chefs kitchen, featuring a large island with seating for six, sleek Dacor appliances including a 36" gas range, counter-depth refrigerator, and integrated dishwasherall seamlessly clad in matching cabinetry. The open-concept layout connects the kitchen to an expansive living and dining area, ideal for entertaining. A stylish half bath is conveniently located for guests. Throughout the home, you'll find 5" wide-plank hardwood and imported Italian tile flooring. The luxurious primary suite includes a walk-in closet and private en-suite bath, while two additional bedrooms share a spacious Jack and Jill bathroom. Step outside to a fully finished backyard oasis complete with pavers, privacy fencing, and both gas and electric hook-upsperfect for outdoor gatherings. The lower level offers a separate living space, ideal for extended family or guests, with its own bedroom, full bath, kitchenette, laundry room, and a massive entertainment area surrounded by custom cabinetry and storage. Every inch of this home has been meticulously updatednew HVAC, roof, windows, plumbing, electrical, and more. The builder has truly thought of everything. This one-of-a-kind property is a must-see!
Listing Courtesy of HUDSON COUNTY / Howard Hanna | Rand Realty / Constantine Marakas