ML# :877461   This offering consists of a package of 3 adjacent mixed-use buildings with substantial redevelopment potential, locatedin the heart of Downtown Flushing—one of Queens’ fastest-growing neighborhoods. The subject property sits in an R7-1 zoning district with an FAR of 4.8, making it a prime development site for future residential expansion or repositioning. Currently, all residential units are leased at more than 20% below market rent, offering investors a clear value-add opportunity through rental adjustments. With stable tenancy, underutilized income, and long- term development upside, this asset offers both immediate cash flow and significant future growth potential. As part of a 3-building package, this is a rare opportunity to acquire a strategic footprint in a high-demand urban core with strong connectivity and sustained market momentum.

ML# :917560   New two Family Solid brick Mid-block: driveway, garage.First floor Features 5-bedroom 2 full bath Livingroom dining room eat in kitchen. wall to wall solid wood floors. Second floor features 5 Bedroom 2 full bath Livingroom dining room eat in kitchen wall to wall wood floors. Balcony Basement: full finished open spaced: with one full bath, Laundry.

ML# :896230   Hamptons-Inspired Luxury in South Bayport’s Estate Section-Nestled on 1.1 acres in the highly sought-after estate section of South Bayport, this modern farmhouse with a charming guest cottage offers the ultimate in luxury and privacy. Rebuilt from top to bottom with no expense spared, this home caters to the most discerning buyer—featuring top-tier craftsmanship, premium fixtures, and designer materials throughout. Step into the dramatic formal living room with soaring ceilings, wood beams, and an oversized fireplace that anchors the space with warmth and grandeur. Sunlight pours through expansive custom windows, enhancing the home’s open, airy feel. A bright sunroom with coffered ceilings invites peaceful mornings and cozy afternoons. The chef’s kitchen is a culinary masterpiece—designed with luxurious cabinetry, a professional-grade Wolf range, and chef-level appliances. A hidden walk-in pantry with brick flooring is a delightful surprise, offering both function and charm. The formal dining room is grand in scale, ideal for entertaining with room for banquet-sized furnishings. The main level also features a spacious den for relaxed living and a serene primary en suite with designer finishes and walk in closet. Upstairs, two guest bedrooms are complemented by a tucked-away library or office space—perfect for work or quiet reading. The guest cottage is a showstopper—ideal as a home office, private guest retreat, or future pool house. Every inch of this property has been thoughtfully designed to offer exceptional living, indoors and out. Luxury, privacy, and timeless design—welcome to your South Bayport dream

ML# :913197   This stunning Euro Chic, 4-bedroom, 2.5-bath home was fully rebuilt with high-end finishes in 2008 and offers an open floor plan ideal for indoor & outdoor entertaining. Notable features include a brand new primary bath, smart appliances, Nest thermostat, central air, and sliding barn doors. Enjoy outdoor living with a heated saltwater pool, 1.5-year-old liner, gorgeous stone patio, retractable awning, outdoor shower, and uplighting.Eco-friendly upgrades include a new owned solar panel system, whole-house generator (2017), brand-new sprinkler system with mosquito control, and whole-house water + pool filtration. Freshly painted exterior (2024) with Dryvit stucco, 2-year-old roof, and 5” gutters.Extras include 2 sheds, French drain, 4-car driveway, and security cameras included. A truly move-in ready home blending comfort, style, and efficiency.

ML# :910840   Welcome to this beautifully renovated home that sits on one of the largest properties in all of Saddle Ridge. This home perfectly blends modern luxury with everyday comfort. The heart of the home is the stunning chef’s kitchen, thoughtfully designed with high-end stainless steel appliances, sleek countertops, and ample cabinetry—ideal for both entertaining and culinary creativity. An elegant extension of the main living area offers an open, airy feel with plenty of natural light, and cathedral ceilings seamlessly connecting indoor and outdoor spaces. Downstairs, a den space with sliding doors that lead to a massive backyard. The finished basement provides versatile living space perfect for a media room, home gym, or guest suite. Outside, this property truly shines with a tremendous 63x207-foot lot, featuring a large custom composite deck surrounded by stylish pavers—an ideal setting for gatherings, outdoor dining, or simply relaxing in your own private oasis. This is more than a home—it’s a lifestyle.

