ML# :926342   Welcome to 210-24 23rd Avenue, Bayside, NY 11360 — a rare opportunity to own a solid 2-family residential income property perfectly positioned in one of Bayside’s most desirable and convenient neighborhoods. This well-maintained brick property offers three spacious residential units plus a full basement, making it an exceptional choice for investors or end-users seeking strong rental potential and long-term appreciation.Each apartment is designed for comfort and functionality, featuring bright living spaces, updated kitchens, modern bathrooms, and ample storage. The building’s layout is efficient and versatile, providing both privacy and convenience for tenants while maintaining a seamless flow throughout. The full basement adds tremendous value, laundry hookups, and flexible space for recreation, storage, or future expansion possibilities.This property sits on a quiet, tree-lined residential block, surrounded by a blend of single-family and multifamily homes that reflect Bayside’s well-balanced suburban charm and city accessibility. Enjoy easy access to Francis Lewis Blvd, Northern Blvd, and the Clearview Expressway (I-295), making commuting into Manhattan or Long Island effortless. The property is also conveniently located near Bayside’s vibrant Bell Boulevard, known for its restaurants, cafes, shopping, and nightlife, as well as top-rated public schools, Francis Lewis High School, PS 159, and PS 41, and local parks such as Crocheron Park and Bayside Marina — perfect for outdoor recreation and weekend strolls.Tenants and owners alike will appreciate private parking and a well-maintained exterior, enhancing both curb appeal and functionality. Utilities are separated for each unit, providing ease of management and cost efficiency. This income-producing property offers steady rental returns and potential upside through value-add upgrades or future redevelopment under current zoning.Whether you’re expanding your investment portfolio or seeking a multifamily home in one of Queens’ most sought-after areas, 210-24 23rd Avenue delivers exceptional value, unbeatable location, and lasting potential. Properties of this caliber in Bayside rarely come to market — don’t miss the opportunity to make this one yours.Schedule your private showing today and explore the income potential that comes with owning a property in one of the most stable and appreciating neighborhoods in Northeast Queens.*PICTURES CAN BE VIRTUALLY STAGED*, *CURRENTLY VACANT*

ML# :915562   Welcome to a residence where timeless elegance meets modern sophistication. Nestled in the exclusive Montebello Pines community, this stately Center Hall Colonial offers an exceptional blend of architectural grandeur and serene privacy. With 4, 591 square feet of exquisitely designed living space, this 5-6 bedroom, 4.5-bath estate is a sanctuary of comfort and style. A paver walkway with mature plantings and a pond creates the ambiance for your grand entry. Upon entry, you’re greeted by a dramatic two-story foyer, adorned with an elegant chandelier and flanked by soaring ceilings and sun-drenched spaces that flow seamlessly throughout. The home’s open-concept design is accentuated by skylights and oversized windows, filling each room with an abundance of natural light. The formal living and dining rooms are ideal for hosting, with the dining room opening onto a private blue stone terrace, perfect for al fresco gatherings. The heart of the home is the oversized chef’s eat-in kitchen, featuring multiple stations with granite countertops, stainless steel appliances, and a multi-functional center island. Relax in the spectacular great room, where a stunning floor-to-ceiling stone fireplace anchors the space, enhanced by vaulted ceilings and loads of natural light that invite the outdoors in. Upstairs, the bedroom suites offer restful luxury, including a lavish primary retreat with spa-like amenities, sitting area, walk-in closet & direct access to the Bonus Room. Each bathroom is thoughtfully appointed ensuring ultimate comfort and privacy for all. The ready-to-be-finished basement features high ceilings and a grand open space with plenty of egress windows and a sliding doors that welcome you to the backyard with a private paver patio area. Outside, the oversized deck leads to a vast, meticulously maintained backyard — a private haven for both quiet reflection and lively entertainment. The lush surroundings offer peace and privacy rarely found, creating a true escape from the everyday. Located directly across the street from Kathryn Gorman Ponds Park for an additional retreat. Perfectly situated in one of the area’s most coveted communities— an extraordinary offering for the most discerning buyer. BONUS: Irrigation System, Video Surveillance, Brand new washer in Laundry Room & so much more!

