ML# :863903   Over 20 sprawling acres with serene life, pond frontage, this is a true sanctuary. Located in Monroe-Woodbury this unique property offer two distinct residences and a spacious barn, providing endless possibilities. House 1: Contemporary Modern originally built in 1965. The first home boasts a generous 3, 500+ sq ft of premium living space. Designed with a flexible layout, the home features two equipped kitchens and two living rooms. The gourmet kitchens are adorned with high-end stainless steel appliances and beautiful quartz countertops. Showcasing high ceilings and an open-concept design, the space flows with natural light and fluidity. Five bedrooms and 4.5 bathrooms provide ample space. The main bedroom suite is complete with an en-suite bath and walk-in closet. A perfect mother daughter living space. Also includes a 2-car attached garage, private laundry room, and central air conditioning. House 2: Vintage Colonial Farmhouse - the second residence can be a charming 2, 700sq ft, 1900’s Colonial farmhouse sitting at the water’s edge. Comprising 4 bedrooms and 2 full bathrooms, this home radiates rustic charm. can be restored. All this and 20-acre landscape, complete with lush greenery and a pond. The substantial barns offer additional space for storage or a workshop. Embrace the rare opportunity to own a versatile estate property setting. perfect mini farm ..the setting is beautiful and yet not far from everything

ML# :823552   Exquisite Center Hall Colonial – Completely Renovated with Modern EleganceNestled in the heart of Little Town, this stunning Center Hall Colonial has been thoughtfully renovated to blend timeless charm with contemporary sophistication. Offering spacious interiors, high-end finishes, and exceptional craftsmanship, this home is the perfect retreat for modern living. Step through the welcoming entryway into a gracious Living Room featuring a wood-burning fireplace, ideal for cozy evenings. A Side Den provides a tranquil space for a home office or library. Designed for both everyday living and entertaining, the open-concept Dining Area flows seamlessly into the Chef’s Kitchen, which showcases a large center island with seating, premium stainless steel appliances and Quartz countertops and custom cabinetry. At the rear of the home, a sun-filled Family Room offers additional space to gather and relax, while a convenient half-bath completes the main level. The second floor boasts Two Bedrooms with ample closet space, a beautifully designed full hall bath and a luxurious Primary Suite, complete with a walk-in closet and spa-inspired en-suite bath. The third floor offers two additional rooms and a full bath, providing flexible space for guest accommodations, a home office, or a private retreat. The Fully Finished basement extends the home’s living space, featuring a playroom or recreation area, laundry room and utility area. There is an egress window for added safety. Exceptional Features & Thoughtful Details can be seen throughout the home, including hardwood floors and detailed molding enhance the refined aesthetic. Additional highlights include radiant heat flooring in all bathrooms for ultimate comfort and a fire sprinkler system for enhanced safety. Located near the charming streets of Little Town, this home is within close proximity to boutique shops, fine dining, parks, and top-rated schools (Wilson Elementary), offering a perfect blend of suburban tranquility and modern convenience.. This impeccably renovated Colonial is a rare opportunity to own a home that effortlessly combines elegance, comfort, and functionality. Schedule a private tour today to experience this remarkable residence firsthand.

ML# :901630   Stunning 2007 Construction Offering Spacious Living. This impressive multi-family home offers generous living space and versatile layouts, perfect for both end-users and investors.Unit 1 (Triplex): Spanning the basement, first floor, and half of the second floor, this residence features 8 Rooms, 3 bedrooms, 3 full bathrooms. The layout is thoughtfully designed with ample space for comfortable living and entertaining. Unit 2 (Duplex): Occupying half of the second floor and the entire third floor, this apartment offers 5 rooms 3 bedrooms, 2 full bathroom, and 1 half bathroom.Additional highlights include a building size of 18 ft x 48.75 ft, totaling approximately 3, 510 sq. ft. of interior space (including a fully finished basement), a landscaped front garden with a perfect spot for barbecues and gatherings, and a driveway at the rear of the home. Convenient Location: Public transportation is right at your doorstep with the Q38, Q54, and Q67 buses directly in front of the home, and the M Train at Middle Village – Metropolitan Ave station just one and half block away. Nearby amenities include BJ’s Wholesale Club, Amazon DYN3, Metro Mall, and FitNation Health Club, all within a block for everyday convenience.This property is a rare opportunity to own a spacious multi-family home with great income potential in a desirable location.