ML# :905210   Only 2 lots left! Custom design your dream home in a seamless process with ZappiCo, Westchester County’s premier Real Estate Developer! This luxurious home is to-be-built in the highly desirable Irvington School District. With 4 spacious bedrooms and 2.5 beautifully appointed bathrooms, this home will be meticulously crafted with the finest materials and attention to detail.As you enter, you will be greeted by an open concept living and dining area, perfect for entertaining guests or relaxing with loved ones. The gourmet kitchen will feature an open layout with granite countertops and semi-custom cabinetry. The open concept main level will also offer a family room & living room - perfect for those who work from home or need a quiet space to study. Upstairs, you will find a spacious master suite complete with a spa-like end suite bathroom and walk-in closet, as well as three additional bedrooms with ample closet space. Other features of this home will include hardwood flooring throughout, energy efficient windows, 2-zone central air, and a full finished basement (1, 200 Sf incl. in total SF) ready for your personal touch. Outside, landscaping is included to create your own oasis.Located just a short distance from local restaurants, shops, and parks, this home offers the perfect blend of luxury living and convenience. With the ability to customize your finishes and personal touches, this to-be-built home is the perfect opportunity to create your dream home in Tarrytown. Photos are representative of previously built/sample home and may show options not included in the Supreme Spec Package.

ML# :912991   A rare to find Legal 3 Family in Maspeth. Each unit with separate boiler and hot water tank. In excellent condition (completely renovated and well-maintained a few years ago). 1st floor: 1 bedroom, 1 living room, 1 bathroom, and a garage. 2nd floor: 3 bedrooms, 1 living room, 2 bathrooms. 3rd floor: 3 bedrooms, 1 living room, 2 bathrooms. Fully finished new basement with a full bathroom. Located at the junction of Elmhurst and Maspeth, Grand Ave/74th Street (next to the Elmhurst Park). Stop & Shop supermarket and a large new laundry facility are just a couple blocks away. Excellent location, very convenient for transportation and shopping.

ML# :908241   Luxury Waterfront Oasis in Cedar Point ColonyExperience the epitome of waterfront living in this spectacular 5, 500-square-foot custom home, expertly renovated, remodeled, and expanded 2008/2009. Designed for the true water enthusiast, this property boasts over 160 feet of bulkhead and dockage on a wide canal and lagoon, capable of handling any size boat, with electric and water hookups. Interior Highlights:• Step inside to discover a spacious, well-appointed home with polished hardwood flooring throughout.• The amazing country sized custom kitchen and adjoining great room are the heart of the home, featuring a gas fireplace and sliding doors that open to an expansive deck. Powder room off the kitchen• The home offers four generously sized bedrooms, including a private primary suite with gas fireplace and a luxurious soaking tub. The suite also has its own private deck, offering a peaceful retreat with beautiful water views.• A second bedroom includes its own en-suite bathroom.• The first floor is an entertainer’s dream, with an airy den with gas fireplace, an entertainment kitchen with a custom wet bar, a massive workshop, which could also serve as a fifth bedroom or playroom.• Another full bath and a guest area, complete with a pool table, provide ample space for hosting.• For the professional, a large executive office with abundant windows offers a bright and productive workspace. Exterior & Amenities:• Outside, a covered paver patio provides a perfect spot to enjoy the mature, lush landscaping and serene lagoon views.• Additional features include radiant heat, a Buderus hot water boiler, and three-zone air conditioning for ultimate comfort.• Three total fireplaces and vaulted ceilings add to the home’s impressive, luxurious feel. This custom beauty is a must-see for anyone seeking a unique waterfront property in a protected, deep-water canal location, with plenty of room for entertaining and enjoying the serene surroundings. Come see this masterpiece in Cedar Point Colony.

ML# :909250   Solid brick property available for sale-Legal 4 family- Fully sprinklered-Located in fast growing western Astoria section of Queens- Free Market Apartments- Parking garage and outdoor spaces- Separate utilitiesWell maintained income producer - fully leased out!

ML# :903420   Discover this stunningly appointed 5-bedroom, 5.5-bath home nestled on 4.1 acres in beautiful Warwick, New York. This elegant and turnkey residence is perfect for both comfortable living and entertaining guests. Enjoy the luxurious in-ground pool, expansive living areas, and a beautifully serene yard. The lower level features gaming area, a custom bar, and a luxurious bathroom, creating an ideal space for relaxation and entertainment. The primary suite offers ultimate comfort and privacy. Whether hosting gatherings or savoring quiet evenings at home, this property offers the perfect blend of luxury and convenience. If you’re seeking a private retreat or a stylish escape, this incredible home is ready for you!