ML# :853603   Exquisite Split-Level Residence in Prestigious Bayside Gables.Welcome to Bayside Gables, one of New York City’s premier gated communities and the crown jewel of Bayside. Known for its elegance, security, and exclusivity, this neighborhood is home to some of the most luxurious residences in Queens. With its multi-million-dollar estates and serene, residential atmosphere, Bayside Gables offers an upscale lifestyle.URGO REALTY, INC. is proud to exclusively present this distinctive single-family home, thoughtfully designed in a classic Split-Level style, where multi-tiered living spaces are seamlessly connected by short staircases for both function and charm.This expansive residence offers: 4 floor levels plus a basement:BASEMENT LEVEL- Finished with utility room, open floor plan, storage space, separate thermostat, and cedar closet. GROUND LEVEL- 1 bedroom, one bath, laundry room with newer W/D, walk-out door to double garage, closets FIRST LEVEL- Large living room, with fireplace, formal dining room, eat-in kitchen, den/family room.SECOND LEVEL 3 bedrooms, one is the master bedroom with a marble full bath, walk-in closet, many built-ins, and hardwood flooring.ATTIC- Fully finished, carpeted, with 1bath with shower. Imagine enjoying a generous 3, 657 sq ft interior space across four levels, and a finished basement. Imagine enjoying the interior that is always drenched with sunlight and then looking out to the meticulously landscaped 13, 100 sq ft lot with a backyard front yard and double garage. Lovingly maintained by a long-term owner, the home exudes warmth, cleanliness, and character in every room.The property is located in an R1-2 zoning district, and it benefits from generous open space requirements. it also boasts an additional 2, 882 sq ft of unused FAR (floor area ratio). Whether you’re looking to extend or build up, there’s ample potential for redevelopment—subject to Department of Buildings and Bayside Gables HOA approvals.Whether you’re searching for a forever home with estate-style living or you are exploring a unique redevelopment opportunity, this property is a rare find.Call today for a private tour.________________________________________

ML# :897769   Welcome to 97 Station Rd located in the prestigious Village of Great Neck. Step into a world where timeless elegance meets modern sophistication in this beautifully renovated home, thoughtfully designed to elevate everyday living. From its expansive layout to premium finishes, every detail has been meticulously crafted to deliver both luxury and functionality.The first floor welcomes you with a grand open-concept living and dining area, ideal for entertaining and daily living. The state-of-the-art chef’s kitchen is a true showpiece, featuring high-end appliances, custom cabinetry, sleek countertops, and a spacious walk-in pantry. A stylish powder room, while a private side entrance offers the perfect setup for a home office or professional use. Natural light floods the sun-drenched den, which overlooks the beautifully landscaped backyard—an inviting space designed for relaxation and gathering with guests. A private guest suite with a full bath on the main level provides a serene and elegant retreat. Upstairs, the second floor is home to a thoughtfully designed layout offering privacy and comfort. A serene bedroom suite with its own en-suite bath complements two additional bedrooms that share a beautifully appointed bathroom. The hallway includes a convenient laundry room, designed for ease of access. The true highlight of this level is the luxurious primary suite. private sanctuary featuring walk-in closets and a spa-like en-suite bathroom. The walk-out lower level is equally impressive, boasting a vast, finished space opening up to a beautiful patio and parklike property enhancing flow and functionality throughout the home. A circular driveway completes the exterior, offering both curb appeal and everyday convenience.

ML# :864741   Welcome to your exceptional new home in the prestigious Estates at Baiting Hollow. This sophisticated modern farmhouse seamlessly combines timeless elegance with state-of-the-art innovation, situated in one of the North Fork’s most desirable communities. Crafted with both beauty and efficiency in mind, each residence in this exclusive enclave is designed to achieve net-zero energy performance and is equipped with smart home technology, offering an unparalleled blend of comfort, sustainability, and convenience. This stunning home features a thoughtfully designed open-concept layout, harmonizing refined sophistication with everyday functionality. The centerpiece of the home is the impressive great room, highlighted by soaring ceilings, a striking fireplace, and expansive sliding glass doors that open to your spacious backyard. The chef-inspired kitchen is a dream, complete with a grand center island, custom cabinetry, and an expansive walk-in butler’s pantry, ensuring both convenience and style.Boasting four generous bedrooms and four luxurious bathrooms, this home is designed for both relaxation and entertaining. Two of the bedrooms offer en-suite baths, providing added privacy and comfort for family or guests. The primary suite serves as a serene retreat, featuring a spacious walk-in closet and a spa-inspired bathroom with dual vanities, a freestanding soaking tub, and an oversized shower for the ultimate in relaxation. Additional highlights include a well-appointed home office, perfect for today’s flexible lifestyle, as well as a thoughtfully designed laundry area, a mudroom with built-in storage adjacent to the garage, and convenient walk-out basement steps, offering both practicality and potential.With its blend of exceptional design, high-performance features, and luxurious finishes, this home is truly a masterpiece, offering a serene oasis for those who seek the finest in modern living.