ML# :H6335262   The Best of Both Worlds — You Can Have It All.Whether you’re looking to escape from the city or escape to the city, this extraordinary Piermont home offers both. A rare blend of peace, beauty, and convenience, it’s a place where nature, culture, and connection meet—just minutes from Manhattan yet a world away in spirit.Convenience & Accessibility:Only 15 miles from NYC, you can drive, Uber, or take the bus and be home before sunset. In Piermont, the city feels close enough to touch—without ever intruding on your serenity.Peace & Extraordinary Beauty:Perched on the edge of the Piermont Marsh, this waterfront retreat offers sweeping, protected views of Tallman Mountain State Park and the peaceful marshland sanctuary. From every window, you’re surrounded by water, light, and the tranquil rhythms of nature.Walkability & Lifestyle:No car required—simply stroll into Piermont Village for cafés, fine dining, galleries, boutique shopping, and the year-round Farmers Market. Walk the Piermont Pier, hike or bike Tallman’s trails, or launch your kayak from your private dock and paddle through peaceful marshlands straight into the Hudson.Inside, this 1, 795-square-foot home combines architectural warmth and modern function. Soaring cathedral ceilings, radiant heat, and sunlight pouring through skylights create an inviting, uplifting atmosphere. Custom millwork by a master craftsman, two built-in home offices, and a residential elevator reflect thoughtful design. Energy-efficient supplemental solar power adds comfort and sustainability.Outdoor living is an everyday luxury with two expansive decks, a screened-in porch, outdoor shower, and a private dock with boathouse—your gateway to the Hudson.Truly one-of-a-kind, this home brings together what so many dream of: serenity, sophistication, and connection—all in one remarkable riverfront setting.

ML# :889134   Exceptional solid brick home nestled in a desirable location of Middle Village.Currently being used as a 1 family but has CO as a 2 family. Modern open floor plan drenched in natural sunlight with southeast exposures. Expansive living room with a dining area and a bistro/kitchenette connecting to your dream chef’s kitchen. Designer appliances, Subzero Refrigerator, double oven, electric/gas dual stoves, beverage fridge, commercial grade exhaust, custom cabinets with plenty of storage. Minimalistic design with floating stairs within a 4 Bedrooms 3.5 Bath Triplex with 2 balconies, primary bedroom with an en-suite, double sinks, and spa-like steam shower, a full recreational basement with high ceilings, and laundry area. Central air and heating, designer custom bathrooms with high-end digital shower controls, double sink vanities, recessed lighting, and customs doors throughout.If you decide you’d like to convert this home back into a 2 family, a private studio w/ an en-suite bath and access from the side of the home connects seamlessly to the main property ideal for in-laws, live-in Au Pair, or rent for additional income. Solid, custom-built brick home with nothing overlooked. Extremely durable and efficient clay tile roofs, pavers, custom blinds, solid made to order interior and exterior doors, efficient tank-less water heater, upgraded electric and plumbing throughout.Middle Village is a beautiful community located in central Queens in close proximity to Juniper Valley Park, shops, restaurants, and access to transportation to Manhattan and all major highways.

ML# :912407   Welcome to the Largest & One Of A Kind investment property in the parameters of Cambria Heights/ Laurelton and Valley Stream, New York! The Building footprint alone is 75 feet by 24 feet (plus a garage!). 1st Floor residence alone has 1, 800 square feet! 2nd floor almost as large with a almost 400 square foot private roof deck. This expansive 8-bedroom, 4-full bathroom multi-family property offers exceptional flexibility for both homeowners and investors. Currently configured as a legal 2-family, the layout and space allow for possible conversion to a legal 3-family residence , maximizing income potential. Home was recently GUT renovated. Step inside to find well-maintained interiors, generous living spaces, and a full finished basement with 2 separate entrances. The home also includes a private garage and driveway, providing coveted off-street parking as also a carport for up to 3 more cars. Conveniently located near shopping, schools, houses of worship, major highway, airport and public transportation. This property is perfect for multi-generational living or generating strong rental returns. Don’t miss this versatile property—whether you’re looking to invest or call it home, this is a rare find and will never see one like this again!

ML# :811266   111 West 132nd StreetOwner says sell! Significant price adjustment - now $1, 545, 000, delivered vacant! The current price is $655, 000 below the original ask. Contact Harlem Lofts Inc for your private showing!This lovely Queen Anne townhouse has a storied history. In the early part of the 20th Century it was the clubhouse for The Frogs, one of the first professional organizations for Black theater professionals. Subsequently, (and per the current Certificate of Occupancy) it has been used as a Church (plus Two Class A Apartments). The new Owner will have a straightforward roadmap for conversion to a Residential (1 or 2 Family) or Rental Investment (3+ Family) Certificate of Occupancy in an ideal location on a leafy street in Upper Manhattan.Built in 1886 by renowned architects Cleverdon and Putzel, this gorgeous limestone and slate townhouse is located in one of the most sought-after Historic Districts in Central Harlem. The boiler and hot water heater are both brand new. There is a Community Garden across the street in front, and a Church in back, both between 70 and 90 feet wide, and so the house benefits from unobstructed light all day long.This lovely property is just a few steps from Harlem’s Restaurant Row and shopping and entertainment on 125th Street, and it is also conveniently close to transportation options including the 2/3 and B/C subway lines and the M2, M7 and M102 bus lines. For recreation, the house is just a short walk from St. Nicholas Park and Mount Morris Park.This is a wonderful opportunity for an investor, with minimal risk and maximum potential. Contact Harlem Lofts today for additional details and your private tour!

