ML# :3465683   Location Location Location!! Mixed Used Property In Prime High Traffic on Roosevelt Ave, 1 Store Front And 2 Apartments with Full Basement, 1 Block To The Junction Blvd (7 Train Station),

ML# :896815   This impeccable legal brick 10-family house is located in the heart of Astoria and offers an excellent investment opportunity. The property features two spacious two-bedroom apartments, six large one-bedroom units, and two studio apartments, making it an investor’s dream. With a building size of 27.25 x 68 feet, it is conveniently situated close to the N/W 30th Avenue station, as well as the M/R lines at Steinway Street and 46th Street. The Q18 bus is just two blocks away on Steinway Street, providing easy access to public transportation. Additionally, the property is in close proximity to major routes such as Grand Central Parkway, Triboro Bridge, and Queensboro Bridge. Residents will enjoy nearby amenities, including houses of worship, schools, shopping centers, and a variety of restaurants. This is a prime investment opportunity to own a multi-family residence in a vibrant and accessible area.

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# :888227   Exceptional Opportunity in Ridgewood’s Historic DistrictA true trophy building in a prime landmark district of Ridgewood, this property represents the kind of opportunity that only becomes more valuable as time goes on. Demand for homes in Ridgewood’s Historic District continues to rise, making this a standout asset for both end users and investors alike.This well-maintained brick corner building is located in the heart of Ridgewood’s Historic District, just off Fresh Pond Road. The property is ideally situated two short blocks from the Fresh Pond M train stop and approximately 0.4 miles from the Forest Ave M stop, offering quick access to Manhattan and surrounding neighborhoods. It’s surrounded by local cafes, restaurants, parks, and amenities—an ideal location for families and commuters alike.Spanning nearly 4, 000 square feet of interior space (not including the basement), the building offers a flexible layout across three stories plus a full basement. The first floor is currently configured as two separate apartments: a studio in the front and a one-bedroom in the rear. The second and third floors each feature spacious floor-through three-bedroom apartments with large windows and abundant natural light. The basement, while unfinished, provides excellent potential for storage or conversion into recreation space by a future owner.Additional highlights include gas heating, a rare three-car garage, and a small private outdoor space situated between the house and the garages—perfect for gardening, grilling, or relaxing.Whether as an end-user purchase or an investment, this is a rare chance to own a classic corner building in one of Ridgewood’s most desirable and historically significant neighborhoods—a property that will only appreciate in prestige and demand.

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# :3541278   110-62 Corona Ave is newly renovated semi-detached mixed-use building. The property is located in Corona, Queens which is a rising community. Situated near major shopping centers and is near MTA trains and buses. The property has 1 retail store and 4 of 2 bedroom apartments. Recently renovated 4 apartments are free market rate rent. Each units has its own gas meters, heating is separated, paid by tenant., Building Size:20*65

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# :913438   542 Bergen Street, a rare six-unit multifamily opportunity located in the heart of Prospect Heights, Brooklyn. This handsome property spans 5, 652 square feet on a 25’ x 131’ lot and features six well-proportioned three-bedroom, one-bathroom apartments. Each unit is separately metered for gas and electric, providing convenience and efficiency for both ownership and tenants.The building has been meticulously maintained, boasting a newly replaced roof (2023), a reliable boiler and hot water heater, and a full basement with utilities. Modern conveniences include a comprehensive security camera system with eight cameras throughout. At the rear, residents enjoy a spacious shared yard, an increasingly rare amenity in this neighborhood, perfect for relaxation and gatherings.?Set in vibrant Prospect Heights, this property offers the perfect blend of historic charm and modern city living. Just minutes from Barclays Center, residents are surrounded by a dynamic mix of world-class restaurants, trendy cafés, boutique shops, and cultural landmarks. The neighborhood is also known for its tree-lined blocks, stunning brownstones, and welcoming community atmosphere. With excellent subway access nearby, commuting to Manhattan and other parts of Brooklyn is effortless.