ML# :844507   Flushing’s New Iconic Commercial Tower – Located in the heart of Downtown Flushing, Union Center is the area’s newest Class A commercial development, setting a new benchmark for office, medical, and life science space. Unit 1407 features approximately 891 square feet of flexible layout, ideal for professional or medical use. This 15-story, glass-fade building offers a full suite of modern amenities, including floor-to-ceiling windows, private outdoor terraces, and a fully automated robotic parking system by Stolzer. Tenants benefit from cutting-edge VRF HVAC systems; co energy-efficient curtain walls, and a thoughtfully designed infrastructure built to accommodate high-demand commercial uses.Union Center is also qualified for a 25-year tax abatement, offering long-term savings and excellent value for owners and investors. Just one block from the Main Street 7 Train, close to the LIRR, and surrounded by 20+ MTA bus lines, Union Center provides seamless access to Manhattan, Brooklyn, Queens, and Long Island. The building is steps from major hospitals, banks, retail, dining, and highways. Estimated completion: Spring 2026

ML# :901019   Welcome to 195-12 McLaughlin Avenue Holliswood, NY 11423, a rare find in one of Queens’ most coveted and elevated residential enclaves. This three-story detached home sits proudly offering a unique combination of space, views, and untapped architectural expansion and customization. With 4 spacious bedrooms, 2.5 baths, a pull down attic staircase, a finished walk out basement, and a private attached garage, leading to a spacious walk out driveway that can accommodate several cars as well as an expansive private backyard this home is awaiting your personal vision and imagination. The second floor landing has 3 bedrooms, 1 full bath as well as multiple closets. The first floor has 1 bedroom, powder room, laundry room with washer and dryer.Whether you’re envisioning a full modernization or a strategic extension to maximize square footage and value, this property invites bold creativity. Add a sunroom, expand the kitchen, elevate the curb appeal with a new façade—the possibilities are endless.Inside, you’ll find a welcoming foyer, a formal living room, an elegant dining room, a mudroom, and ample closet space—a classic layout perfect for modern reimagining. The finished basement offers the flexibility for a guest suite, home office, gym, or entertainment space and a huge cedar closet..Located in an upscale, serene and secured community known for its well-maintained homes, tree-lined streets, and a strong sense of neighborhood pride, this property offers both tranquility and convenience. Enjoy hilltop views, natural light throughout, and a sense of privacy that’s hard to find in the city.The zoning permits extension up to 0.5 FAR on this 4356 square foot that offers the potential to customize to your desire to make this home your dream mansion.Neighborhood Highlights: • Just minutes to St. John’s University, York College, and Queens College• Located in Holliswood, Jamaica - Estates. • Easy access to Grand Central Parkway, Cross Island Parkway, and public transportation (buses and LIRR)• Near Union Turnpike shopping corridor, gourmet groceries, fine dining, several parks, and top-rated District 26 schools.• Short drive to LGA & JFK Airports and LIJ & North Shore Hospital• Multiple Houses of various WorshipDistrict 26 Zoned Schools:• PS 178 Holliswood School• IS 216 Ryan JHSWhether you’re an end-user ready to create your dream home or an investor seeking value in a prime high-demand area, 195-12 McLaughlin Ave Holliswood Queens, NY offers the best of both worlds—solid bones and extraordinary potential.

