ML# :863853   Beautifully crafted home with hardwood floors, stone fireplace, and original fixtures. Needs some TLC, but you’ll love it! The beautiful setting will steal your heart. There are 2 stone pillars that mark the driveway entrance, a wide step leading into a covered front porch surrounded by amazing mature trees and shrubs, and a newer roof. This home has a comfortable and private country-like setting with deep woods and serene views of nature behind the house. The 1.9 acres are outlined with the neighborhoods’ signature “stone-laid walls” marking the property boundaries. The 2 side yards are wide and level for recreation and gardening enjoyment. Truly a well-loved home, rich with history, fond memories, and memorabilia of a slower lifestyle. This property is being sold with two additional lots, one located at 102 Cedar Cliff Road, the other on Rye Hill Rd. Please review the parcel map to understand what is included in the price. The 3 parcels are 7-2-14 (13 acres of raw land), 7-2-15 (1.90 Acres with a 2, 149 sq ft house), and 7-2-16 (.34 acres of raw land). The estate wishes to sell all three parcels together, not separately. All offers must be in writing with pre approval or POF. This is an estate sale. It is being sold ‘as is.’ Inspections will be for the buyer’s information only. House is winterized. Electricity is on. No disclosures are available (lead paint, nor NYS Property). The furnishings are negotiable. Basement stairs are accessed from a hatch in the floor (located in the eat-in area of the kitchen), no handrail is installed, so it’s a bit precarious. See MLS # 866644

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# :862853   Welcome to 13411 243rd St, Rosedale—A Charming Two-Story Detached Home Blending Classic Style with Modern Comforts! This inviting residence, set on a 40x100 lot, features a combination exterior and timeless curb appeal. The covered front entry, classic old-style architecture, give the home a clean, low-maintenance look. Enter inside to find a spacious and functional layout across two levels, offering 2 generously sized bedrooms and 2.5 bathrooms. The bright and airy living area features a cozy fireplace, perfect for relaxing evenings. The main bedroom boasts a private balcony overlooking the yard. Both bedrooms are large enough to accommodate full or queen-sized bedroom sets. Additional features include a full basement, perfect for storage or future customization, and a well-sized kitchen area ready for your personal touch. The exterior offers a fenced-in concrete yard, ensuring durability and minimal upkeep. A detached frame garage provides secure off-street parking or workshop potential. Whether you’re hosting gatherings or enjoying private time outdoors, the layout offers privacy and function. Equipped with gas heating for efficient warmth during colder months, the home offers peace of mind and comfort year-round. Located in the heart of Rosedale, you’re near public transportation, schools, shopping, and local parks. With easy access to neighboring communities, this home provides both convenience and a strong sense of community. Don’t miss your chance to own this unique property in a prime Queens location!

ML# :863219   Nestled in a peaceful rural setting, this inviting gentleman’s farm offers over 3 acres of land, complete with a tranquil pond, multiple dwellings, and an array of outbuildings. This exceptional property offers a perfect blend of rustic charm, functionality, and versatility and is perfect for those looking to embrace country living with room to grow a home-based business. The heart of the property is a warm and welcoming 3-bedroom farmhouse, full of rustic character and practical charm. The spacious layout includes a country kitchen, cozy living spaces, and generous bedrooms, making it ideal for family living or hosting guests. A separate 2-bedroom cottage offers additional living quarters—perfect for multi-generational living, rental income, or guest accommodations. Entrepreneurs, tradespeople, and creatives will appreciate the agricultural zoning which permits home businesses—a rare and valuable feature. The detached garage with an attached workshop is well-suited for a mechanic, woodworker, or hobbyist, while the large barn offers ample space for equipment, storage and recreation. The carriage house provides covered parking for two more vehicles, with ample space for more storage above. Whether you’re looking to run a small-scale agricultural operation, work from home, or simply enjoy the quiet beauty of the countryside, this versatile property delivers. With room to roam, a peaceful pond, and infrastructure already in place, it’s the perfect balance of lifestyle and opportunity.

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# :859184   Professional office space available for sale or lease in the heart of Elmhurst. This offering includes three contiguous units totaling approximately 1, 359 square feet (Units C5: 379 SF, C6: 490 SF, and C7: 490 SF), along with one dedicated parking space. Units can be sold or leased individually or as a combined package—ideal for both investors and end-users seeking flexible space in a high-demand area. Strategically located near the M/R subway lines, multiple bus stops, and the bustling commercial corridors of Broadway and Queens Boulevard, this property offers excellent accessibility and exposure. The surrounding residential neighborhoods further enhance the location’s convenience and appeal for both clients and staff. These units are well-suited for a wide range of professional uses, including medical and wellness practices (e.g., physical therapy, acupuncture, counseling, rehabilitation), legal, accounting, or architectural offices, and educational services such as daycare or tutoring. Additional possibilities include retail or wholesale health-related businesses such as pharmacies, medical supply stores, or fitness centers. This is a rare opportunity to secure a versatile, centrally located property in one of Queens’ most dynamic neighborhoods.

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# :858857   Spacious 4-Bedroom, 2-Bath Home in the Heart of WantaghWelcome to 2198 Willow Street—a beautifully maintained 4-bedroom, 2-bathroom residence offering 1, 750 square feet of comfortable living space. Built in 1979, this contemporary-style home features a bright and inviting layout, including a spacious living room and an oversized eat-in kitchen, perfect for both everyday living and entertaining.The home boasts a finished basement with laundry facilities, providing additional space for recreation or storage. Situated on a quiet, tree-lined street, the property offers a peaceful suburban setting while remaining close to local amenities, parks, and schools.With its blend of comfort, space, and location, 2198 Willow Street is a must-see. Don’t miss the opportunity to make this exceptional property your new home.Schedule a private showing today!

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!