ML# :908378   This modern 6-family building in the heart of Flushing is an excellent investment opportunity. Built in 2013, it includes 4 units with 2 bedrooms and 2 bathrooms, and 2 units with 2 bedrooms and 1 bathroom. The property generates great rental income and benefits from a tax abatement until 2032, with annual taxes of just $2, 239/year. Located within walking distance of Main Street and the 7 train, it offers easy access to schools, shops, restaurants, and more. With its prime location, low taxes, and high returns, this property is perfect for investors or homeowners.

ML# :874045   Prime Professional Office at Queens Crossing – Flushing’s Premier Commercial HubNow available: a beautifully renovated office in the iconic Queens Crossing building, right on the corner of Main Street in the heart of Downtown Flushing. Featuring a Retail Certificate of Occupancy, soaring 13-foot ceilings, and floor-to-ceiling windows throughout, this bright, modern space is flooded with natural light — perfect for creating a standout professional environment.Equipped with central AC and designed to suit a wide range of professional uses — from medical and legal to consulting and creative offices — this is a rare opportunity to secure a high-exposure space in one of Queens’ most high-traffic locations.Just one block from the 7 Train and LIRR, with nonstop traffic and surrounded by vibrant new developments, retail, and dining — this is where your business needs to be.

ML# :826438   Spectacular Waterfront Luxury Estate in Lido BeachNestled in one of Lido Beach’s most prestigious enclaves, this extraordinary Bayfront estate redefines coastal luxury. Situated on an exclusive cul-de-sac block, this stunning waterfront masterpiece offers breathtaking panoramic views, deep water access, and unparalleled elegance.Designed for the ultimate in waterfront living, this home features a private deep-water dock with a boat lift and jet ski lift, a new bulkhead, and an in-ground heated saltwater pool, creating a true summer oasis. The outdoor chef’s kitchen is an entertainer’s dream, perfect for alfresco dining while enjoying the serene bay views.Inside, soaring cathedral ceilings, an open floor plan, and designer finishes elevate every space. Rich wood floors flow seamlessly throughout, enhancing the home’s warmth and sophistication. The primary suite is a private retreat with breathtaking water views, while the fully finished basement provides additional living and entertaining space.With a 2-car garage, additional 2-car driveway, and unmatched craftsmanship throughout, this residence is truly one of Lido Beach’s finest. A rare opportunity to own a waterfront sanctuary in an elite location—experience luxury at its finest!Very low Taxes!!

ML# :884121   As does Frank Lloyd Wright’s “Fallingwater, this hilltop enclave provides privacy, luxury and customized details. Nestled high atop Philipse Manor in Westchester County, this home has majestic Hudson River views. The architecture, harmonized within the natural environment, creates a unique flow of indoor and outdoor experiences with 38-minute access to Grand Central Terminal. Completely gut-renovated in 2019 and was built to the specifications of the owners whose attention to all structural, mechanical, electrical, utility, material and finishing quality made this quintessential, energy-efficient home a reality.The first level is a sun-filled, central gathering place. Upon entry, the two-story windowed living room and dramatic fireplace remind you of an Architectural Digest cover. This room opens to a massive lounging deck, perched two stories above the quiet dead-end street below, with views of the river. Flanking the living room is a separate, sunken, family room with full, luxury bath. This room can serve as in-law suite, or for younger families, an au pair or playroom. Its view of the side yard includes a beautiful garden shed, which may be repurposed as a pool house for a future pool or hot tub. Across the living room, the formal dining room opens to a cliffside patio and firepit. Adjacent is the Chef’s kitchen anchored by a colossal marble island. The modern, luxury cooking area conjures images of Thanksgiving with dozens of family and friends passing through to taste or participate in meal prep. The layout and amenities are a cook’s dream, with a breakfast nook view of the manicured private front garden. Off the kitchen, there is a second, custom outdoor kitchen for entertaining. For families crossing multiple generations, one can host the younger crowd outdoors, while older guests can enjoy the cool indoors, yet the walls of windows and entries maintain a feeling of togetherness. This expansive patio can fit several dining tables and adult games, such as ping-pong. Access to the garage is off the kitchen via a large mudroom. It has its own exterior entrance where wet or sandy family and guests can kick off their gear after a day at the private Philipse Manor Beach Club (3-minute walk) and even the dog can take a bath in the contained shower tub. Outside there is parking for 4 SUVs. There are 7 doors, providing seamless access to each distinct area of the private grounds. The second, sunny floating mezzanine level, opens to the primary suite, spa-like bathroom, 2 walk-in closets (WICs) and river-facing sleeping area. Juliet balcony and glass doors fold back, simulating a treehouse. Adjacent, are two large BRs, with WICs and shared bathroom. Across the hall, a secluded BR with WIC, full bath, and custom office facing the river; this space will turn an entrepreneur or writer into a Fortune 500 founder, or NYT bestselling author. The third floor is a welcomed surprise. A sun-filled, tree-lined great room with floor-to-ceiling windows and a set of skylights that transform into 2 Juliet balconies so a couple can enjoy their morning coffee from the treetop view of the river, at the highest point in Philipse Manor. The great room has custom cabinets with refrigerated drawers, storage and buffet style cabinetry for hosting aerial get-togethers, such as the Super Bowl, Derby, or Oscars and it leads to the separate, room-within-a-room, soundproof wing where music and a home theater can be enjoyed without vibration permeating its walls, even at midnight. Although this room has its own cooling, by design, the window placement creates a breeze when opened, as if outdoors, while inside.A whole-house sound system rack space is plug-and-play. Unpack to music in a serene aerial setting, 30-minutes’ drive from Manhattan and a stone’s throw from train, beach club/marina, scenic trails, preserves, renowned restaurants, Jacob Burns’ Theater and Tarrytown Music Hall. Privacy, Serenity and Sun--come experience perfect at 167 Millard...