ML# :909373   Welcome home to this one-of-a-kind 4 Bedroom, 3 1/2 Bath, 4700+ square foot residence located in the award-winning Blind Brook School District that simply exudes curb appeal.Set on over a half-acre of private property surrounded by mature trees and specimen plantings, 17 Magnolia Drive offers the ultimate blend of comfort, privacy, and resort-style living. The expansive patio and beautifully designed in-ground pool with spa create an ideal setting for entertaining or simply relaxing at home, with total seclusion and space to host gatherings of any size.Inside, the home strikes the perfect balance between modern open-concept living and traditional formal rooms—ideal for both everyday living and holiday entertaining. The second floor boasts four generously sized bedrooms, including an expanded primary suite with skylights, dual closets, dressing area, and a large spa-like bath filled with natural light. The lower level is designed for fun and function, featuring a spacious family room, bar, game area, full bath and direct access to your outdoor oasis. Don’t miss this rare opportunity to own one of Rye Brook’s most special homes—and make it your forever home.

ML# :853001   If you are looking for a luxury lifestyle where you feel like you are on vacation year-round at a high-end hotel, there are two words that say it all, “Ritz Carlton.” Just like the original hotel in New York City, known for exceptional service from a caring staff and high-end amenities, the Ritz Carlton Residences at North Hills have it all. And this designer, palatial three- bedroom prized corner unit adds an additional layer of comfort and space with an oversized private stone terrace (45’ X 23’) offering ample room for sunning, dining, and gardening plus a shady veranda with two sets of French doors opening into the interior. This includes a bright and airy dining area and living room with fireplace, plus a large, state-of-the-art kitchen with high-end appliances, ample cabinetry, marble countertop, and a generous center island with seating area, sink, and wine cooler. You can enjoy intimate dinner parties here, or for larger events, you can reserve one of the many entertainment suites in the Club House, a country-club-like-place for residents that offers a theatre, gym, indoor and outdoor pools and spas, game rooms, banquet rooms, lounge, and more. A long hallway, connecting the main area to the entrance foyer, provides access to a large laundry/storage room, a lovely powder room, a sunny den/guestroom, and the lavish primary suite boasting a sunny bedroom, two custom-fitted walk-in closets, and an indulgent marble primary bath with twin vanity, glass-enclosed shower, and a deep soaking tub. On the opposite side of the unit, an elegant bedroom with its own private bath and closet is ideal for guests. Services and amenities for residents of the Ritz Carlton Residences are too many to list here but can be found on its website. They range from two parking spaces for this apartment in the underground garage, limo service to the Manhasset train station or Americana at Manhasset mall. Gated entrance with 24-hour security, lobbies and lounges in all buildings serving heated drinks in the morning and beer, wine and spirits in the evening. Complimentary 24-hour concierge, doormen and porters who know your name, porte-cochere, valet service, and travel/vacation assistance. Additional services (with additional fees) include housekeeping, dog walking, pet care, laundry and dry-cleaning, catering arrangements, etc. Additional features include high ceilings, hardwood floors, seven inches of concrete between floors, lighted walkways, lovely landscapes with ponds, fountains, and seating areas; pet friendly. North Hills offers a plethora of restaurants, shopping centers, golf courses, parks, and is close to all the cultural and recreational facilities in the fabled Gold Coast’s North Shore. Whether you are ready to retire and enjoy a pampered, stress-free life, or you are seeking a second home away from home, you are sure to fall in love with this move-in-ready property. Its staff are famous for tending to your every need, just as they do at the world famous “Ritz Carlton Hotel.” Enjoy world-class amenities within the 25, 000 square foot clubhouse featuring state of the art fitness center, indoor & outdoor pools, private movie theater, golf simulator, conference rooms, event spaces and a resident lounge with bar service. White glove services at the Ritz Carlton include 24 hour concierge, valet parking and complimentary transportation to the Americana Manhasset and the Manhasset LIRR Station- ensuring effortless & easy access to Manhattan. Separate storage unit. View 3D tour and floor plan.

