ML# :862860   Welcome to this elegant contemporary colonial home, perfectly blending a relaxed atmosphere with luxurious details across 3.1 professionally landscaped acres. Step inside and make a grand entrance through the dramatic foyer, featuring stunning in-lay hardwood floors and stately columns. The expansive living room offers a sophisticated formal space for traditional furnishings and elegant entertaining. Enjoy mealtime in a setting that exudes gracious formality. The two-story family room, complete with a warm fireplace and a convenient wet bar, is sure to become the heart of your entertaining. The first floor also features a desirable home office enhanced by a unique two-sided fireplace. The large kitchen offers both efficient style and inviting warmth, boasting beautiful quartz countertops, top-of-the-line stainless steel appliances, a spacious eating area, and a center island perfect for casual meals or serving as a buffet. Retreat to the luxurious primary suite, a true spa-like haven with a separate shower, double sinks, a whirl pool tub, and a generous walk-in closet. The home also includes three additional well-appointed bedrooms and a versatile bonus room, each sharing thoughtfully designed Jack & Jill bathrooms. Outside, discover your own private resort with a sparkling inground pool nestled within the beautiful, park-like property featuring gorgeous landscaping. This exceptional home enjoys an excellent location, just minutes away from charming village shops and restaurants.

ML# :860839   Exceptional opportunity, Fully renovated 2-family home with stunning river views. Live in one unit and let the other help pay your mortgage or enjoy as a pure investment. Each unit offers stylish modern finishes, updated kitchen and baths, hardwood floors. Ideally located near transportation, shopping, and river views. A turnkey gem don’t miss it!

ML# :852882   Located in Historic Addisleigh Park this Charming 3-bedroom and 1and 1/2-bathroom Cape Cod property is nestled on an oversized lot; with a one car garage and brick paved parking area, that also includes beautiful landscaping. Entrance to the home begins with a modern stone front porch leading to an enclosed foyer with guest closet and a cathedral door closing off the living room from the outside. The main floor living room is enhanced with a beautiful chandelier and woodburning fireplace and leadings `into a formal dining room with its own chandelier and plenty of natural lighting. The dining area is positioned conveniently adjacent to a well-designed energy efficient kitchen with stainless steel appliances. There are plenty of cabinetry for lots of storage and well- maintained counter tops with a two-seat eat-in counter facing the dining room. The second floor has three charming bedrooms with plenty of natural lighting and hardwood floors in each bedroom, and there is a four-piece bathroom. There is a full finished basement that houses a portable wet bar, television area, energy efficient washer & dryer (recently purchased), Half bathroom and utility room. It’s equipped with an updated electrical box, an energy efficient gas water heater, a new hot water heater, and an oil boiler that is serviced annually. The basement is accessible through the kitchen which also allows access to the large backyard. This area has public transportation, close to Long Island Railroad, and 10 minutes’ drive to the Jamaica Transportation Center. Showing by appointment only with a 24 hour’ notice and all buyers must show identification and proof of funds.

ML# :858841   Charming 4-Bedroom, 2-Bath Home with Attached Garage in Prime Valley Stream LocationWelcome to 51 Manor Road — a meticulously maintained 4-bedroom, 2-bathroom residence offering 2, 037 square feet of living space with a built-in laundry room offering the perfect balance of space, comfort, and convenience. Situated in a quiet, tree-lined neighborhood, this home features a bright, sun-filled layout, a spacious living area, and an oversized eat-in kitchen ideal for gatherings and everyday living.Enjoy the flexibility of both a front and side entrance, as well as a private driveway and an attached garage providing secure parking and ample storage. Outdoor space includes a sizable backyard — perfect for entertaining, gardening, or simply relaxing in your own private retreat.Ideally located just minutes from major highways, local parks, shopping centers, dining, and public transportation, this home offers unmatched accessibility while preserving a peaceful, residential setting.Whether you’re upsizing, downsizing, or planting roots, 51 Manor Road is move-in ready and waiting to welcome you home.Schedule your private showing today and experience all that this exceptional property has to offer!

