ML# :3561589   Rare opportunity to own a detached and updated legal 3 family investment property on a double lot in Astoria’s desireable Upper Ditmars area. The house features 4 bedrooms, 3 baths, a private 3 car driveway, a sizeable backyard, a large attic, and 3 boilers and 3 hot water heaters. The first floor offers (2) one bedroom apartments with separate entrances along with an eat-in kitchen, living room, and a full bath in each. The second floor offers a very spacious two bedroom apartment with its own separate entrance, a large eat in-kitchen, breakfast area, an oversized living room and dining room fit for entertaining, and a full bath. A truly one of a kind residence. One block from Ditmars Blvd. where Q69 bus is on, direct access to Ditmars Station (N, W trains) and Queensboro Plaza (7, N, W). Close to major shopping and near LaGuardia airport. PS 151 Elementary School, IS 141 Middle School, William Cullen Bryant High School. Great investment opportunity. Financials are available upon request, Additional information: Appearance:Excellent, Separate Hotwater Heater:Yes

ML# :3574213   Welcome to your dream home in the heart of North Fork’s renowned wine country! This stunning new construction, completed in 2024, offers the perfect blend of modern luxury and timeless elegance. Nestled just steps away from the serene waterfront and a mere five-minute drive from the charming downtown of Greenport and its surrounding wineries, this custom-built masterpiece is an unparalleled find. Spanning 4, 122 square feet, this home boasts 5 spacious bedrooms and 4.5 beautifully appointed bathrooms. The moment you step inside, you’ll be captivated by the 22-foot vaulted ceilings that create an open, airy ambiance. The living area is anchored by a cozy gas fireplace, perfect for chilly evenings, while the gourmet kitchen is a chef’s delight. It features pristine quartz countertops, a center island with a dramatic waterfall edge, and top-of-the-line appliances. Entertain in style in the elegant dining room, complete with a bar and wine fridge-ideal for holiday gatherings or intimate dinners. The main floor also includes a convenient laundry room and a mudroom with direct access to the backyard porch. Exquisite details abound, from the glass panel railings and custom wood ceiling beams to the rich 7-inch oak wood plank floors that run throughout the home. The primary suite, located on the first floor, is a true retreat with sliding glass doors that open to the outdoor porch-perfect for unwinding with a glass of local wine as you watch the sunset. The suite also features spacious walk-in closets and a luxurious en-suite bathroom with a large soaking tub for ultimate relaxation. The second floor is equally impressive, offering four additional bedrooms, each with ample closet space, and two full bathrooms. Designed with entertainment in mind, the backyard is a private oasis, complete with an outdoor kitchen and a stunning in-ground pool. This home is a sanctuary where family and guests can gather, relax, and create lasting memories. Don’t miss this rare opportunity to own a piece of paradise in one of Long Island’s most sought-after locations., Additional information: Interior Features:Guest Quarters, Lr/Dr, Separate Hotwater Heater:1

ML# :817170   50’ x 100’ Lot For Sale in Bushwick, Brooklyn. Located in an Opportunity Zone. Suitable for Development. FAR = 2. Additional available for community use. Also ideal for storage of cars, vans, trucks, container storage, or commercial equipment. 2 minute walk from the L train at the Morgan Avenue Subway Station. Minutes from Brooklyn-Queens Expressway, Long Island Expressway, and the Williamsburg Bridge. Also available for rent - $8, 000.00 per month.

ML# :816343   Gorgeous and private haven on two acres with pool and pool house——just 40 minutes from midtown Manhattan! This 6100 sq ft home has been renovated and expanded to offer the perfect lifestyle. Located on level and beautifully landscaped property in a pretty neighborhood, the home is perfect for relaxation or entertaining. It has a large family room with fireplace, a formal dining room overlooking the beautiful yard and a charming living room with fireplace. The chef’s kitchen boasts Sub Zero refrigerator, Viking double range, Fisher & Paykel dishwasher, a wine cooler and a breakfast area with the serene view of the property. There are four large bedrooms and three and one-half baths. The primary suite is a private oasis, with balcony, sitting area, extensive closets and fireplace. The spa-like primary bath has a large soaking tub as well as an ample shower and double vanity. Plenty of bonus space for office and exercise or art studio. Enjoy lounging by your pool with a convenient pool house just steps away. Complete with stone patios, walks and lovely landscaping, this charming estate is the perfect choice!