ML# :876657   Experience refined living in this breathtaking 5, 600+ sq ft contemporary estate, masterfully crafted in 2006 and remodeled in 2023, with stone, stucco, oak, and timeless design. Nestled on 2.5 serene acres in Purchase, NY, this gated retreat offers unmatched privacy, extraordinary amenities, and over 3, 000 sq ft of outdoor entertainment space — ideal for families, entertainers, or executives seeking tranquility, just minutes from Manhattan. A dramatic vaulted-ceiling entry and atrium set the tone for sophistication. The main level boasts over 1, 000 sq ft of open-concept dining and living space with 10-ft ceilings, dual gas fireplaces, and oversized French doors that create seamless flow between the separate family room and living room. The professional chef’s kitchen is a masterpiece, featuring quartz countertops, custom cabinetry, heated ceramic flooring, Wolf dual-oven range, Sub-Zero refrigerator, dual dishwashers, and an oversized island with seating for four. A formal dining room, private ensuite guest/staff quarters, and multiple access points to stone patios elevate functionality and charm. Step outside to resort-style living: multiple patios, a cobblestone dining & entertainment patio, plus a 20x40 heated granite pool with integrated spa and child-safe fencing — all framed by lush, manicured grounds. The second level unveils a breathtaking 16x28 primary suite with 10-ft ceilings, hardwood floors, gas fireplace, dual custom walk-in closets, and a spa-inspired ensuite with whirlpool tub, steam shower, and dual vanities. Three additional ensuite bedrooms with walk-in closets, a dedicated laundry room, and a stunning 26x22 vaulted-ceiling multi-purpose bonus room with sweeping 270° views that can be used as an office, gym, artist studio, extra bedroom, kid’s activity or playroom, and more! The semi-finished basement expands lifestyle possibilities with a 1, 600+ bottle temperature-controlled wine cellar, 4-person sauna, full bath with multi-jet shower, workshop space, and generous storage. Additional highlights include premium double-insulated windows, central vacuum system, whole-house fire sprinkler system, security system, three-zone HVAC system, a 3-car garage with heated floors, private access road, and circular drive. Located in the highly rated Harrison school district, this estate combines privacy with convenience — within 15 minutes from Westchester Airport, Metro North rail, major highways, golf & country clubs, and world-class dining, shopping & entertainment options. This turnkey property is the perfect balance of modern elegance, comfort, and convenience. Schedule your private showing today to experience the lifestyle this extraordinary home has to offer. Proof of funds / pre-approval required upon scheduling all showing.

ML# :865843   Property development site for sale in the heart of Kew Gardens Queens! Area being sold as a LAND sale. Property is zoned R-7A with a total lot square footage of approximately 5317 SF. Located close to E/F express trains, LIRR, Forest Park, shops on Metropolitan Ave., Austin St. and Queens Blvd! Don’t miss this tremendous opportunity to develop a brand new condo or rental building in a highly sought neighborhood!