ML# :922931   Welcome to Split Rock Cottage, this fully furnished, renovated designer, Centre Island Cape may be the treasure you seek. In an exclusive community with beach and mooring rights, private police, it shares this island with grand estates and high profile individuals. Up the road, Seawanhaka Corinthian Yacht Club provides frequent sailing regattas – fun to watch. A six-minute scenic drive away, Oyster Bay Village offers charming restaurants, shops, waterfront center, and train station. About thirty-five-miles from Manhattan, you can escape the city and be home to your picture-perfect, blue and white cape in about 1.5 hours. This picture-perfect, 3-bedroom, 2-bath, 8-room home will welcome you with a seaside atmosphere, sophisticated appointments, and a beautiful setting for grand, year-round entertaining. Just a short drive from the Locust Valley and Manhasset areas, offers you easy access to premier shopping, dining, theatre, universities, estate museums, and sports venues including golf, boating, equestrian facilities, horse trails, and nature walks. Whether you are searching to upgrade your lifestyle or want a weekend getaway from the city for yourself, or to reward an outstanding employee, or a perk for your favorite customer, this stunning party house is the answer to your dreams. As you turn into your courtyard, you feel right at home. Past lush plantings, charming front door, and front patio with umbrella, table, and chairs, a stone walkway leads between the house and storage shed to an outdoor kitchen and delightful Tiki bar that seats six, with wet bar, television, and water views. Steps descend to a large stone patio, winding lawn, many potted plants, water fountain, luxury seating, hot tub, shady umbrellas, and ample space to accommodate a crowd. Enjoy the firepit with friends or wash off sand and salt in the nearby privacy-fenced shower. A lovely side garden leads up to a deck with dining platform, second gas grill, and another comfortable conversation area. No matter the occasion, whether entertaining a few friends, holding a shindig, taking a hot soak, sunbathing, or enjoying a sunny breakfast, you will love your new home. The home’s interior boasts a charming foyer with shiplap walls, privacy-glass entry door, closet, and staircase with black iron-and-wire balustrade. Farm-style French doors open to a large study with adjoining bedroom and lovely full bath. Possible first-floor primary suite. The spacious, sunny living room offers water views, a wood-burning fireplace encased in Azui Macaubas polished porcelain and white leathered marble, a huge, framed-picture television, and reclining leather chairs and sofa. The adjoining great room features a vaulted ceiling and a stunning lapis-lazuli accent wall and skylights in the “bubble lounge” area. An L-shaped marble breakfast bar, with seating for seven, flows into the kitchen offering ample white oak cabinetry, stainless steel appliances, sliders to the dining deck, and a door into the one-car garage with lift, now used as a deluxe gym with door to deck. The second floor features a lavish Azui Macaubas polished porcelain and white leathered marble primary bath, an immense four-season, walk-in closet with water views, and a luscious primary bedroom- authentic alligator bed. The lower level provides room for fun with billiard table, coffee bar/beverage station-mini refrigerator, Sorrento game table (poker, roulette, chess, checkers, backgammon), and a striking designer bath. Additional features include two-zone climate control for central air and electric forced air; portable backup generator (propane or diesel); access panel in study; new roof in 2024; gutter guards; and cesspool serviced 2024. Just 800-avenue-feet is the local private beach where you can swim, paddleboard, kayak, and moor your boat. Come, sail across the harbor to Coopers Bluff or enjoy the famous lobster salad at The Clam Bar at Bridge Marina. Turn-key, Low Taxes! View 3D tour & floor plan.

ML# :919152   Welcome to Residence 17C at 172 Madison Avenue, a beautifully designed 1-bedroom, 1.5-bath home in the heart of Manhattan. This bright and spacious residence features floor-to-ceiling window, filled with natural light and offers open city views that create a sense of calm above the bustle of Midtown. The thoughtfully planned layout features a modern kitchen with high-end appliances, an airy living space ideal for both relaxing and entertaining, custom cabinetry and a serene primary suite with a sleek bathroom. A stylish powder room adds convenience for guests, making this the perfect blend of comfort and sophistication. Residents enjoy full-service luxury amenities, including 24-hour doorman and concierge, a fitness center, swimming pool, residents’ lounge, children’s playroom, and a rooftop deck. Perfectly located near Grand Central, Bryant Park, and Fifth Avenue, this home combines modern style, comfort, and Manhattan convenience in one exceptional residence. Don’t miss the opportunity to make this stunning home yours!

ML# :919365   Investment Opportunity : 6-Family Building in Prime Astoria Location. Discover this solid 6-family building. Featuring a total of 11 bedrooms and 6 bathrooms, this property includes 2/2BR and 1/1BR stabilized apartments providing steady income, alongside 3/2BR free-market units offering excellent potential for higher returns. Full finished basement and 2 car garages. New roof 2017. Ideal for investors seeking a well-maintained multi-family asset in a vibrant neighborhood with strong rental demand. Close to all Amenities and Transportation. Just Two small blocks from N/W trains Astoria Blvd station, and a block to 30th Ave. Don’t miss the chance to expand your portfolio in one of Queens’ most desirable communities. No Violations. All documents and DHCRs are transparent.

