ML# :827580   Renowned vineyard property, never before on the market! This meticulous 40 acre farm includes 16.3 acres of fully irrigated vinifera grape vines with highly sought out varietals like Cabernet Franc, Pinot Gris, Tocai, Syrah and Sauvignon Blanc. The 15 year old vines are in their prime and this site has long history as a reliable local fruit source for top winemaking producers. Deer fencing, state-of-the-art irrigation well and new generator on site. Property has a conservation (agricultural) easement with NYS; possible tasting room, winemaking facility and/or barns for agricultural use with proper approvals.

ML# :806491   Enjoy luxury living in this gorgeous three-bed, three-and-a-half bath Condo in Scarsdale’s premier building. With over 3000 square feet, this home boasts an open floor plan with high-end finishes. The foyer leads to the custom kitchen, with Thermador appliances and large island, living room with gas fireplace, and dining room. The primary suite features a spa-like bath with free standing tub, huge WICs by California Closets and French doors to the private terrace. A 2nd oversized bedroom includes an en-suite bath. A 3rd bedroom with en-suite bath, powder room and laundry room complete this stunning unit. 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. Photos are of model unit.

ML# :3565786   Perfect for the extended family, this stunning waterfront compound in the Incorporated Village of Asharoken spans 2.78 prime acres and features three individual homes, each offering unobstructed bay views, a sandy beach, and incredible sunsets. Enjoy luxury amenities such as a deep water dock, six-car garages, sheds, and a gunite pool. Embrace the outdoor lifestyle with swimming, boating, fishing, and nature walks, all just minutes from the charming Village of Northport and one hour from NYC via LIRR. This rare offering provides an unparalleled blend of luxury, comfort, and natural beauty., Additional information: Separate Hotwater Heater:y

ML# :H6315134   Discover the epitome of tranquility in this newly renovated mid-century home, a masterpiece thoughtfully designed by a renowned landscape architect. Nestled on nearly 2 acres of breathtaking property, this nature lover’s paradise offers endless opportunities to relish the great outdoors. Surrounded by lush trees, a nature preserve, and a golf course, this home is your private sanctuary. Enjoy the custom stone pool, three serene ponds, and multiple stone terraces, one featuring a hot tub, outdoor TV, and fireplace. Immerse yourself in the natural plantings and meticulously designed gardens. Despite its serene ambiance, this retreat is just a 38-minute express train ride to NYC, offering the perfect blend of seclusion and urban accessibility. The newly renovated interior boasts 4 spacious bedrooms and 3 luxurious spa bathrooms. The primary bath is a sanctuary in itself, featuring a custom shower with natural stone, a sauna, and a fireplace, as well as a large dressing room and closet. Modern floor-to-ceiling windows throughout the home invite in an abundance of natural light and showcase the stunning surroundings. An incredible screened-in living room porch seamlessly blends luxurious comfort with the breathtaking beauty of nature. Come and experience this serene retreat – a perfect harmony of modern luxury and natural splendor. Additional Information: Amenities:Dressing Area, Soaking Tub, Storage,