ML# :894771   Welcome to 195-12 McLaughlin Avenue Holliswood, NY 11423, a rare find in one of Queens’ most coveted and elevated residential enclaves. This three-story detached home sits proudly offering a unique combination of space, views, and untapped architectural expansion and customization. With 4 spacious bedrooms, 2.5 baths, a pull down attic staircase, a finished walk out basement, and a private attached garage, leading to a spacious walk out driveway that can accommodate several cars as well as an expansive private backyard this home is awaiting your personal vision and imagination. The second floor landing has 3 bedrooms, 1 full bath as well as multiple closets. The first floor has 1 bedroom, powder room, laundry room with washer and dryer.Whether you’re envisioning a full modernization or a strategic extension to maximize square footage and value, this property invites bold creativity. Add a sunroom, expand the kitchen, elevate the curb appeal with a new façade—the possibilities are endless.Inside, you’ll find a welcoming foyer, a formal living room, an elegant dining room, a mudroom, and ample closet space—a classic layout perfect for modern reimagining. The finished basement offers the flexibility for a guest suite, home office, gym, or entertainment space and a huge cedar closet..Located in an upscale, serene and secured community known for its well-maintained homes, tree-lined streets, and a strong sense of neighborhood pride, this property offers both tranquility and convenience. Enjoy hilltop views, natural light throughout, and a sense of privacy that’s hard to find in the city.The zoning permits extension up to 0.5 FAR on this 4356 square foot that offers the potential to customize to your desire to make this home your dream mansion.Neighborhood Highlights: • Just minutes to St. John’s University, York College, and Queens College• Located in Holliswood, Jamaica - Estates. • Easy access to Grand Central Parkway, Cross Island Parkway, and public transportation (buses and LIRR)• Near Union Turnpike shopping corridor, gourmet groceries, fine dining, several parks, and top-rated District 26 schools.• Short drive to LGA & JFK Airports and LIJ & North Shore Hospital• Multiple Houses of various WorshipDistrict 26 Zoned Schools:• PS 178 Holliswood School• IS 216 Ryan JHSWhether you’re an end-user ready to create your dream home or an investor seeking value in a prime high-demand area, 195-12 McLaughlin Ave Holliswood Queens, NY offers the best of both worlds—solid bones and extraordinary potential.

ML# :927288   Hilltop Equine Estate - Experience breathtaking views from nearly every vantage point of this stunning hilltop estate. Thoughtfully designed and masterfully built, this 4-bedroom, 3.5-bath ICF-constructed home offers exceptional quality, energy efficiency, and comfort throughout its approximately 3500 sqft, three infloor radiant-heated levels. The main floor features a spacious kitchen overlooking the dining area, family room, and living room—ideal for everyday living and entertaining. A convenient first-floor laundry completes this level. Upstairs, you’ll find four generous bedrooms, each with picturesque views. The primary suite includes a spa-inspired bath and a”rooftop” terrace that captures the estate’s gorgeous scenery. The lower level offers a versatile space with a full bath and kitchenette—perfect for a game room, guest suite, or in-law quarters. Outdoor living is equally impressive with a back deck and side porch, both offering tranquil views of the manicured 12+ acres. The immaculate 9-stall barn is well-lit and fully equipped with a secure tack room, viewing area overlooking the 100x120 outdoor arena, and multiple well-drained pastures and paddocks. Additional features include a large storage barn and a 2, 100 sqft workshop for hobbies or creative pursuits. Come experience the beauty and functionality of this exceptional equine estate—an inspiring place to call home.

ML# :921672   Beautifully maintained DETACHED 2-family home (2 bedrooms over 2 bedrooms) with a finished separate walk-out that consists of a legal accessory kitchen, playroom, den and half bath. Sits on a double lot. Very large driveway that fits 4-5 cars in addition to the two-car detached garage. It’s conveniently located walking distance of approx 10-15 minutes to the #6 train stop on Buhre Avenue and Westchester Avenue. Walking distance to Crosby Avenue where you can bank, shop and dine as well as catch the local buses and/or Manhattan Express bus stop. One-minute walk to the Waterbury/La Salle community Park. The house will be delivered vacant if needed but currently occupied; all have one-year leases. Ideal for an extended family or anyone looking to invest in a multi family.

ML# :923741   SHOWING BY APPONTMENT ONLY.Unlock the potential of this Legal 3-family home in one of Astoria’s most sought-after neighborhoods. This three-story building offers incredible value and versatility with three separate units, two entrances, and a private backyard - perfect for investors or end-users looking to create their dream space.The first walk in unit has a separate entrance and consists of a one bedroom, one bathroom. There is space for a greenhouse or extension and a large backyard. The units on the 2nd and 3rd floor have their own entrance. The 2nd floor is set up as a one bedroom and top floor can be customized as one bedroom plus home office. Bring your architect!Customize this space as you desire as this home will require some TLC. There is an approximate 1000 Sq Feet that can be added to this property, but always confirm with your architect!While the property needs some TLC, this is a legal 3 family in an unbeatable location make it a true diamond in the rough.Just moments from the Astoria Ferry, N/W trains at 30th Avenue , and all the dining, shopping, and culture that make Astoria a beloved Queens destination.Whether you’re looking to renovate and rent, live in one unit while collecting income from the others, or develop further - this is a rare opportunity you don’t want to miss.Property can be delivered vacant.Don’t miss this chance to own a multi-family in a thriving and growing community!Lot Size: 16.5 X 95Building Size: 16 X 45 SqFootage as Built: 1, 920FAR: 3, 136

