ML# :3586811   Welcome to 210 Aldershot Lane, an exquisite Center Hall Colonial, nestled on a coveted cul-de-sac in Strathmore. From the moment you step into the grand foyer, this elegant residence invites you to explore its spacious open floor concept. Featuring a bright living room, family room with a cozy fireplace, formal dining room, breakfast nook, an expansive eat-in kitchen, an en-suite guest bedroom for easy relaxation. Upstairs, the primary suite is complete with a walk-in closet and jacuzzi tub, creating a private retreat. Along with three additional bedrooms and two full baths. Fully finished lower level provides a recreational space, home theater and gym, perfect for entertainment. Outside, a sprawling backyard with a deck makes the ideal setting for outdoor gatherings and family fun. Conveniently located near schools, parks, and expressways, this beautiful home offers an unparalleled lifestyle of comfort and convenience. Don’t miss it.

ML# :3584662   Welcome to this newly constructed, luxurious single-family home, crafted with only the finest materials. Offering 5 bedrooms and 5.5 bathrooms, this home provides plenty of space for comfortable living. Designed for ultimate comfort, the entire house is equipped with radiant floor heating to keep you warm in every season. This home also features top-of-the-line Sub-Zero and Wolf appliances, ensuring a high-end kitchen experience. With 3 layers of insulation, you’ll enjoy exceptional energy efficiency and quiet living spaces. This stunning property combines elegance with modern convenience, offering quality construction, premium finishes, and ample living space.

ML# :3553290   Great Location, Det Brick 6 Family, Free Market, 100% occupancy. Tenants pay own Utilities, 6 two-bedroom, Each apartment around 800 square foot. 3 Parking spaces and 1 Garage.Finished Basement with separate Entrance. Close to All

ML# :3589804   Welcome to this Majestic Tudor nestled on an oversized private lush property with endless sunshine and mesmerizing landscape. Step into an exquisite, elegant foyer which leads you to a Gracious sunlit formal living room with high ceilings, meticulous attention to detail and an inviting wood burning fireplace, adjoining library with walls of glass , large formal dining room with custom crafted woodwork, perfect for entertaining large parties as well as intimate gatherings. A gourmet kitchen and den, guest room with on suite full bath. An elegant powder room completes the first floor. Upstairs boasts a large primary bedroom with sitting area, Marble en-suite bathroom, 3 additional bedrooms with 2 full bathrooms. Lower Level has a large playroom, Bedroom with full bath and lots of storage. A Flat parklike backyard with verandas & patios is the perfect place for entertaining and country club living. Located in the prestigious Village of University Gardens with pool club and Tennis. Close to all. This enchanting gem is A must see!!!!

