ML# :3561302   Welcome to this exquisite Sprawling Farm Ranch located on the prestigious Duck Pond Road off of Piping Rock Road. Nestled on a spacious .68-acre lot, this expansive home boasts beautifully landscaped grounds with mature plantings and specimen trees that offer a tranquil and private setting. With over 5000 square feet of living space, this home features oak wood floors throughout. The expansive great room welcomes you with an open layout combining the living room and dining room, complete with a coffered ceiling and a gas-burning fireplace. The gourmet eat-in kitchen is a chef’s dream, showcasing a center island, granite countertops, double ovens, six burner Wolf gas range stovetop, two dishwashers, and a subzero refrigerator. The kitchen opens to a large den with a gas fireplace and glass doors leading to a blue stone patio and outdoor dining area. The outdoor dining area features a wood-burning fireplace and two levels of seating areas, perfect for entertaining guests. The first floor also includes a primary bedroom with a spacious walk-in closet, a dressing area, and an ensuite bathroom. Additionally, there is a second bedroom/home office with its own full bath on the same floor. On the second floor, you will find another primary suite with an ensuite bath and walk-in closet, as well as another bedroom with a large walk-in closet and a full bath with a washer and dryer. A separate guest bedroom, located off the kitchen via a separate staircase on the second floor, offers its own private ensuite full bath. Completing this remarkable property are two separate garages that can accommodate four cars, with additional entry to spaces on the basement level. This home is truly a luxurious retreat offering unparalleled comfort, convenience, and style. Full house Automatic Generator installed 2016. Ring camera at front door. This extraordinary Sprawling Farm Ranch offers a unique opportunity for families seeking a home with separate living areas, ideal for accommodating multiple generations comfortably under one roof. Several of the rooms are virtually staged with furniture as well as the pool in the backyard. See photos.

ML# :3553109   Excellent 2, 808sqft 2-family house located at the heart of Jamaica featuring 10 Bedrooms, 3 Full Bathrooms, a fully finished Basement and a Private Driveway. Selling As is. Will be delivered vacant. R7A Zoning. FAR 4 for facility. Total 16, 000 buildable sqft, confirm with your Architect. Close to Subway, Buses, Schools, Banks, groceries, supermarkets, shopping, restaurants, and all other community amenities., Additional information: Appearance:Excellent

ML# :3550178   Astonishing Water-Front Colonial With Boat Dock!! 137 ft of Level Shoreline W/Full View of Conscience Bay- A Weather- protected and Safe Haven for Kayaking, Inner Tubing, Water Skiing, and Wakeboarding. Fixed Pier W/Open Grate Composite Decking & Seasonal Aluminum Ramp to Floating Dock. Less Than 10 Min Cruise to LI Sound. In this Home You’ll Feel Like Royalty. Beautiful Hardwood Flooring, Large Living Room W/Cozy Fireplace and Enchanting Views Through Large Picture Window. Gorgeous Great Room W/Updated Kitchen, Breakfast Nook & Den area W/Gas Fireplace - Overlooks Backyard sanctuary With Sliders to Genuine Slate Patio. Gorgeous Updated Gunite IG Pool & Hot Tub, Privacy Landscaping... All Great for Entertaining or Tranquil Relaxation. Minutes from Old Field Lighthouse, Old Field Beach, and Frank Melville Park & Grist Mill. Enjoy All the Exceptional Dining, Shopping, and Entertainment Three Village Offers., Additional information: Appearance:Mint+++

ML# :3538531   Nestled in Oyster Bay Cove, this beautiful farm ranch sits on 2 acres of land with highly sought-after amenities. This property offers a luxury living experience with over 6, 000 sq. ft. of livable space. 5 bedrooms and 6 Baths. Custom high ceilings throughout the house. From the moment you step inside, you are astonished by the immaculate craftsmanship and modern elegance. Every detail has been flawlessly thought out with the highest quality finishes and amenities that create an unparalleled living experience. The mudroom starts with radiant heated floors. The kitchen features premium new appliances from 2023, a quartz countertop installed in 2023, radiant heated floors, beautiful cabinetry, a gas stove, and a large center island that is open to the spacious family and breakfast room, making it perfect for entertaining and family gatherings. The primary suite features a luxurious radiant heated floor bath with his/her walk-in closets. The lower level is the ideal space for recreational activities. The backyard is an oasis, featuring a heated saltwater swimming pool with a motorized cover, an attached spa, an outdoor kitchen, and fully automated porch screens. Double-car garage doors were installed 2 years ago. Brand new automated skylight shades were installed in Feb 2024. The central speaker system is available on the 1st level. 10-year-old Hardie plank siding. A 5, 000-watt portable gasoline-fed generator is included in the sale. Anderson windows and doors. All bedrooms are wired for intercom. 2nd level recently had a major remodel August of 2024 with brand-new flooring and a fresh paint job. Every amenity is at your fingertips! MUST SEE!, Additional information: Appearance:Excellent, Interior Features:Lr/Dr

