ML# :899802   Dream Waterfront Living – 3 Bed, 2 Bath with Expansive Views & Endless PotentialWelcome to this rare waterfront gem nestled on just shy of a half-acre, offering stunning panoramic water views and a lifestyle of peace and possibility. This 3-bedroom, 2-bathroom home features a full basement—perfectly designed for entertaining, hobbies, or future expansion.Enjoy the convenience of a spacious 2-car garage and the beauty of park-like landscaping that frames the property with lush greenery and privacy. Step out back to your private bulkhead and dock—ideal for boating, fishing, or simply soaking in the views.Whether you’re looking to settle into a move-in ready retreat or dreaming of expanding and customizing your forever home, this property offers the perfect location and foundation to bring your vision to life.Don’t miss this opportunity to own a piece of paradise with endless potential!

ML# :862131   Introducing Eastone Plaza, Flushing’s newest luxury condominium. Ideally located in a prime, central neighborhood, Eastone Plaza offers unmatched convenience with easy access to shopping, dining, top-rated schools, parks, and public transportation. Completed in 2025 to the highest standards, this striking mid-rise development features 175 contemporary residences, thoughtfully designed to suit modern lifestyles, with layouts ranging from studios to spacious three-bedroom homes. Each residence is outfitted with premium finishes, including engineered wood flooring, floor-to-ceiling double-glazed soundproof windows, multi-zone heating and cooling, and a Latch keyless entry system with intercom. The kitchens showcase a full suite of BOSCH appliances—including an in-unit washer and dryer, dishwasher, and 3-speed range hood—alongside custom cabinetry, quartz countertops and backsplash, and Grohe fixtures. Bathrooms are elegantly appointed with LED-lit medicine cabinets, premium Grohe fixtures, TOTO smart toilets, walk-in showers, and bathtubs in select units. Many homes also feature private balconies or terraces. Residents enjoy a robust array of amenities, including a fully equipped fitness center, a stylish lounge with a coffee station, an indoor children’s playroom, a beautifully landscaped second-floor terrace with BBQ grills and ample seating, and a private outdoor dog run. Additional conveniences include a full-service concierge available seven days a week, three high-speed elevators, a dedicated package room with Amazon Hub, and an intercom system in every unit. The building also offers 154 parking spaces, as well as private storage and bicycle storage, all available for sale. Now is the perfect time to make Eastone Plaza your new home. Discover the unmatched comfort, style, and convenience of Flushing’s premier new condominium.

ML# :919317   Beautiful brick and stone split-level home in the heart of Oakland Gardens. The main level features a spacious living room, formal dining room, and a well-appointed kitchen. The lower level offers a cozy family room with marble fireplace, a versatile Florida room/office, and a finished basement with bar and summer kitchen. Upstairs includes a comfortable primary en-suite plus two additional bedrooms.Outdoor highlights include a wide covered front porch with classic balustrades, a double-car garage, and a private backyard with a custom marble patio and landscaped garden. Conveniently located near Oakland Lake, top-rated schools, shopping, and major transportation. A rare opportunity to own a home that combines warmth, function, and timeless character.

ML# :920422   Location! Location! Location! Business for Sale: A renowned, uniquely designed 5-star restaurant in the heart of Chelsea, Manhattan on 7th Avenue. Fully renovated just 2 years ago with stunning modern interiors, this property offers 3, 816 sq.ft. on the 1st and 2nd floors, plus a 1, 781 sq.ft. basement with elevator access, walk-in cooler/freezer, and full equipment. Features include front window service, a full commercial kitchen, bar area, and a beautifully designed dining space with 98 seats. The restaurant comes with a 20-year lease (18 years remaining) at rent and property tax far below market value, offering an ROI in just 1 year and 7 months. Prime visibility with wide glass frontage near Penn Station and multiple subway lines makes this an exceptional investment opportunity.

ML# :914542   Welcome to this stunning two-family home located in a serene waterfront private gated community, in the Country Club section of Bronx. This beautiful home, consisting of two units, is overlooking the Long Island Sound. The first unit features 4 bedrooms, 2.5 bathrooms, bright and spacious living room, galley kitchen, and formal dining area and a large deck to enjoy the tranquil water view. You can also enjoy your private, fenced backyard. The second unit features 2 bedrooms, 1 full bathroom, kitchen, and living room/dining area. This unit has cathedral/vaulted ceilings and oversized windows! This property has a walk-in basement, one-car garage, two driveway parking spots, and docking rights to accommodate two 24’ boats! Walking distance to Pelham Bay Park and close to all public transportation, including the Soundview Ferry.

ML# :911428   Detached large single dwelling home located in the heart of North Flushing! The total living area is 2, 247 square feet, with three stories above ground. There is a fully finished basement with a separate entrance, offering maximum living space with a flexible layout. The house was completely remodeled three years ago and features a beautiful backyard garden, a large paved deck, and is comfortable and clean! It has central cooling and split AC units. Conveniently located near the Long Island Rail Road and Northern Boulevard.

