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.
138 Duck Pond Rd, Glen Cove, NY, 11542
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
175-46 88th Avenue, Jamaica, NY, 11432
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+++
149 Old Field Rd, Setauket, NY, 11733
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
23 Yellow Cote Rd, Oyster Bay Cove, NY, 11771
ML# :3526883 over 8% Cap rate great investment 3 story Corner Mix-use with 2 Commercial Retail unit & 2 (4brm) vacant apartments. Apartments updated with hardwood floor throughout, and each apartment has 4brm, 2 bath. 1st store Deli paying 3500@3% increase and lease expiring in2033 2nd store Pharmacy paying 3100 @3% increase and lease till 2029 Apartments no lease. can be delivered vacant. now paying 4000/mo. each Total gross rent is 175, 200/year Expenses are 17, 382/year Net Income 157, 818/year, Additional information: Rental Income:Y
713 Decatur Street, Brooklyn, NY, 11233
ML# :3523392 Elevate your business at Alliance Tower, a newly constructed eight-story, Class A office building located in the vibrant heart of Flushing with a 15-year ICAP tax abatement. This 1738 sqft unit (net 1449 sqft) is suitable for a wide range of professionals, including medical practitioners, nonprofit organizations, educational institutions, and community facilities. This building is at an ideal location, just minutes away from the 7 train, making commuting easy. The building stands out with its elegant lobby, elevators accessible on all floors, high ceilings creating a spacious and breezy environment, and expansive windows that fill workspaces with natural light. Prioritizing your comfort and convenience, each unit is equipped with HVAC systems and private ADA-compliant bathrooms, ensuring a premium experience for clients, visitors, and employees alike. Alliance Tower is the perfect choice for businesses seeking an elevated workspace experience.
133-20 41st Rd Unit 7A, Flushing, NY, 11355
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.
39 Foley Rd, Warwick, NY, 10990
ML# :3491320 Excellent investment property for sale on Northern Blvd which is one of the most busy Blvd in Queens, high foot and car traffic . This mixed use building is made of an excellent first floor store with a full finished basement , second floor has a 3 Bedroom apartment , living room , kitchen and a 2 full bathrooms , third floor has another 3 Bedroom apartment with living room, kitchen and 2 full bathrooms. Very good CAP Rate , busy commercial area on Northern Blvd and 108th Street , close major highway ., Additional information: vac_perc:30, Building Size:20x56
107-13 Northern Boulevard, Corona, NY, 11368
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.
1298 Halsey Street, Brooklyn, NY, 11237
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
34-35 30th Street, Astoria, NY, 11106