ML# :3536081   Welcome to this beautiful Two Dwelling House in the heart of Woodside located near all forms of transportation, short walking distance to subway trains and buses, shopping markets, restaurants, Schools, parks and much more. One Detached Garage, Additional Parking Space That Can Fit 2 Other Vehicles.

ML# :H6200141   What a gem! Offered for the first time on the market this is the home of the adorned Hartells Deli & Liquor Stores. Buildings sits on one of the few commercial corners in Upper Nyack. Steps away from the Hudson and walking distance to both downtown Nyack and Nyack Beach State Park. Building features 2 commercial spaces and 3 apartments. Building is well maintained and all apartments have been updated by original owners. Terrific investment property or owner occupied! Hurry this is a rare opportunity that will not last!

ML# :3569448   The Rose at Great Neck. Now finished, this brand new construction building consists of 40-New Luxury Condominiums on the North Shore of Long Island, located in the Village of Great Neck Estates. This new condo is the largest two bedroom and two bath unit in the building, it is located on the second floor, approximately 1, 403 sqft, includes private laundry in the condo, an open floor plan and large windows bringing in natural light. The brand new mid-rise building offers many amenities including 24hr virtual doorman services, a welcome lobby, business lounge with tv plus a gym fitness center. Retreat to the rooftop common area and hang out at the perfect place to unwind with seating and enjoy the outdoors that include distant views towards New York City. Very special full on golf simulator coming soon to the building. Private indoor garage parking and outside private lot parking. The earliest residents have preferred choice of parking spaces and limited storage options available. The allure of The Rose extends beyond its walls as residents enjoy instant access to the Village of Great Neck Estates Waterfront Park featuring Olympic sized swimming pool plus small pool, 7 tennis courts plus indoor tennis court in a Winter bubble, marina and dock area, direct waterfront esplanade with views of Little Neck Bay, Douglas Manor and the Throgs Neck Bridge, shoreline access, baseball and soccer fields, playground, basketball, pickle ball and handball courts. The Rose was creatively designed by Mojo Stumer architects with the very best of quality and modern sophistication. Exterior brick and metal panels accent the solid structure. Three floors high with a mix of 1 bedroom, 2 bedroom and 3 bedroom options in this new building. Sleek modern kitchens to spacious living areas and stunning bathrooms, every aspect of this building reflects a commitment to luxury and comfort. Various golf courses within close proximity and nearby to the famous Americana Manhasset shopping. Just 0.7 miles to the Great Neck LIRR train station that boasts a direct route to Penn Station and now Grand Central Station in Manhattan. Enjoy the suburban lifestyle at the pinnacle of luxury living in Great Neck with all its town amenities just 19 miles to midtown Manhattan and a short jaunt to international airports. Great Neck North School District with an option for Great Neck South High School in some instances and The Rose is zoned for Saddle Rock Elementary. Welcome home., Additional information: Appearance:Brand New, Interior Features:Guest Quarters

ML# :3554326   Great 1 Family house in the Douglaston, Little Neck Area. This property sits on a 5750 Square foot beautiful corner lot. The house features 6 bedrooms, 4.5 Bathrooms. The 1st floor consists of as open concept GREAT ROOM that consists of a large eat-in-kitchen with stainless steel appliances, cherry wood cabinets, granite counters featuring a sit down bar height granter counter island, dining area, and a sitting/ lounge area, the GREAT ROOM has large porcelain floor tiles. Also on the 1st floor is another living room (den) with dark hardwood floors and wood burning fire place, full bath, and a bedroom (office). The 2nd floor features 3 bedrooms, hallway bath, and a master suite with a master bath, 2 balconies a front facing and side yard overlooking the pool. There is a 3rd floor walk up that has another multi purpose room and half bath. The large basement has 7 foot ceilings, consisting of a large living area, full bath, laundry area, mechanical room, has a walk out entrance into the yard. The yard is an entertainers delight with and in ground swimming pool ( 8 feet deep), patio area. There are 2 private driveways and 1 car garage. Located in Queens school district #26. Conveniently located near all major highways, public transportation, shopping, and dining. This house is a must see.

ML# :803916   Welcome to this stunning and modern 2-family home, designed for comfort and style! • First Floor: Features 3 spacious bedrooms, including a master bedroom, 2 modern bathrooms, laundry room, and an open-concept kitchen with a dining and living space perfect for gatherings. • Second Unit: Offers 4 additional bedrooms, 2 bathrooms, laundry room and a thoughtfully designed kitchen with living and dining areas to suit your lifestyle. • Finished Basement: Perfect for extra living space or recreation. • Private Driveway: Ensures convenience and ample parking.This home is a must see! Discover your dream home today schedule a showing!

ML# :3584360   Pelham Gardens legal detached brick 3 family home on a 50x100 lot, Additional information: Appearance:very Good