ML# :3589184   ***OWNER FINANCING AVAILABLE*** An Excellent, Detached, 3-Family Brick Townhouse with Limestone Accents - Fully Renovated, with a Rooftop Terrace, Finished Basement and Backyard ***Owner Financing Available*** Presenting a rare Astoria find with timeless architecture enhanced by modern conveniences. In true MINT condition, it has been completely redefined down to every structural detail. This high-income generating property is a smart investment for investors or live-in homeowners alike! FIRST FLOOR Renovated, 2-bedroom, 1.5 bath unit with modern finishes consisting of an eat-in-kitchen, living room, a master bedroom with bay windows and a second full size bedroom. From the kitchen there is access to the immaculately landscaped, private backyard. With 10 large windows, the unit receives ample natural light throughout. SECOND FLOOR A 2-bedroom unit with an EIK featuring a large peninsula with an overhang to accommodating seating. The dining area has sufficient space for a full dining setting and is followed by the living room. Abundant in natural light, this apartment features 11 windows with custom window treatments. For added convenience the unit has 1.5 bathrooms (with washer/dryer hookup in 1/2 bath). THIRD FLOOR - DUPLEX UNIT This unit is a fantastic haven and one of the best features of this property. The main room is open, airy and bright, consisting of a large living room, full size dining space and a sun-drenched kitchen with a peninsula. Two of the bedrooms are also located on the first floor of the duplex. An open staircase leads to the second tier, a spacious loft style room, complete with a finished roof top terrace with breathtaking views of Astoria and Manhattan’s skyline. This unit has central air conditioning throughout. BASEMENT A fully finished basement, subdivided, to create two separate recreational spaces, both with private entrances. The front room is set up as an office/work studio with kitchenette, polished concrete floors and has high ceilings and several windows allowing for natural light. The rear space features a rec room, bathroom, and access to the backyard. The rear space has a separate entrance with a large rec room, high ceilings, windows and split unit central air.(Accessible from both a private entrance or from within the building). OUTDOORS A beautifully landscaped elevated backyard space that receives sunshine all day long. (accessible from the front of the property as well as the basement and first floor unit). Finished roof top terrace with premier decking (aprox. 330 square feet). COMPLETELY REFINED AND NO DETAIL SPARED- A MINT CONDITION PROPERTY NOT TO BE MISSED! ADDITIONAL HIGHLIGHTS: -Solid oak wood flooring throughout -Intercom system for all units -All sewer lines replaced (2024) -Torched rubber roof (2019) -New rooftop terrace (2019) -New windows in front and rear of house (2023) -New rear retainer wall (2023) -Basement with high ceilings (floor lowered 9 in 2024) -New gas boiler (2024) -New hot water tank (2024) -Each unit with separate electric panel -Washer/Dryer hookups present on each floor -3rd Floor has its own 2 ton central a/c located on the rooftop BONUS ***Owner Financing Available*** LOCATION Situated in the most desirable area of Astoria, this property is in a PRIME location where every convenience is just a short walk away. The vibrant neighborhood is abundant in cafes, restaurants and culinary delights abound. TRANSPORTATION A commuter’s dream with excellent access to Manhattan, the tri-state area or local airports. Easy commuting via subway, several bus routes, car and Citi Bikes. Several major highways and bridges are within a mile. Be in Midtown Manhattan in just 20 minutes or LaGuardia airport in 10! *Building Size 20 ? 55 *Lot Size 25 ? 100 *Zoning R6B *Taxes $13, 775, Additional information: Appearance:Mint, Interior Features:Lr/Dr

ML# :902365   WELCOME TO #8 BRIARFIELD DRIVE - LAKE SUCCESS SPRAWLING COLONIAL HOME - TOTALLY RENOVATED 2004 -ON A QUIET PICTURESQUE LOCATION!Step Into A World Of Elegance & Modern Sophistication With This Stunning Sun-Lit Home, Perfectly Blending Contemporary Design With Natural Beauty.A Grand 2 Story Vaulted Entry Foyer Floods The Home With Natural Light and sets the tone for this elegant residence. The expansive gourmet chef’s eat-in kitchen features vaulted ceilings with 3 skylights, custom cabinetry, breakfast bar, and stainless steel appliances — the perfect space for both casual dining and entertaining — and opens to a warm and inviting den with French doors to the backyard patio. An additional side driveway leads to a private guest suite with full bath. A home office or second bedroom on the main level also offers an en-suite bath for ultimate flexibility.The upper floor boasts a dramatic primary bedroom suite with vaulted ceilings, skylight, walk-in closets, separate sitting room, and a luxurious spa-like bath with steam shower. Two additional bedrooms and a full bath complete this level.The sprawling lower level with outdoor access offers a fantastic recreation room, gym, guest bedroom, and full bath — ideal for extended family or entertaining.Beautiful hardwood floors, crown moldings, and recessed lighting, new roof & new 1st level A/C highlight the quality craftsmanship and attention to detail throughout the home.Enjoy country club living with private police, a magnificent 18-hole private golf course, club room, gym, tennis courts, pickleball courts, and 6-day private sanitation. Lakeville Elementary and Great Neck South Middle/High. Easy access to NYC, LIRR, and Northern Boulevard.