ML# :912330   One of Only 2 Top-Floor Homes Remaining – A Rare Waterfront Opportunity. Experience the epitome of luxury living at Unit 3C, a premier townhome-style condo at The Aristo, Astoria’s most coveted waterfront residence. Designed for both entertaining and relaxation, the expansive living space is enhanced by floor-to-ceiling sliding glass doors that seamlessly connect to your private balcony, where sweeping water and city views create a breathtaking backdrop.The chef’s kitchen is a true showpiece, featuring marble countertops and backsplash, custom cabinetry, and premium appliances including a Bertazzoni stove, Liebherr refrigerator, and dishwasher. Whether preparing a gourmet meal or hosting guests, this elegant space elevates every occasion.The serene primary bedroom offers a spacious closet, a spa-like en-suite bath with Porcelanosa tiles, and access to a private balcony for quiet mornings or evening relaxation. A generous second bedroom with ample closet space provides versatility for guests, a home office, or personal retreat.For the ultimate outdoor escape, ascend to your private 518 SF roof deck, a true urban sanctuary with panoramic city and waterfront views—perfect for sunset entertaining or peaceful solitude.Additional highlights include oak wood flooring, 8-foot doors, built-in Vessel Bluetooth speakers, Ring doorbell camera, Brinks security wiring, and washer/dryer hookup. Every detail balances modern convenience with timeless luxury.With on-site parking available (prewired for EV charging) and a beautifully designed common area, The Aristo combines sophistication with community. Its prime location provides effortless access to the N/W subway, while Astoria Park—with its expansive green spaces, pool, tennis courts, and waterfront trails—becomes your backyard retreat.The complete offering terms are in an offering plan available from sponsor. File No.CD24-0044. All measurements and dimensions are approximate and are subject to normal construction variances and tolerances and may vary from floor to floor. Sponsor reserves the right to make changes in accordance with the terms of the offering plan. All images are artist’s renderings for representational purposes only and are subject to variances. Though information is believed to be correct, it is presented subject to error, omissions, changes and withdrawal without notice. Equal Housing Opportunity.

ML# :911602   Perched above Kingston yet just steps from the city’s vibrant heart, this Art Deco–inspired residence is a rare fusion of glamour and nature. Set on 8.5 private acres with sweeping mountain vistas and a tranquil pond, the home feels worlds away while remaining walkable to uptown Kingston. Recently reimagined and meticulously renovated, it rises three levels with a striking mix of architectural drama and modern comfort—perfect for those seeking a one-of-a-kind escape without sacrificing convenience.Inside, the surprises are endless. A soaring two-sided stone fireplace anchors the main living space, where elegant dark hardwood floors meet walls of glass that open onto a broad deck with dramatic mountain views. The chef’s kitchen is as functional as it is stylish, outfitted with state-of-the-art stainless steel appliances, a breakfast bar, and an adjacent vaulted dining room framed by Venetian windows. Two deluxe bedroom suites—each with spa-like ensuite baths—offer private retreats, while flexible bonus rooms can transform into a home office, creative studio, or playroom.The property itself is no less impressive. Mature trees frame wide-open lawns and mountain views, creating an atmosphere of serenity and grandeur. From your deck you’ll hear the breeze, spot the pond glimmering in the distance, and still know that Kingston’s Rondout waterfront, Midtown arts scene, and the historic Stockade District are minutes away. With Woodstock, New Paltz, Rhinebeck, Mohonk, and the Catskills all within half an hour, this home is more than a residence—it’s a gateway to the best of the Hudson Valley.

ML# :909086   Enjoy city living in this spacious triplex penthouse in the heart of Harlem. With 1, 555 square feet, this two-bedroom, two-bathroom home offers comfortable living across three floors and a large private roof deck perfect for relaxing and entertaining.The top level of the home offers a tranquil private roof deck with sweeping views all the way to Billionaire’s Row. Spend your days relaxing under the large sun shade and your evenings dining al fresco with the convenience of a Wi-Fi-controlled grill and smoker. Completing this level is a room with soaring ceilings and custom shelving, which is ideal for guests, a second home office, or a media room.On the main level, an open-concept great room is bathed in natural light through a wall of oversized tilt-and-turn windows, offering wide-plank oak floors and three custom-outfitted closets. The European-inspired kitchen is a chef’s dream outfitted with a Bosch five-burner dual-fuel range and an XO hood, a Blomberg built-in refrigerator, a Blomberg dishwasher, and an LG microwave below the counter. There is ample room for a formal dining for up to 12, a large living area, and a full bathroom with floating cabinetry, three mirrored vanity cabinets, and a tub with a shower.The lower level of the home features its own entrance, accessible via the elevator, and includes two bedrooms, each with two oversized tilt-and-turn windows and closets that offer custom storage. The second spa-like bathroom is located on this level and is adorned with herringbone finished marble tile floors, separate glass enclosures for the private shower and private water closet, and a deep Duravit soaking tub. This level is complete with a foyer large enough for a separate home office or mud room and private, in-unit laundry.2457 Frederick Douglass Blvd. is a boutique, pet-friendly condominium conveniently located near Morningside and St. Nicholas Parks and shopping at Trader Joe’s, Whole Foods, and 125th Street’s retailers. The A/B/C/D subway at 125th Street and multiple bus lines make commuting easy.

ML# :905599   Great Neck South School Low Tax