ML# :836330   Welcome to 15 Hoffstot Lane, a stunning stucco and terracotta-roofed Colonial home, offering panoramic views of the water and marshlands. Nestled at the end of a long, private, tree-lined driveway within the prestigious Village of Sands Point, this custom-built, hilltop residence is designed to fully embrace the property’s breathtaking landscape and serene vistas of preserved wetlands and the Long Island Sound.Boasting over 8, 000 square feet of interior living space, this home features soaring ceilings, oversized windows, and hardwood and tiled floors throughout. The open, sun-drenched first-floor has an open-concept layout, perfect for entertaining. The gourmet eat-in kitchen is equipped with a center island and built-in banquette seating. The impressive primary wing includes a sitting area with a fireplace, an attached private office, a spacious walk-in closet, and a large en-suite bathroom with a soaking tub.The expansive lower level offers a large playroom/flex space, second high-end kitchen, and an impressive at-home gym with direct access to the home’s five-star outdoor amenities.Set on a serene 3-acre lot, the exterior of the home features a vast terrace that spans the length of the property, charming Juliet balconies, and an oversized stone patio with a heated in-ground pool and Jacuzzi. The grounds are incredibly peaceful and private, with a scenic garden pavilion and direct water access to East Creek.Exclusive benefits for Village residents include beach access, a private police force, golf course perks, and much more.

ML# :928673   Welcome to This Move in Ready and Inviting Home Located in the Desirable Development of Post Fields. Situated at the End of a Quiet Cul-De-Sac, this Spacious Residence Offers a Perfect Blend of Hampton Style and Comfort. Step Inside to a Spacious 2 Story Entry Foyer with a Large Living Room and Formal Dining Room. The Open Concept Great Room with a New Custom Designed Gas Fireplace and a Renovated Gourmet Chef’s Kitchen with a Center Island, High End Appliances and Quartzite Countertops Create the Ideal Space for Gatherings. In Addition, the First Floor Offers a Den/Office with Custom Built-In Shelving, a New Half Bath, and a Separate Laundry Room. A Favorite Spot is the Sunroom Which Offers a Tranquil Room to Unwind and Enjoy the Beauty of the Gorgeous Professionally Landscaped Backyard. The Second Floor Includes an Impressive Primary Bedroom Suite with a Large Sun Filled Sitting Room. In Addition, There is a New Primary Bath with Dual Sinks, and a Custom Built Walk-In Closet. The Second Floor Also Includes a Large Bedroom with an Ensuite New Bath, Additional Good Sized Bedrooms and a New Hall Bath. The Finished Basement Includes Luxury Vinyl Floors, a Recreation Area, a Custom Built-In Bar Area with a Full Size Subzero Wine Refrigerator, a Renovated Full Bath, and a Separate Entrance from the Side Yard. The Large One Acre Backyard is Adorned with Impressive, Lush Landscaping Including Extensive Flowering Plants and Ornamental Trees, A Heated Custom Gunite Pool, Full Size In-Ground Heated Spa, and a Bluestone Patio. Enjoy Entertaining on the Custom Newly Refinished Deck Overlooking the Private Backyard. Additional Highlights Include Walnut Floors Throughput, New Gas Burner, New Air Conditioning, New Pool Heating Unit, New Electronic Pool Cover, In-Ground Sprinklers, New Driveway Apron of Belgian Block and a 2 Car Attached Garage. Located in the Desirable Village of Quogue, with Resident Access to the Private Quogue Beach, and Nearby Charming Shops and Restaurants. Don’t Miss the Opportunity to Make This Beautiful House Your New Home.

ML# :898930   Spectacular Live/Work Brownstone.Tribeca Loft Vibes in the Heart of HarlemLooking for the open charm of a Tribeca loft with the warmth of a classic Harlem brownstone? This stunning corner townhouse offers the best of both worlds, blending historic elegance with modern versatility, just a couple blocks away from 125th Street A Train stop.Owner is open to a creative deal.Spanning four impressive floors plus a full basement, this 18ft wide Townhouse is flooded with natural light from its corner exposure. It features three private entrances and the potential to build two additional floors, making it a rare find with endless possibilities. Original details including fireplace mantels and classic architectural elements add to its timeless character. Two split-unit air conditioners were recently installed. Currently configured as a 1 family home!

ML# :939176   Build your dream home in this 1.17 acres buildable lot with 258 ft of WATER VIEWS of Manhasset Bay. Plot is set high of the bay to get spectacular water views in all 4 Seasons. 20 Min to the city, top rated school district. Access to natural gas & sewer.