ML# :855755   This one-bedroom apartment in Executive Plaza offers a quintessential Manhattan lifestyle in an unbeatable Midtown location! With Rockefeller Center and The Theater District just a block away, this apartment also offers an array of dining options, shopping and entertainment for your convenience. Beautiful, Fully Renovated one- bedroom in a Luxury Midtown Complex. The building’s amenities include a 24-hour doorman/concierge, fitness center, rooftop deck, a newly renovated laundry and a newly renovated Lobby. This apartment comes FULLY FURNISHED, including housewares and linens. Close proximity to Central Park and Subway Stations are within two blocks!

ML# :856002   Unlock the full potential of this two-family residence, ideally situated in one of Queens’ most vibrant and in-demand neighborhoods. Zoned R6B, this property presents a rare opportunity for investors, developers, or end-users seeking to renovate, expand, or reimagine a versatile space with substantial upside. Currently configured with 5 bedrooms and 2 bathrooms, the home is in need of TLC, offering a blank canvas to add value and maximize returns. Whether you’re considering a custom renovation, income-producing layout, or future development, the flexible zoning and existing two-family Certificate of Occupancy provide a strong foundation. Perfectly located near local shops, schools, transit options, and parks, this property combines convenience with long-term growth potential. Sold as-is, with all zoning and development details to be independently verified by the buyer. Endless opportunity. Flexible zoning. Prime NYC location. Bring your vision—and make it reality.

ML# :855131   Welcome to Northgate, a gated community in Melville. This highly desirable end-unit is the one you’ve been patiently waiting for! Featuring 3 bedrooms and 2.5 baths, the home boasts an open-concept first floor complete with an eat-in kitchen, dedicated home office, and a versatile bedroom created from a garage conversion with proper permits. The spacious living room showcases a stunning built-in entertainment center, marble floors, granite countertops, and a premium Sub-Zero refrigerator. Three sliding doors lead to a serene backyard with a large deck—perfect for entertaining or relaxing in privacy. Upstairs, you’ll find a massive primary ensuite and an additional bedroom with its own ensuite bath. A brand-new HVAC system has just been installed. This beautifully upgraded unit is truly a gem! Enjoy the amenities Northgate has to offer-24 hr gated security, pool, tennis, clubhouse, fitness center, ETC.

ML# :848392   This Quintessential Country Estate Dream Home Does Really Exist. Welcome Home to This Cozy & Charming 1885 Colonial home with Tall, Coffered Ceilings, 6 Large Bedrooms, 2 Full Bathrooms, Living Room, Kitchen along with Office Space and Studio Space, Large Attic (Storage Galore). Dining room, Living room with Library, Family Living Room plus Several More Living Areas for Entertaining. Plenty of options to Create More Living Space and Bathrooms. Property has its very Own Pond, Several Amazing Barns including a Pole Barn and Horse Stalls. Stone-walls, Wrought Iron Fence and Scenic Mountain Views in every Direction. Classic 1885 Architecture that has Retained its Original Opulence. An Absolute Must See. This is the Original House on the Carl Farm hence the name Carl Road. Opportunity Knocks but Once. Will You Be Ready?

ML# :849321   GREAT 2 FAMILY , 3 BDR, 2 BATHS/3 BDR 2 BATHS- FULL FINISH BASEMENT WITH SEP ENTRANCE-- SD BRICK WITH PRIVET DRIVEWAY-

ML# :848127   The best of both worlds! A boho cottage paradise and a modern ADU (Accessory Dwelling Unit). Peace and tranquility and 3 miles from the center of the most famous small town in the world. Five-star dining and unique shopping opportunities. The property is situated adjacent to the Thorne Preserve - 60 acres boasting the most painted views of Overlook Mountain. The preserve is a sweeping grassland habitat and riparian forest. Thorne Preserve will remain an undeveloped sweeping grassland in perpetuity! This charming two-bedroom 1875 cottage is the envy of the neighborhood - it looks like it has been plucked from a 19th-century expressionist painting. The ADU currently used as a studio/guest house has all the possibilities and potential to fulfill all your dreams. Become a maker/artist and use it as a studio - or turn it into a modern guest house or pool house. This property is on 1.89 acres of level grassland that is calling for an in-ground pool. Come find paradise today! A 3D Walkthrough Tour is available in the digital Lookbook or by request from the listing agent.