ML# :H6272387   Welcome to this exceptional 40-acre equestrian farm, a sanctuary that seamlessly blends luxury with the practicality of a well-designed space. Stepping inside the main house reveals a warm and inviting ambiance. The five spacious bedrooms are elegantly designed, providing ample space for both residents and guests to unwind and enjoy. The main barn, a potential subdivision, boasts 23 meticulously designed stalls within its spacious interior. In addition to providing excellent accommodations for the horses, this barn also features a kitchen, as well as two heated tack rooms, ensuring easy access and organization of riding gear. The main barn also includes a heated viewing room overlooking the indoor arena and a dedicated washing room for the horses. Along the farm, you’ll also find a man-made pond, elevating the farm’s stunning, country-like setting. Also located on the property is a smaller barn with 7 stables and a hay loft, offering additional storage for hay and feed. The farm further presents a spacious riding arena and multiple outdoor riding rings. This equestrian farm estate stands as a testament to pure beauty and serenity embraced by nature, potentially offering the opportunity for a delightful subdivision with picturesque views.

ML# :804171   A great opportunity for an end user or investor! Perfect home for you to design and renovate just the way your lifestyle or family needs. Home is under eviction and is an as is sale. Buyers Must Verify All Information.

ML# :3590466   6 Family Building for Sale in PRIME Astoria/LIC Location! Superbly maintained building offering investors an income generating opportunity without upfront renovation costs. Located in the heart of Astoria, just off the ever-popular Broadway and steps to the train, this multi-family building sees continuous tenant demand! SET-UP ***First floor: (2) 1 Bedroom Apartments ***Second floor: (1) 1-Bedroom Apartment (1) 2-Bedroom Apartment ***Third floor: (1) 1-Bedroom Apartment (1) 2-Bedroom Apartment ***Basement: Full, unfinished ***Semi-Detached, Brick - Beds: 8 Baths: 6 Rooms: 20 Sqft: 2, 067 ***Annual Income: $131, 064 ***Annual Expenses: $38, 579 ***Net Operating Income: $ $92, 485 ***Lot Size: 20.67x100 ***Bldg Size: 20.75x85 ***Taxes: $21329 ***Zoning: R5 TRANSPORTATION & LOCATION: Conveniently located just a 5-minute walk from the N/W subway station, providing quick access to Manhattan in under 20 minutes. With Citibike stations and multiple bus lines nearby, residents enjoy numerous transportation options. This prime Astoria spot is surrounded by popular dining, shopping, and entertainment options and is a high demand area for renters. ***TURN-KEY INCOME*** Ready for immediate income generation with easy to rent units. All units in great condition with some recent updates meeting modern tenant requirements. *HIGH RENTAL DEMAND* Astoria is known for its booming rental market and sees consistent tenant demand driven by all of the conveniences, cultural appeal and convenient transit/proximity to Manhattan., Additional information: Appearance:Excellent, Building Size:20.75x84, Separate Hotwater Heater:y

ML# :3584361   Amazing All Brick Construction-Built In 2012 Super Mint Large Solid All Brick Two Family In The Heart Of Little Neck. Oversize 25x52 Building Size & 40x100 Property ! 3 Br 2 Full Baths Over 3 Br And 2 Baths With Finished Basement W/Sept Entrance. Detached 1 Car Garage. Top School Dist #26, Ps 221 and Ms 67, Close to Bus And Supermarket. Eastern Exposure Sunny House !!, Additional information: Appearance:Excellent, Separate Hotwater Heater:Yes

ML# :3579316   Nestled in the prestigious village of Plandome Manor in Manhasset, this exquisite home offers over 3, 300-square-foot of living space with a perfect blend of luxury and convenience. The grand entrance opens to an expansive den with a stunning vaulted cathedral ceiling, creating an immediate sense of elegance and openness. Set on nearly half an acre of land, the home features beautiful updates including refined oak wood floors and a renovated kitchen with granite countertops, ideal for hosting gatherings. Two fireplaces add warmth and charm, while recent updates such as a brand-new in-ground cesspool, a replaced roof, and a finished basement ensure a move-in-ready experience. The large deck overlooks a spacious backyard, offering endless possibilities for outdoor living and entertainment. This property enjoys unparalleled access to local amenities and the picturesque waterfront of Manhasset Bay, and is just minutes from shopping, dining, and public transportation with access to parking, ensuring the ultimate blend of convenience and luxury. This home is designed to meet the needs of the most discerning buyer.

ML# :810499   Luxury and elegance define this center hall colonial in Hollis Park Gardens, fully renovated just about 7 years ago, offering 7 bedrooms, 3.5 bathrooms, and a wealth of high-end details, this home boasts a grand entry foyer with marble floors, a spacious living room with a fireplace, a formal dining room, and a modern eat-in kitchen with granite countertops, marble floors, and stainless steel appliances. Brazilian cherry wood floors and stairs, crown molding throughout. A large master suite with a private bathroom elevates the living experience. The common bathroom includes both a whirlpool tub and a shower. A fully finished basement with an outside entrance offers three, rooms, a bathroom, utility rooms, and a laundry area. Enjoy the comfort of central heating and air conditioning, a central vacuum system, skylights, a 75 x 100 lot with a private driveway, a 2-car garage, and a back deck with an awning. Conveniently located near public transportation and all other community amenities.