ML# :875041   Sophisticated and stylish Edgemont school district Cotswold Tudor is renovated with gorgeous high end modern finishes. This home is located on a beautiful half acre property with stone and brick patios, specimen plantings and lush mature landscaping. You will love the renovated cook’s kitchen with custom white cabinetry, Brazilian quartzite counters, Moroccan concrete tile heated floor, high-end Thermador appliances and a cool oversized Lualdi Ferrari red lacquered swinging door from Italy. The grand living room is a wow with floor to ceiling windows, French doors to stone patio, high ceiling, wood beams, and stone fireplace. The first level also features an elegant dining room adjacent to the butler’s pantry with coffee bar and wine fridge, inviting den with built-ins overlooking the backyard, cozy home office, exquisite powder room, and incredible entry with Platinum Travertine granite slab floor. The 2nd level offers the expansive primary bedroom with tray ceiling and luxurious spa bath with honed Calcutta marble, heated floor, double sinks, large shower and tub. Two large bedrooms with shared bath, spacious bedroom with en-suite bath, additional bedroom, office, hall bath and back staircase complete the second level. Other highlights include generator, temperature controlled wine cellar, two car garage off kitchen, walk-up floored attic, and lower level with recreation space, powder room, laundry room and storage. Fantastic location close to schools, Scarsdale village, train, shops and restaurants. Don’t miss out on this gem!

ML# :844165   Tucked away on a fully fenced, over two-acre, park-like, electronic-gated property, stands a sprawling Farm Rach expanded and remodeled in 2007. This 5, 400-square-foot mini estate of your dreams is located in the scenic Upper Brookville village. With rolling wooded open spaces rife with wildlife and dotted with grand and historic estates, you will be close to boating, golf, equestrian facilities, quaint village shopping, museums, and Long Island Railroad with about a 40-minute commute to Manhattan. Within about a mile radius of your home you will find four golf courses, a produce farm, a nursery (both with stores), and mansion museums and preserves. Oyster Bay, Locust Valley, and East Norwich villages are just a little farther away.Surrounded by sprawling, level lawns bounded by rows of evergreens and split-rail fences, the main building wraps around a delightful outdoor entertainment complex with large Gunite, saltwater pool, with hot tub and water feature, expansive bluestone patios, and a large, covered cooking pavilion with ample bar seating. Think of the fabulous summer parties you can enjoy in this inviting setting. At the end of the pool, a garden offers colorful plantings, fruit frees and a privacy wall of evergreens. On the east side of the pool, a free-standing, legal guest cottage may invite its guest to an early morning dip, and on the west side, a large recreation room, with full bath, walk-in closet, a large pub-like wet bar with wine cooler, a game area, and a home theater, can serve as a great cabana party room.A bookcase-lined hall leads from the pool party room into the sitting room of a large in-law suite that includes a summer kitchen, laundry room, luxury full bath, and bedroom. A hall opens from the apartment into the main house where a banquet-sized dining room creates a Tuscan atmosphere with a stone fireplace and open-beam ceiling. The spacious eat-in kitchen has similar open-beam ceiling and rustic lighting. It offers extensive cherry cabinetry, granite counters, several windows overlooking the front courtyard, a huge center island with wine cooler, a walk-in pantry, and high-end stainless-steel appliances, including a double wall oven with convection, and a six-burner glass cooktop beneath a custom copper exhaust hood. The spacious, sunny, two-story entrance foyer, with powder room, features a staircase, with ornate iron balustrade, ascending to a second-floor balcony. The adjoining, spacious and welcoming living room provides sunny views through huge front and rear windows, a closet, and access to the attached two-car garage. Two steps down from the foyer and kitchen, an immense, sun-drenched four-season room features stone floors, huge windows overlooking the pool and patio, access area the pool, and a stone corner wall housing an arched wood-burning oven/fireplace; perfect for pizza parties.On the second floor, a balcony with study area leads down a hall to two bedrooms, a hall bath, and the primary bedroom wing. This private retreat offers a spacious bedroom with ample windows, two walk-in closets, and a luxury marble bath with walk-in shower, twin vanities, and whirlpool tub. Accessed from the entrance foyer, the partial basement has a spacious gym area, a laundry area, and room for ample storage. Additional features include: central vacuum; two fireplaces; electronic gate; smart thermostat; fully-fenced property, second fence around pool area; whole-house entertainment system with speakers; Energy Star appliances; hardwood floors where seen; and fruit trees (apple, pear, peach). Offering so many possibilities for the various areas of this expansive home and on such a beautiful level property, with sweeping lawns and shady tree areas, this amazing mini-estate is ready for you to move in and start living the life your dreams. View 3D tour & floor plan.