ML# :823391   Just Updated in 2025 – Welcome to 69 Woodward Street, Roslyn Heights!This beautifully refreshed high ranch is full of charm, natural light, and versatility—perfect for today’s modern lifestyle, with the potential for a mother/daughter setup (permits required).Offering 5 bedrooms and 3 full bathrooms, this spacious home spans two thoughtfully designed levels. The entry level includes a bright living/dining area with backyard access, two bedrooms, a full bath, laundry room, and convenient garage entry—ideal for extended family, guests, or private living quarters.Upstairs, you’ll love the open-concept kitchen with sleek 2025 updates, stainless steel appliances, and plenty of sunlight streaming in. Hardwood floors run throughout the upper-level living and dining area, creating a warm and welcoming atmosphere. The primary suite features a private full bath and ample closet space, while two additional bedrooms and another updated full bath complete the floor.Whether you’re looking for flexible living options or a spacious layout to grow into, this home offers it all.Located in the sought-after Roslyn School District, and close to transportation, parks, shops, and restaurants—69 Woodward Street is a must-see!

ML# :3569448   Immediate occupancy available in The Rose at Great Neck. 40-New Luxury Condominiums on the North Shore of Long Island. This brand new boutique mid-rise building is now over 40% sold out. Offering an unparalleled luxury residential experience and amenities including virtual doorman services, welcome lobby, resident lounge with YouTube TV, plus gym fitness center with treadmill, bike and free weights. Retreat to the rooftop common area and hang out at the perfect place to unwind with seating and enjoy the outdoors that include distant views towards New York City. Private indoor garage parking and outside private lot parking. The earliest residents have preferred choice of parking spaces. The allure of The Rose extends beyond its walls as residents enjoy instant access to the Village of Great Neck Estates Waterfront Park featuring Olympic sized swimming pool plus small pool, 7 tennis courts plus indoor tennis court in a bubble, marina and dock area, direct waterfront esplanade with views of Little Neck Bay, Douglas Manor and the Throgs Neck Bridge, Whitestone Bridge, shoreline access, baseball and soccer fields, playground, basketball, pickle ball, handball courts and snack bar. The Rose was creatively designed by famed architects Mojo Stumer with the very best of quality and modern sophistication. Exterior brick and metal panels accent the solid structure. Three floors high with a mix of 1 bedroom, 2 bedroom and 3 bedroom options in this new building. Unit 203 is an end corner unit, two bedrooms and two baths, approximately 1, 403 sqft, private laundry. Big windows in the condo bring in natural light. Sleek modern kitchens to spacious living areas and stunning bathrooms, every aspect of this building reflects a commitment to luxury and comfort. Various golf courses within close proximity and nearby to the famous Americana Manhasset shopping. Just 0.7 miles to the Great Neck LIRR train station that boasts a direct route to Penn Station and now Grand Central Station in Manhattan. Enjoy the suburban lifestyle at the pinnacle of luxury living in Great Neck with all its town amenities just 19 miles to midtown Manhattan and a short jaunt to international airports. Welcome home.

ML# :917209   Welcome to 1180 Sherman Avenue, a fully renovated four-family property in the heart of the Concourse. This rare investment opportunity combines modern living with strong rental performance and the long-term upside of R7-1 zoning for future development. Each of the four updated two-bedroom, one-bathroom units is thoughtfully designed with contemporary finishes, including stainless steel appliances, grey quartz countertops, flint grey cabinetry, hardwood floors, and open-concept layouts that maximize space and light. The generously sized bedrooms easily accommodate queen beds with ample closet space, while the updated bathrooms complete the stylish aesthetic.Beyond the interiors, the property offers valuable amenities, including private parking, a full basement with storage and a laundry room, and efficient electric baseboard heating. Its location is equally compelling—just steps from the 167th Street subway station, providing a convenient 30-minute commute to Manhattan, along with proximity to major highways, Starbucks, shopping, and both casual and fine dining.From an investment perspective, the numbers are highly attractive. At an asking price of $1, 525, 000, the property generates $138, 480 in gross annual income and incurs estimated yearly expenses of $23, 685, resulting in a net operating income of approximately $ 114, 795. This produces a cap rate of roughly 7.5% on an all-cash basis. For those using financing, a 25% down payment with a 6% interest rate and 30-year amortization yields a cash-on-cash return of approximately 8.6%.Whether you are seeking immediate rental income with strong returns or looking to capitalize on future redevelopment potential, 1180 Sherman Avenue offers an exceptional opportunity in one of the Bronx’s most dynamic and accessible neighborhoods.