ML# :931333   ** Attention To All The Investors, here is an Excellent Investment Opportunity for you! ** Legal, All-Brick 4 Family (R3-2 Zoning) situated on a 21’ x 181’ lot. The 1st and 2nd floor each features two (2) one (1) bedroom apartments, with a grand total of 2, 100 square feet of living space. (See the floor plan for the breakdown of each room). Each apartment has a Living Room/Dining Area, Kitchen, Bedroom and 1 Bath. The property is well maintained, has great interior natural light, hardwood floors throughout, and has a large unfinished basement, where the utility/mechanicals are located, and plenty of extra storage space. It’s central location offers convenient access to schools, parks, retail shopping, restaurants, public transportation and near major parkways. Don’t miss out on the incredible potential this property holds!

ML# :921963   Beautiful Split-Level Family Home on a Corner Lot - Move-In Ready!Welcome to this inviting and well-maintained split-level single-family home offering comfort, style, and functionality. Step inside to a bright living room featuring a cozy fireplace, creating a warm and welcoming space for gatherings. The open layout flows seamlessly into the dining area and modern kitchen, complete with granite countertops, marble tile flooring, quality cabinetry, and full utilities. From the kitchen, step right out onot your private deck - a perfect spot for morning coffee or weekend barbeques. The upper level features three spacious bedrooms, including a primary suite with its own private bath. Each bedroom is filled with natural light, large windows with blinds, and generous closet space. A second full bathroom serves the remaining bedrooms. An additional fourth bedroom on the next level provides extra flexibility - ideal for guests, a playroom, or a home office - with two closets for added storage. The lower level offers a comfortable family room with tile flooring, a powder room, and access to the attached garage. The finished basement includes a washer and dryer and offers space for recreation, a gym, or storage. Outside, enjoy a beautifully landscaped backyard featuring a paved patio area perfect for family gatherings and summer entertaining. THe corner lot provides added space, privacy, and great curb appeal. Conveniently located near parks, schools, shopping, and major highways, this home offers everything you need for easy, comfortable living. A wonderful opportunity to own a move-in ready home that truly has it all!

ML# :912330   **READY FOR IMMEDIATE OCCUPANCY!**One of Only 2 Top-Floor Homes Remaining – A Rare Waterfront Opportunity. Experience the epitome of luxury living at Unit 3C, a premier townhome-style condo at The Aristo, Astoria’s most coveted waterfront residence. Designed for both entertaining and relaxation, the expansive living space is enhanced by floor-to-ceiling sliding glass doors that seamlessly connect to your private balcony, where sweeping water and city views create a breathtaking backdrop.The chef’s kitchen is a true showpiece, featuring marble countertops and backsplash, custom cabinetry, and premium appliances including a Bertazzoni stove, Liebherr refrigerator, and dishwasher. Whether preparing a gourmet meal or hosting guests, this elegant space elevates every occasion.The serene primary bedroom offers a spacious closet, a spa-like en-suite bath with Porcelanosa tiles, and access to a private balcony for quiet mornings or evening relaxation. A generous second bedroom with ample closet space provides versatility for guests, a home office, or personal retreat.For the ultimate outdoor escape, ascend to your private 518 SF roof deck, a true urban sanctuary with panoramic city and waterfront views—perfect for sunset entertaining or peaceful solitude.Additional highlights include oak wood flooring, 8-foot doors, built-in Vessel Bluetooth speakers, Ring doorbell camera, Brinks security wiring, and washer/dryer hookup. Every detail balances modern convenience with timeless luxury.With on-site parking available (prewired for EV charging) and a beautifully designed common area, The Aristo combines sophistication with community. Its prime location provides effortless access to the N/W subway, while Astoria Park—with its expansive green spaces, pool, tennis courts, and waterfront trails—becomes your backyard retreat.The complete offering terms are in an offering plan available from sponsor. File No.CD24-0044. All measurements and dimensions are approximate and are subject to normal construction variances and tolerances and may vary from floor to floor. Sponsor reserves the right to make changes in accordance with the terms of the offering plan. All images are artist’s renderings for representational purposes only and are subject to variances. Though information is believed to be correct, it is presented subject to error, omissions, changes and withdrawal without notice. Equal Housing Opportunity.