ML# :865864   One-of-a-Kind Offering! Build your Dream Home in the only gated community within the Village of Old Brookville. Enter this newly developed 23+ acre community through impressive remote-controlled gates. Proceed on a secluded and lushly landscaped two-lane motor court to a quiet sanctuary and cul-de-sac featuring six buildable lots ranging from 3 to 4 acres each. Each lot has already been improved with underground utilities which include natural gas, electric, water, cable and a driveway curb cut. The only thing left is to design the home of your dreams and start building! Adding to the beauty, ambiance and privacy of the area, across from the gated entrance to the Chatwal Estates, there is a 60-acre parcel known as Young’s Farms Fields that is to be forever preserved in its natural state. Conveniently located only 25 miles from Manhattan and close to fine dining, schools, clubs and shopping.

ML# :883206   Custom Designed Mediterranean Inspired Colonial Located In Bayside Gables On An Oversized 80 X 103 Lot. A Grand Entryway With Granite Flooring, Double Hall Closet & Marble Powder Room, Formal Dining Room, Eat In Kitchen, Laundry Room, Den With Fireplace & Sliding Glass Doors Leading Out Onto A Brick Patio Ideal For Outdoor Dining & Entertaining.Circular Staircase Leading Up To Your Second Floor Living/Media Room Overlooking The Lush Gardens With Skylights, 1 Flight Up To Your Primary Bedroom Ensuite With Full Bath, 2 Walk In Closets, 3 More Bedrooms With Water Views & Balcony Overlooking Little Neck Bay. Moving Down To The Lower Level Family Room & Basement With Plenty Of Space For Home Office, Recreation & Game Room...Conveniently Located Near All, Transportation To NYC & LI Via LIRR, Express Buses To Manhattan & Local Buses To Main Street, The Bay Terrace Shopping Center, Schools, Library, Movie Theater, Restaurants & Cafes Along Bell Boulevard...The Next Move Is Yours...

ML# :878760   Built in 1985 this Sprawling Custom-Built 6-bedroom, 6-bathroom (4 full & 2 half baths) Colonial is tastefully Designed, with -7, 000 Sq’ on 1.78 acres. Grand 2-Story Entrance with hardwood floors, Formal Living Room with Fireplace. The Dining Room leads you to the Eat in Kitchen with an Oversized cooking Island, SS Appliances, Granite Countertops and an abundance of Cabinet space. Family room with Fireplace that leads you to the Sitting room & Bar.Upstairs will wow you with the Primary Bedroom that includes a Fireplace, 2 Walk-in Closets and a Primary Bathroom. There are 2 other ensuite bedrooms and a jack and jill bath. updates include new septic system 2018, new 400 amp electric, HVAC 2023, new water service 2023, new sprinkler system 2024, in ground pool refurbished 2024 including new liner, and the chimney has an all new exterior brick veneer. This home is located close to beautiful Northport Village, a quaint seaside village on Long Island, NY, with a rich history and a vibrant community. This spacious home offers endless potential for a buyer looking to create their dream home. Ideally located, a short distance from the local Winery (Del Vino Vineyards), shops, restaurants, and Northport’s charming downtown. Don’t miss this opportunity to transform this gem into your perfect oasis!