ML# :3586367   Introducing Columbia Cottage, circa 1880, a beautifully preserved gem in the heart of Sea Cliff. Featured in Gaslight & Gingerbread: A Photographic Recollection of Sea Cliff, this home has only grown more enchanting with time, blending modern updates with historic charm. The idyllic front porch, framed by lush greenery and water views, invites you to relax before even stepping inside. Located just steps from Bath Way, the Sea Cliff Yacht Club, and the beach, this home is surrounded by all the village’s best amenities-shops, restaurants, art galleries, and live music. With award-winning North Shore schools, Columbia Cottage offers a perfect blend of history, community, and modern comfort for year-round living.

ML# :3585101   Don’t miss out on this fantastic opportunity to own a prime commercial property in the heart of Brooklyn. This highly visible storefront is located in one of the city’s most bustling neighborhoods, making it the ideal spot to establish your business. With its spacious layout, modern design, and flexible floor plan, the property is perfect for a variety of business uses-whether it’s retail, a restaurant, or office space.Brooklyn’s thriving local economy and vibrant community provide a strong customer base, ensuring foot traffic and visibility for your business. The prominent location of this property gives a prime opportunity to attract customers.The open and versatile space allows you to design the interior to match your business vision, whether you’re showcasing products, providing services, or creating an engaging dining experience.With plenty of flexibility to customize the space to your specific needs, this is your chance to make your mark in one of New York’s most dynamic commercial hubs. The possibilities are endless. Don’t wait any longer to turn your business dreams into reality!

ML# :3585100   Discover this spectacular, top floor Penthouse at The Forrestal Condo Development in diamond condition situated on a tree-lined residential block in an exclusive section of Forest Hills. The most astounding feature of the apartment is enormous wrap-terrace with 360 vistas of Queens, Forest Hills Gardens and beyond. The owners spared no expense on the details, which includes fine European craftsmanship from the custom paint job to the recessed lighting, in unit sound system, California-style closets, and so much more! The large living room is wrapped in windows providing maximum light and air and open vistas leading out the huge private deck. The state-of-the-art windowed open concept Eat-in-Kitchen features beveled black and silver countertops, Sub-Zero top Fridge bottom Freezer, a Miele Range with venting that goes right out of the unit is a chef’s delight. Two king sized bedrooms offer plenty of space and customized closets as well as recessed lighting. The master suite has an en-suite bathroom with finely crafted Italian tile and bathtub as well as vistas of the Manhattan skyline in the distance. While the second bedroom offers beamed ceilings and access to the deck. Additional amenities include, large walk-in pantry closet, over-sized linen closet, second full bathroom with Italian glass walk-in shower, video security system, i-home system, built in sound system, pre-wired for fiber optic service. HOA includes heat, hot and cold water, cooking gas. Easy access to all transportation - E/F subway (71st Ave. station)/MTA bus into Manhattan, ten minutes to 71st/Continental Ave. and the LIRR. Central location with convenient access from Grand Central Pkwy. to JFK and LaGuardia airports. Austin Street boutique shops, restaurants, cafes and food markets nearby. Zoned for P.S. 196. This special, turn-key apartment is your golden opportunity to own luxury real estate in the best location of Queens today!

ML# :H6330244   Welcome to this spectacular completely updated 4 bed, 4 bath Split level Spacious and bright home on a large Cul-de-sac property in Irvington School District. This house is renovated with recent addition of another Master bedroom and Master Bath with walk in closets. Modern EIKitchen, DRM/SLGD to brand new deck and yard. Entertaining is a breeze with the large living room, recreation room with attached bath, which can be used as additional bedroom in addition to two other BRS with new Baths. The picturesque village of Irvington offers great restaurants, sought-after schools as well as a quick and efficient ride (40 minutes) on Metro North to NYC and close to all major Highways and Parkways.. Please verify taxes and SQFT before inspection or contract. Taxes do not reflect the star exemption.

ML# :3584094   New To Market! 2 Family Home, Prime Location, 7 Bedrooms, 5 Bathrooms, Finished Basement, Spacious Yard. Close to Schools, Shopping, Railroad, Beaches and Houses of Worship.

ML# :H6331803   LOCATION! LOCATION! LOCATION! INVESTOR’S DELIGHT! Conveniently located near #2, 5, & 6 subway train, at the intersection of Bronx River pkwy, Bruckner & Sheridan Expwy. 4 family house in a most rapidly changing market in the Bronx. Most apartments were renovated in 2021. Large apartments, highly potential to convert more bedrooms and make more money. Current rent roll is only $6, 816 per month. Potential to rent as much as $12, 000 per month. Fully occupied. No lease. THE HOUSE WILL NOT DELIVER VACANT. DO NOT DISTURB TENANTS! Also, FOR SALE, 1034 Longfellow Ave. R7-1 zoning. Let’s make a package deal!

ML# :3583921   Center Hall Colonial 5 Bedrooms, 3 Baths, Eat-In Kitchen Center Island, Ss Appliances, Quartz Counters, Oak Hardwood Floors, Crown Moldings, Box Panels Flr/Fdr, Hallway, Family Rm W/Gas Frplc, Primary Suite W/Designer Bath/Soaking Tub & Walk-In Closet, Addt’l 4 Large Br’s, (5th Br/Office Ground Flr. 2-Zn Gas Heat/Central AC, Front In-Ground Sprinklers, Unfinished Basement, Massapequa, SD #23 Minutes to LIRR, Town Shopping, Town Parks. Taxes to be determined. Buyer responsible for transfer tax, water hook up, final survey.

ML# :H6331716   LOCATION! LOCATION! LOCATION! INVESTOR’S DELIGHT! Conveniently located near #2, 5, & 6 subway train, at the intersection of Bronx River pkwy, Bruckner & Sheridan Expwy. 4 family house in a most rapidly changing market in the Bronx. Most apartments were renovated in 2021. Large apartments, highly potential to convert more bedrooms and make more money. Current rent roll is only $7, 150 per month. Potential to collect rent as much as $12, 000 per month. Fully occupied. No lease. THE HOUSE WILL NOT DELIVER VACANT. DO NOT DISTURB TENANTS! Also, FOR SALE, 1036 Longfellow Ave. R7-1 zoning. Let’s make a package deal!

ML# :3583446   Unlock endless possibilities with this prime investment property in the heart of Kew Garden Hills. Whether you live in the 3 bedroom 2 bath expansive suite or rent out the 1 bedroom apartment below, this flexible 2 family floor plan is perfect for end-users and investors alike. Beautiful modern open concept on the first floor with a chef’s kitchen with custom flat panel cabinetry and quartz waterfall countertops. Enclosed sun room bathe in natural sunlight with access to a private backyard. 3 spacious bedrooms with 2 full baths in the second level. The primary bedroom consist of a modern en-suite with a custom walk in closet. The walk-in 1 bedroom apartment features a contemporary floorplan with an open modern kitchen with a built-in fireplace, extensive bedroom with a new full bath with a 2 way shower system, access also to the private backyard. Radiant heated floors, ductless split systems, and plenty of storage throughout. This highly sought after location offers convenience and comfort with access to all major highways, buses including the Q44, Q46, Q25, Q20A, close distance to shopping, supermarkets and a diverse selection of restaurants in the neighborhood.

ML# :3582608   Brick six Family. Well kept building not neglected. $107058 gross yearly income $8, 921 monthly. taxes $11, 844 electric $711 gas heat and hot water $5, 357 water and sewer $7, 710 insurance $6, 900.