ML# :920116   Don’t miss a rare opportunity to own this unique, custom built rambling ranch with solid detailed mill work and beams throughout-unmatched character and craftsmanship. As you enter through the brick pillars you will see the lush greenery and experience the tranquility of this private and serene mini estate. When you enter the home, you are greeted by a great room with a cathedral ceiling, beams, special custom woodwork, a wood burning fireplace and hardwood floors. An additional spacious living area has another fireplace, beams, millwork and an inlaid hardwood floor. A third fireplace warms a cozy dining area overlooking the beautiful 1.25 acre professionally landscaped yard. The kitchen is lined with pine and walnut cabinetry with stained glass, granite counters. This meticulously maintained home is made for entertaining. Parking and storage is not an issue! All within close proximity to shopping, highways, transportation, beaches and the quaint towns of Huntington and Northport. Award Winning Elwood SD1. This home is being sold As Is Please do not enter property or walk grounds, property has security and cameras.

ML# :898086   Experience the serenity of coastal living at Maidstone Landing, a premier North Fork community perched on a shoreline hilltop overlooking the vast shimmering waters of the Long Island Sound and a tranquil 25 acre pond. Realize your dream of resort-style living in this large 3 bedroom/3.5 bath Beachcomber model offering three levels of spacious living with winter pond views. A dramatic double height wall of windows in the open concept living room – complete with a vaulted ceiling and gas fireplace-creates a striking focal point while perfectly framing the outdoor deck and the beautiful outdoors. A primary suite with spa bath, a spacious kitchen with dining area, a guest powder room and a laundry center with access to the attached 2 car garage complete the first level. Upstairs you’ll find two additional bedrooms and full bath, ideal for family and guests. The finished lower level adds even more living space with a cozy family room with gas fireplace with double sliding doors providing natural light and easy access to the outdoor patio. Additional lower level features include a large bonus room, perfect for office or guest space, a full bathroom and storage. Welcoming residents of all ages, Maidstone Landing offers wonderful amenities including an inviting clubhouse with dining decks boasting views of the salt water pool and LI Sound, a fitness center, tennis and pickleball courts and access to a beautiful 1400’ private beach. With close proximity to fabulous dining and shopping, wineries, farm stands and verdant golf courses- this is North Fork living at its best!

ML# :916958   Welcome to 57 Hollywood Court, a beautifully maintained Tudor in the Harvard area of Rockville Centre! The first floor consists of an entrance foyer, large living room with wood-burning fireplace, den, formal dining room, half bath, and a beautiful new kitchen with access to the peaceful back garden. The second floor offers a new Pottery-barn inspired hall bath, large primary bedroom with en-suite bath, and two additional bedrooms. The third floor suite is comprised of a large bedroom with sitting area and a half bath. Finally, the partially finished lower level would be a great playroom and/or home office. The home, which is located on a dead-end street, was renovated in 2021 and now offers a new gas-fired heating system, new hot water heater, and upgraded electrical.Taxes on the listing include the Village of RVC tax, which is $5, 311.26 annually.

ML# :916283   Welcome to a sophisticated sanctuary at 720 Milton Road, Unit H3, Rye. This exquisite direct waterfront residence offers a blend of luxury and comfort with 2 bedrooms and 2.5 bathrooms, sprawled across 2, 100 square feet of thoughtfully designed living space. Watch the boats sail by from the open concept living and dining areas, where sweeping water vistas of Milton Harbor and the lush greens of Rye Golf Club create a serene backdrop. The newly built outdoor deck is perfect for enjoying stunning sunsets over the harbor, providing a seamless transition between indoor and outdoor living. The second level is a haven of tranquility, showcasing a bright primary suite with panoramic water views, a spacious walk-in closet, and an en-suite bathroom. The second bedroom, equally inviting, also boasts an en-suite bathroom and abundant closet space, ideal for guests or family members. For your convenience, the entry level houses a laundry area, additional storage, and provides access to the attached garage and private driveway. As part of a distinguished gated community, residents enjoy exclusive amenities such as a waterfront pool with breathtaking views of New York City, a marina perfect for kayaking enthusiasts, and 24-hour security. Don’t miss the opportunity to call this unparalleled waterfront retreat your home.