ML# :815387   Stunning waterfront restaurant for sale, offering breathtaking views and a prime location. This property features a spacious dining area, modern kitchen, and two additional office spaces, perfect for extra income or operational needs. A rare opportunity to own a thriving business with endless potential!

ML# :813477   Unlock the potential of this exceptional warehouse opportunity in the heart of Freeport, Long Island! Sitting on a generous 7, 850 sq. ft. lot. This property boasts a spacious 8, 538 sq. ft. interior, thoughtfully designed to meet the demands of modern manufacturing and business operations. • First Floor: A vast warehouse space with an average ceiling height of 15-26 feet, offering ample vertical storage and operational flexibility. • Second Floor: Fully equipped with office space and a convenient bathroom, ideal for administrative tasks and team collaboration.Strategically located in a thriving industrial hub, this property offers unparalleled convenience for logistics and accessibility, making it an ideal investment for manufacturing businesses or as an income-generating asset.Don’t miss this chance to own a top-tier commercial property in a high-demand area. Schedule your tour today and bring your business vision to life!

ML# :806242   Enjoy luxury living in this spacious two-bed, two-and-a-half bath Condo in Scarsdale’s premier building. This home boasts an open floor plan, high-end finishes, and elegant details. The foyer leads to the custom chef’s kitchen, featuring Thermador appliances and large island, living room, with gas fireplace, and dining area. The primary suite is a sanctuary with a spa-like bath with a soaking tub, and walk-in closets by California Closets. The 2nd bedroom includes an en-suite bath and walk in closet. A powder room and laundry room complete the layout. Additional features include hardwood floors, pre-wiring for in-wall speakers, two assigned indoor parking spaces, and a storage room. The building offers amenities such as a fitness center, EV car charging, and doorman. Located at Five Corners, The Heathcote combines boutique luxury with easy access to Scarsdale’s best shopping and dining. This pet-friendly apartment is a unique opportunity for stylish living. Photos are of model unit.

ML# :808754   Experience the ultimate in privacy and luxury within The Moorings, a prestigious 24/7 gated community. This exceptional property features 200 feet of bulkhead with a boat lift. Step inside to a bright and airy open floor plan filled with natural light and breathtaking views. The home offers 5 spacious bedrooms and 4.5 baths, including a first-floor primary suite. A guest area on the second floor includes a living room, bedroom, and full bath, providing privacy for visitors. The home includes cedar tongue-and-groove siding installed four years ago, along with all-new windows and doors. The roof was replaced 10 years ago, ensuring peace of mind for years to come. Shy of one acre, the beautifully landscaped property includes a Gunite pool, ideal for outdoor entertaining. Residents of The Moorings enjoy exclusive amenities such as a gated guardhouse, tennis courts, and a fire pit. Discover the perfect blend of tranquility, elegance, and recreation in this remarkable waterfront retreat!

ML# :800719   Beautiful and unique custom cedar sided 4, 500 sq ft estate is set on over 5 private acres. This secluded and inspiring property surrounded by magnificent landscaping, mature trees and plantings, charming sitting areas, a meandering stream and a wonderful in-ground swimming pool and spa. The first level features an elegant generous with very high ceiling living area, spacious family room, dining room, and bedroom with full bath and sauna, in addition a spacious open well-appointed eat-in kitchen, a sitting room and office. The second level features two bedrooms both baths ensuite, a large walk-in closet with additional bedroom/sitting room. The lower level has library, gym or media area with walk out patio, full bath, a wood paneled wine cellar, large, closeted storage room and attached a two-car garage. Private and historic Tuxedo Park is a 24/7 gate guarded community within an hour’s drive to mid-town Manhattan. The village offers swimming, boating, biking, fishing and hiking at your doorstep.

ML# :803342   Totally renovated with no expense spared, extension added making the building size 22x55 =1, 210 square feet. 1st floor has 3 bedrooms with 2 full baths with sliding doors out to a private back yard. 2nd floor has 4 bedrooms with 2 bathrooms both units have master suits. Bonus finished basement/walk in with a full bathroom and kitchen. This house is fully electric with ductless units on each floor. Must see to appreciate.