ML# :917454   Welcome to 1 Regency Lane, Dix Hills!This spacious 5-bedroom, 3-bathroom ranch is nestled in Dix Hills within the award-winning Half Hollow Hills School District. Designed for both everyday living and entertaining, the home blends modern updates with timeless charm.The unique feature of the home is the separation of the bedrooms creating 2 sleeping quarters. The South Wing features the Primary Bedroom with a private ensuite bath, 2 other bedrooms and a main hall full bath. The North Wing features 2 good size bedrooms, a main hall full bath and staircase access to a partial basement making this home a very good share house. Inside, the renovated kitchen showcases an open floor plan, Bosch dishwasher & cooktop (3.5 yrs), KitchenAid refrigerator (6.5 yrs), and a microwave (3 yrs). The living areas feature oak hardwood flooring, a cozy wood-burning fireplace, and a wired sound system. The primary suite offers a whirlpool tub, while a pull-down attic and 2-car garage add convenience and storage.Recent updates include: windows (7 yrs), central air (3.5 yrs), oil tank (6 yrs), and cesspool (6.5 yrs).Step outside to your private oasis on .9 acres, where a brand-new (2024) saltwater smart pool with 3 waterfalls and 2 fireballs creates a stunning focal point. The backyard is enhanced by aluminum estate fencing, a 12-zone sprinkler system, and a large patio—perfect for entertaining guests or relaxing in style.This exceptional property combines comfort, updates, and resort-like amenities in a sought-after Dix Hills location. This is a very wide piece of property that can easily be expanded.

ML# :918593   Montebello Pines beauty! Warm and inviting, this impeccably maintained home offers tremendous flexibility, with the potential to easily convert into a 6 or even 7 bedroom layout to suit your needs.Inside you will find a perfect flow throughout, beginning with the tremendous kitchen boasting custom cabinetry, tons of counter space, and radiant heat floors. The open-concept dining and living area spans one expansive space, creating a seamless and inviting atmosphere for gatherings.Upstairs, each bedroom is generously sized, including the stunning primary suite, which features a spa-like en-suite bathroom complete with radiant heat. All bathrooms have been recently renovated to a high standard, with top of the line fixturesFull finished basement with plenty of additional living space including the potential for extended living. Abundance of storage throughout. Gorgeous, serene, level backyard overlooks golf course. Great location in neighborhood with easy access to major highways, public transportation, shopping, schools. With plenty of space for everyone to spread out, this is an opportunity not to be missed!

ML# :916431   Set on 36 acres along one of the area’s most beautiful roads, 898 Gipsy Trail Road feels like a private country retreat overlooking Bird Pond. This estate was built as a place for gathering, with six bedrooms, six bathrooms, and a layout designed to welcome family and friends with ease. The foyer sits at the heart of the home, connecting the spaces that define the main level. To one side, the primary suite offers its own fireplace and a quiet retreat. Nearby, an additional bedroom provides flexibility for guests. The main living room opens to the back deck and frames sweeping lawn and lake views, while the dining room and chef’s kitchen create a natural hub for entertaining. A second living room and a sunroom with a dramatic stone fireplace add yet more options for relaxation in every season. Upstairs, four bedrooms are balanced by a bright family room at the center, ideal for gathering or play. The walk-out lower level extends the living space with a bonus room, two oversized playrooms, a sauna, and a full bath. Outdoors, the property stretches in every direction. Rolling lawns slope down toward the pond, while an expansive pool with pool house anchors the summer setting. More than a house, this is a true compound, an escape that can host generations, while being just minutes to the Trail Club & highways to be in the city in 1 hour.

ML# :913651   Lovely Corner Buidling - First floor is used as a Dentist office with 2 Entrances, Waiting area, Reception, Exam rooms and Bathroom. CAC and Gas heat. 2 Floor has 2 apts. Front facing is a lovely one bedroom with EIK, LR, Full Bath and Pull down stairs to storage in Attic. Rear facing unit is a nice size 2 Bedroom, LR, EIK and Full Bath with Pull down stairs to strorage in Attic. Large Corner lot with private driveway and 3 car garage.

ML# :912945   Welcome to The Rowan, Astoria’s premier modern condominium offering the perfect blend of urban sophistication and neighborhood charm. Just one block from the Ditmars Boulevard station, this serene and design-forward residence is surrounded by a thriving cultural scene and lush green spaces.This unique southeast-facing corner unit spans 1, 288 square feet of thoughtfully upgraded interior living space, plus a generous 397-square-foot private terrace with a connected natural gas grill. This outdoor space has amazing views and is ideal for entertaining or quiet relaxation. The home features two bedrooms and two full baths and stands out with high ceilings, sleek finishes, and customizations throughout. The open concept kitchen is equipped with a premium Miele appliance suite, including a 36” gas cooktop, convection oven, dishwasher, built-in French door refrigerator, and stacked washer/dryer. Homeowner upgrades include walk-in closet and window seating/storage by California Closets, motorized solar shades, custom drapery, designer chandelier, and Dornbracht bathroom fixtures. Additional homeowner improvements include enhanced storage, elegant wallpaper in the entryway, and a professionally painted finish throughout.This is a rare opportunity to own a beautifully customized, light-filled corner home with expansive outdoor space in one of Queens’ most vibrant neighborhoods. Designed by DXA Studio, The Rowan welcomes you with a verdant courtyard and a glass-walled lobby that opens into a tranquil outdoor lounge. Residents enjoy access to a landscaped rooftop with sweeping views, a stunning indoor/outdoor lounge, fitness center, children’s playroom, parking garage, and proximity to the N/W trains. A private storage unit is also included as well as gas and water included in the common charges.