ML# :3582291   Welcome to this rare, turnkey 3-bedroom, 2.5-bath gem located in the heart of Astoria, Queens, just a short walk away from the vibrant Ditmars Blvd. This stunning property has been meticulously gut-renovated from top to bottom, blending modern luxury with timeless charm to create a truly exceptional living experience. Every detail of this home has been carefully considered, offering a move-in-ready opportunity that combines beauty and functionality in one of the most sought-after neighborhoods in Queens. As you step inside, you’re greeted by a spacious, open-concept living and dining area filled with natural light, thanks to the new Anderson windows throughout the home. The interior design strikes the perfect balance between modern elegance and warmth, with wide plank wood floors and recessed lighting that create a sleek, inviting ambiance. The flow from room to room is effortless, making this home ideal for both everyday living and entertaining guests. At the heart of the home is the chef’s kitchen, a culinary enthusiast’s dream. Equipped with top-of-the-line stainless steel appliances, custom cabinetry, and a generously sized island, this kitchen offers both style and practicality. The marble-like quartz countertops and backsplash add a touch of sophistication, while the open layout allows easy access to the adjacent dining area. Sliding glass doors lead directly from the kitchen to a private outdoor patio, making it perfect for summer barbecues or enjoying your morning coffee while basking in the fresh air. The backyard is fully fenced, offering a serene, private space with ample room for gardening, recreation, or simply unwinding. Additionally there is multiple car parking with a 1 car garage and driveway parking. Convenience is key in this home, with a stylish half bathroom located on the first floor for guests and everyday use. Upstairs, the second level features three well-appointed bedrooms, each with ample closet space and filled with abundant natural light. The master bedroom serves as a peaceful retreat, while the additional bedrooms are perfect for children, guests, or a home office. The spa-inspired bathrooms boast elegant finishes, such as gold fixtures, marble tile, and modern vanities, providing a luxurious experience in your own home. The fully finished basement expands the living space, offering endless possibilities for customization. Whether you’re looking for a home gym, media room, or additional living space, this versatile area can accommodate your needs. No detail has been overlooked in this gut-renovation, which includes updated roof, plumbing, and electrical systems, ensuring that the home is as durable and efficient as it is beautiful. New mechanicals throughout provide the ultimate in comfort and reliability, allowing you to move in with complete peace of mind. This is a truly rare opportunity to own a meticulously renovated home in one of Queens’ most desirable neighborhoods. Schedule your private tour today to experience this exceptional home for yourself!

ML# :3555654   You’ve stumbled upon quite the treasure! A townhouse with high ceilings and heated floors definitely adds a touch of luxury and comfort. And having a custom kitchen is every chef’s dream. The spacious second floor with a master bath and deck offer some amazing views and relaxation spots. And let’s not forget about the basement - a fully finished, extra-long space with a street-level walkout is perfect for entertaining or creating your own private retreat. A fantastic find! Being steps away from Queens Blvd means easy access to transportation, shopping, dining, and entertainment options. Having malls nearby is convenient for everyday needs, and being close to schools is great for families or anyone looking to be part of a vibrant community. With express buses and trains within walking distance, commuting to work or exploring the city becomes a breeze. This townhouse offers not only luxurious living but also the convenience of a prime location., Additional information: Appearance:Excellent

ML# :814482   Woodside prime location community facility office for sale. Nearby public transportation with great potential for medical use.

ML# :3592584   Penthouse 2-bedroom, 2-bathroom residence with a home office, offering 948 sf of living space with 842 sf Private terrace. The unit features warm wood tones, 8 Engineered oak wood flooring, sleek stone finishes, Smart-lock keyless entry, and 10’5 high ceilings, creating an inviting and sophisticated atmosphere. The modern kitchen is equipped with built-in Bosch appliances-a 5-burner gas cooktop, refrigerator, oven, and dishwasher-complemented by Waterfall Marble countertops. A Bosch stacked washer and dryer is also in the Unit. The luxurious 4 piece bathroom (with shower and tub) showcases high-end fixtures, smart toilets, heating floor, and custom LED vanity mirrors. Located in a boutique building with just 52 residences, Oasis offers a range of premium amenities, including a rooftop terrace with panoramic views, a state-of-the-art Manhattan view gym, and secure bicycle storage. The building also boasts super low common charges. The location is ideal, with Citi Bike stations nearby and the Q69 bus stop right next to the building, offering direct routes to 21st Queensbridge and Queensboro Plaza. Nestled between vibrant Astoria and the peaceful riverfront, Oasis provides easy access to parks, museums, and other cultural attractions, as well as convenient public transportation options. The complete terms are in an offering plan available from the Sponsor (File No: CP23-0050.), Additional information: Appearance:Brand New