ML# :3589237   An Excellent, Detached, 3-Family Brick Townhouse with Limestone Accents - Fully Renovated, with a Rooftop Terrace, Finished Basement and Backyard ***Owner Financing Available*** Presenting a rare Astoria find with timeless architecture enhanced by modern conveniences. In true MINT condition, it has been completely redefined down to every structural detail. This high-income generating property is a smart investment for investors or live-in homeowners alike! FIRST FLOOR Renovated, 2-bedroom, 1.5 bath unit with modern finishes consisting of an eat-in-kitchen, living room, a master bedroom with bay windows and a second full size bedroom. From the kitchen there is access to the immaculately landscaped, private backyard. With 10 large windows, the unit receives ample natural light throughout. SECOND FLOOR A 2-bedroom unit with an EIK featuring a large peninsula with an overhang to accommodating seating. The dining area has sufficient space for a full dining setting and is followed by the living room. Abundant in natural light, this apartment features 11 windows with custom window treatments. For added convenience the unit has 1.5 bathrooms (with washer/dryer hookup in 1/2 bath). THIRD FLOOR - DUPLEX UNIT This unit is a fantastic haven and one of the best features of this property. The main room is open, airy and bright, consisting of a large living room, full size dining space and a sun-drenched kitchen with a peninsula. Two of the bedrooms are also located on the first floor of the duplex. An open staircase leads to the second tier, a spacious loft style room, complete with a finished roof top terrace with breathtaking views of Astoria and Manhattan’s skyline. This unit has central air conditioning throughout. BASEMENT A fully finished basement, subdivided, to create two separate recreational spaces, both with private entrances. The front room is set up as an office/work studio with kitchenette, polished concrete floors and has high ceilings and several windows allowing for natural light. The rear space features a rec room, bathroom, and access to the backyard. The rear space has a separate entrance with a large rec room, high ceilings, windows and split unit central air.(Accessible from both a private entrance or from within the building). OUTDOORS A beautifully landscaped elevated backyard space that receives sunshine all day long. (accessible from the front of the property as well as the basement and first floor unit). Finished roof top terrace with premier decking (aprox. 330 square feet). COMPLETELY REFINED AND NO DETAIL SPARED- A MINT CONDITION PROPERTY NOT TO BE MISSED! ADDITIONAL HIGHLIGHTS: -Solid oak wood flooring throughout -Intercom system for all units -All sewer lines replaced (2024) -Torched rubber roof (2019) -New rooftop terrace (2019) -New windows in front and rear of house (2023) -New rear retainer wall (2023) -Basement with high ceilings (floor lowered 9 in 2024) -New gas boiler (2024) -New hot water tank (2024) -Each unit with separate electric panel -Washer/Dryer hookups present on each floor -3rd Floor has its own 2 ton central a/c located on the rooftop BONUS ***Owner Financing Available*** LOCATION Situated in the most desirable area of Astoria, this property is in a PRIME location where every convenience is just a short walk away. The vibrant neighborhood is abundant in cafes, restaurants and culinary delights abound. TRANSPORTATION A commuter’s dream with excellent access to Manhattan, the tri-state area or local airports. Easy commuting via subway, several bus routes, car and Citi Bikes. Several major highways and bridges are within a mile. Be in Midtown Manhattan in just 20 minutes or LaGuardia airport in 10! *Building Size 20 ? 55 *Lot Size 25 ? 100 *Zoning R6B *Taxes $13, 775

ML# :3589184   An Excellent, Detached, 3-Family Brick Townhouse with Limestone Accents - Fully Renovated, with a Rooftop Terrace, Finished Basement and Backyard ***Owner Financing Available*** Presenting a rare Astoria find with timeless architecture enhanced by modern conveniences. In true MINT condition, it has been completely redefined down to every structural detail. This high-income generating property is a smart investment for investors or live-in homeowners alike! FIRST FLOOR Renovated, 2-bedroom, 1.5 bath unit with modern finishes consisting of an eat-in-kitchen, living room, a master bedroom with bay windows and a second full size bedroom. From the kitchen there is access to the immaculately landscaped, private backyard. With 10 large windows, the unit receives ample natural light throughout. SECOND FLOOR A 2-bedroom unit with an EIK featuring a large peninsula with an overhang to accommodating seating. The dining area has sufficient space for a full dining setting and is followed by the living room. Abundant in natural light, this apartment features 11 windows with custom window treatments. For added convenience the unit has 1.5 bathrooms (with washer/dryer hookup in 1/2 bath). THIRD FLOOR - DUPLEX UNIT This unit is a fantastic haven and one of the best features of this property. The main room is open, airy and bright, consisting of a large living room, full size dining space and a sun-drenched kitchen with a peninsula. Two of the bedrooms are also located on the first floor of the duplex. An open staircase leads to the second tier, a spacious loft style room, complete with a finished roof top terrace with breathtaking views of Astoria and Manhattan’s skyline. This unit has central air conditioning throughout. BASEMENT A fully finished basement, subdivided, to create two separate recreational spaces, both with private entrances. The front room is set up as an office/work studio with kitchenette, polished concrete floors and has high ceilings and several windows allowing for natural light. The rear space features a rec room, bathroom, and access to the backyard. The rear space has a separate entrance with a large rec room, high ceilings, windows and split unit central air.(Accessible from both a private entrance or from within the building). OUTDOORS A beautifully landscaped elevated backyard space that receives sunshine all day long. (accessible from the front of the property as well as the basement and first floor unit). Finished roof top terrace with premier decking (aprox. 330 square feet). COMPLETELY REFINED AND NO DETAIL SPARED- A MINT CONDITION PROPERTY NOT TO BE MISSED! ADDITIONAL HIGHLIGHTS: -Solid oak wood flooring throughout -Intercom system for all units -All sewer lines replaced (2024) -Torched rubber roof (2019) -New rooftop terrace (2019) -New windows in front and rear of house (2023) -New rear retainer wall (2023) -Basement with high ceilings (floor lowered 9 in 2024) -New gas boiler (2024) -New hot water tank (2024) -Each unit with separate electric panel -Washer/Dryer hookups present on each floor -3rd Floor has its own 2 ton central a/c located on the rooftop BONUS ***Owner Financing Available*** LOCATION Situated in the most desirable area of Astoria, this property is in a PRIME location where every convenience is just a short walk away. The vibrant neighborhood is abundant in cafes, restaurants and culinary delights abound. TRANSPORTATION A commuter’s dream with excellent access to Manhattan, the tri-state area or local airports. Easy commuting via subway, several bus routes, car and Citi Bikes. Several major highways and bridges are within a mile. Be in Midtown Manhattan in just 20 minutes or LaGuardia airport in 10! *Building Size 20 ? 55 *Lot Size 25 ? 100 *Zoning R6B *Taxes $13, 775