ML# :911602   Perched above Kingston yet just steps from the city’s vibrant heart, this Art Deco–inspired residence is a rare fusion of glamour and nature. Set on 8.5 private acres with sweeping mountain vistas and a tranquil pond, the home feels worlds away while remaining walkable to uptown Kingston. Recently reimagined and meticulously renovated, it rises three levels with a striking mix of architectural drama and modern comfort—perfect for those seeking a one-of-a-kind escape without sacrificing convenience.Inside, the surprises are endless. A soaring two-sided stone fireplace anchors the main living space, where elegant dark hardwood floors meet walls of glass that open onto a broad deck with dramatic mountain views. The chef’s kitchen is as functional as it is stylish, outfitted with state-of-the-art stainless steel appliances, a breakfast bar, and an adjacent vaulted dining room framed by Venetian windows. Two deluxe bedroom suites—each with spa-like ensuite baths—offer private retreats, while flexible bonus rooms can transform into a home office, creative studio, or playroom.The property itself is no less impressive. Mature trees frame wide-open lawns and mountain views, creating an atmosphere of serenity and grandeur. From your deck you’ll hear the breeze, spot the pond glimmering in the distance, and still know that Kingston’s Rondout waterfront, Midtown arts scene, and the historic Stockade District are minutes away. With Woodstock, New Paltz, Rhinebeck, Mohonk, and the Catskills all within half an hour, this home is more than a residence—it’s a gateway to the best of the Hudson Valley.

ML# :932988   Welcome to 111 Farrington Ave! A beautiful 3 bedroom, 3 bathroom, single family home located in the desirable Hudson River neighborhood of Philipse Manor in Sleepy Hollow, New York. The tastefully updated home features high-end renovations throughout the entire 2, 360 square feet. Upon entering this beautiful home you will take note of the restored white oak hardwood flooring that runs throughout the entire first and second level of the property. To the left of the entranceway is a large living room with wood-burning fireplace featuring beautiful oversized windows that flood the South-facing home with natural light. Located just opposite the living room is a stunning modern kitchen that features quartz countertops, European style acrylic cabinets, Bespoke glass appliances and large-format tile flooring. The eat-in kitchen is spacious with counter stool seating making it a perfect spot for morning breakfast or coffee. An added bonus space just off the kitchen is a lovely covered balcony perfect for grilling or just relaxing outside in the peaceful tranquility of Philipse Manor. Located conveniently beside the kitchen through a charming pocketdoor is a spacious formal dining room perfect for hosting meals. A couple of steps up from the main living area you will find the bedroom level with 3 spacious bedrooms and 2 full bathrooms. The primary bedroom features 2 closets (one of which is a large walk-in closet) and ensuite bathroom with a floating vanity, standing shower, and tasteful finishes. Inside the walk-in closet there are pull-down stairs that lead to a full-sized attic, perfect for all of your storage needs. Down the hall you will find 2 more spacious bedrooms and an entire hallway of closets. Each bedroom easily fits a queen bed and has its own spacious closet. At the end of the hall is a renovated bathroom with deep soaking tub, shower, and detailed tile work. Located on the lower level, you will find some of the best features this property has to offer. This incredible space is defined by high ceilings over 9’, custom built cabinetry, and recessed lighting. There is large bonus room with ensuite bathroom that would be perfect as an home office, exercise space, or however you can imagine. The lower level features sliding glass doors that lead to a covered patio and spacious backyard, perfect for alfresco dining. There is a large mechanical room off the lower level that features a workshop and laundry space with additional storage closets and direct access to the attached 2-car garage. While this home is truly something incredible, we invite you to explore the surrounding neighborhood of Philipse Manor. This home is just a short stroll to the Philipse Manor train station (just a 42 minute express commute to Grand Central Station), the Old Croton Aqueduct Trail (a 41-mile trailway popular with runners), the newly built Hudson Riverwalk, Rockefeller State Park Preserve, and Main Street Tarrytown for all your shopping and dining needs. We invite you to join the Philipse Manor Beach and Boat Club exclusive for residents of Philipse Manor. This community is truly something special, between the proximity to Midtown Manhattan and the peaceful tranquility of the Hudson River. Reach out to Brian Ippoliti today, this one won’t last long!