ML# :863232   Income-Producing Property in the Heart of Bayside!Introducing a newly constructed, all-brick building with a solid concrete and steel structure spanning five total stories (four above ground plus a full basement). This exceptional investment opportunity offers a 5.2% cap rate and is ideally situated just two blocks from the LIRR Auburndale station, providing easy access to Manhattan.Property Highlights:Layout:Basement & First Floor Duplex: 2 bedrooms, 2.5 bathroomsSecond Floor: 3 bedrooms, 2 bathroomsThird & Fourth Floor Duplex (Penthouse): 3 bedrooms, 2 bathroomsOutdoor Spaces: Each unit features a spacious balcony; the penthouse includes a private terrace.Parking: Private driveway and a large parking lot in the rear of the building.Construction Features: 12-inch thick walls, enhanced insulation, double-pane windows, fire doors, and a full sprinkler system throughout.Conveniences: Washer and dryer in both the second-floor unit and basement; two entrances (front and rear) to the basement.The first floor is zoned for community facility use, making it ideal for:Medical or dental offices/Psychological or counseling services/Tutoring centers or after-school programs/University or college administrative offices/Senior centers or daycare facilities.This is a rare opportunity to own a versatile, income-generating property in one of Queens’ most desirable neighborhoods.

ML# :897303   Brand new legal two- family detached house in the heart of Flushing. Two above-ground floors plus 7’-11’’ height attic space and a basement with separate entrance. Lot is regular shaped with a detached garage and private driveway for additional parking. Large balcony on the second floor and back. Prime location near super market, school, park and Q17, Q34, Q25 bus station.

ML# :853808   This very well maintained 7-family property in the heart of Corona, offers a prime investment opportunity with a total of approximately 5, 116 sq ft of interior space, situated on a 25’ x 100’ lot in R6B zoning. The building, measuring 25’ x 51.5’, features a desirable layout with each unit offering a spacious living/dining area and kitchen. The first floor consists of a large 3-bedroom, 2-bathroom unit, while the upper three floors each house two 1-bedroom, 1-bathroom apartments—perfect for steady rental income. The property benefits from a 421-A tax abatement and is conveniently located near local shops, restaurants, parks, schools, and the Q38 bus, making it an attractive option for tenants and investors alike.

ML# :820790   GREAT NECK ESTATES Grand and Stately Colonial on a quiet street within The Village of Great Neck Estates. This one-of-a-kind home, sitting on over a third an acre features design and glamour throughout the interior, with high ceilings, incredible flow, immaculate detailing with crown moldings, wainscoting, gold filigree painting, custom hand-painted walls and fireplace mantles, and hardwood floors (where seen) throughout. With 4 bedrooms and 4 and 2 half bathrooms, regal sized living room with wood burning fireplace and 3 sets of French doors to back patio, formal dining room, family room with stone gas fireplace and breakfast nook with 3 sets of French doors to back patio, additional office with side entrance, powder room, mud room, and access to the garage, primary bedroom suite with wood burning fireplace , balcony and walk in closet, a bedroom en suite, and an additional 2 bedrooms, and full bath complete the 2nd floor. Additional features include: a finished lower level, brick back patios, lush landscaping, and stunning views; all within the comfort and privacy of your own space. As a resident of Great Neck Estates you will have access to the Waterfront Park, offering an Olympic-sized swimming pool, kiddie pool, children’s playground, indoor and outdoor tennis courts, baseball and soccer fields, basketball and handball courts, ball field, docks, mooring, community events, summer camp, and more. *CHOICE OF GREAT NECK NORTH OR GREAT NECK SOUTH.