ML# :H6323397   Exclusive home at The Ritz Carlton Residences in NORTH HILLS. This 3 bedroom, 3.5 bathroom corner unit features an open floor plan and a large private and oversized wrap-around terrace. Each bedroom has a private full bathroom with marble flooring offering complete privacy. The kitchen is a magnificent chef’s kitchen with Sub-Zero & Wolf appliances. There are beautiful hardwood floors throughout the apartment. The living room is warm and inviting with a gas fireplace and access to the terrace. The complex is equipped with a backup generator which allows residents to not be inconvenienced by power outages. The Ritz Carlton Residence lifestyle amenities include 24-hour Concierge & Valet, Theater, Fitness Center, Indoor/Outdoor pool, golf simulator and more. Don’t miss this opportunity.

ML# :3568206   This is an exceptional opportunity! A brand new, magnificent 5-bedroom, 4.5 bathroom home situated in the coveted College Section of Woodbury, accompanied by Syosset Schools. From the moment you enter through the double doors, the seamless flow and impeccable design of this center hall colonial are immediately apparent. Spanning an impressive 4500 square feet, every corner of this residence showcases the builder’s finest craftsmanship and contemporary luxury. The 9-foot ceilings, custom millwork, coffered ceilings, gorgeous lighting and wide plank hardwood floors add a touch of opulence to every space. The heart of the home, the custom gourmet kitchen, is a chef’s dream with its striking center island and top-of-the-line stainless steel appliances tailored for gas cooking. Whether entertaining in the living room, dining room, or the spacious great room with a gas fireplace and exquisite cabinetry, guests are sure to be enchanted by the views of the paver patio. The first floor is designed for convenience, with a bedroom featuring an adjacent full bath, along with a powder room. Upstairs, the primary suite is a luxurious retreat, complete with a resort-style bath, radiant heating, and expansive walk-in closets. Three additional bedrooms, two baths, and a laundry room complete this level. The basement offers ample storage space with its desirable 9-foot ceiling and outside entrance, complimented by a 2-car garage. Outside, the fully fenced backyard with an in-ground gunite pool sets the stage for outdoor gatherings and relaxation. With the builder’s renowned attention to quality workmanship and luxurious amenities, this home is sure to be a masterpiece of modern living, offering its residents a lifestyle of unparalleled comfort and elegance

ML# :3575417   Situated in the vibrant center of Flushing, this exceptional mixed-use property offers unmatched convenience with just a 5-minute walk to both the 7 train station and the Long Island Rail Road (LIRR) station, providing a swift 30-minute commute to Manhattan. This property is ideal for both residential and commercial use, delivering a strong net income of $170, 850 annually and a remarkable return on investment of 6%. With its strategic location and excellent financial performance, this property represents a lucrative opportunity for savvy investors. Don’t miss your chance to own a high-potential investment in one of Flushing’s most desirable locations.

ML# :3575107   Young All Brick building is located in the prime location of downtown flushing. It consists of 4 residential units and one commercial space. Yearly income $170, 400. Great investment opportunity, income producing property. Convenient access to public transportation, shopping centers, Restaurant, Bank, Library, Main St, A must see...