ML# :929467   Built in 2013, this meticulously maintained 2 Family house with legal basement for commercial use offers the perfect blend of comfort, functionality, and investment potential. Featuring 1, 500 sq. ft. of commercial space with walkout access to a spacious backyard, the lower level provides versatile options for business use or additional rental income. Each of the two upper-floor apartments offers 2 bedrooms, 1 bathroom, and abundant natural light thanks to the desirable southern exposure. Units are in excellent condition and benefit from separate meters and boilers, ensuring independent utilities and cost control. Additional highlights include a private driveway with parking for 2+ cars and a large backyard ideal for relaxation or entertaining. Centrally located near highways, public transportation, and shopping, this property offers unmatched convenience for both residents and businesses. Whether you’re an investor or an owner-occupant, this Whitestone mixed-use home is a rare opportunity that’s ready to impress.

ML# :928141   Welcome to Your Dream Home—Luxury Living in One of Long Island’s Most Exclusive Gated Golf & Country Club Communities. Special Bonus: the sellers are paying the first year of the mandatory social membership fees.Discover the perfect blend of refined elegance, modern comfort, and resort-style living in this meticulously renovated residence. Set within a prestigious gated enclave, this home offers an unparalleled lifestyle complemented by world-class amenities.Residents enjoy access to a championship golf course, tennis and pickleball courts, a brand-new state-of-the-art fitness center, heated pool with cabana bar, on-site gourmet restaurant, wine cellar, fire pit lounge, card room, and more. Membership includes Invited Club privileges, granting national discounts and access to premier clubs across the country.Step inside to experience sophistication at every turn. A grand entryway with soaring ceilings welcomes you into a sun-drenched formal living room that flows seamlessly into the formal dining area—perfect for entertaining. The open-concept chef’s kitchen is the heart of the home, showcasing custom cabinetry, high-end finishes, and an adjoining den with a new gas fireplace and custom built-ins, creating a warm and inviting atmosphere.Upstairs, you’ll find three spacious bedrooms and a versatile loft, ideal for a home office, lounge, or playroom. The oversized primary suite offers serene golf course views, dual entry closets, and a spa-inspired en-suite bath complete with a jetted tub, separate walk-in shower, and expansive vanity.The lower level provides exceptional flexibility.Step outside into your private backyard oasis, featuring a hot tub and gazebo—perfect for relaxing or entertaining year-round.Recent upgrades include: New roof, New windows and doors, New custom kitchen and updated bathrooms, New gas fireplace with custom built-ins in the den, New hot tub and gazebo, and Electric car charger.This is more than a home—it’s a lifestyle. Enjoy resort-style living every day, whether you’re hitting the course, relaxing poolside, or dining with friends at the club.Welcome to your forever home—where luxury and leisure live in perfect harmony.

ML# :919705   Welcome to this beautifully maintained home featuring a spacious 476 sq ft sunroom with direct access from both the living room and family room—ideal for year-round enjoyment. Recent updates include new central air unit (2022) and all new water systems in the basement. The family room boasts a classic wood-burning fireplace, perfect for cozy evenings. Enjoy a formal dining room and an eat-in kitchen, great for everyday living and entertaining. A generous deck overlooks a large backyard, providing ample space for outdoor relaxation. Conveniently located near Metro-North and the towns of Chappaqua and Armonk, this home blends comfort, convenience, and charm.

ML# :923423   Don’t miss this terrific opportunity to own a solid two-family brick home located in a desirable and convenient neighborhood. This well-maintained property features spacious layouts on each level, making it ideal for investors, end users, or extended families. The home includes a private driveway, offering the convenience of off-street parking — a rare find in this area.Whether you’re looking to generate rental income or live comfortably while tenants help pay the mortgage, this property offers endless potential. Perfectly situated near transportation, shopping, schools, and parks, it combines value, location, and opportunity all in one. Schedule your private tour today and see why this Curzon Road home is an excellent investment and a place to call home.

ML# :895952   SEARINGTOWN Nestled on an oversized, tree-lined corner lot in the heart of Searingtown, this beautifully updated brick and siding split-level home offers style, space, and comfort. Thoughtfully renovated with attention to detail, the open-concept main floor effortlessly blends the living room, dining room, and kitchen—ideal for entertaining and everyday living. This sun-filled residence features 3 bedrooms and 2.5 baths, including a spacious primary suite with a private en suite bath. The lower-level family room is a warm and inviting retreat, showcasing a charming exposed brick fireplace, sliding glass doors to the backyard patio, and a convenient powder room. A basement level provides flexibility with office space, a recreation room, laundry, built-ins, and utilities. Highlights include: solar panels, Andersen windows, natural gas heating, central air conditioning, LED lighting, built-in speakers, gleaming hardwood and porcelain tile floors, marble-updated bathrooms, and more!!