ML# :884482   Escape to your own private retreat on this expansive 45-acre property in scenic Mongaup Valley, NY. Tucked away on a quiet road, this unique multi-building offering includes a charming 3-bedroom, 2-bath split-level home, detached garage, and a bonus outbuilding perfect for storing ATVs, snowmobiles, and all your outdoor gear.The main home offers a warm, inviting interior with spacious living areas and plenty of natural light. Step out onto the generous deck—an ideal space for entertaining, dining under the stars, or simply enjoying the peaceful surroundings.Out back, you’ll discover a thoughtfully placed platform for camping, glamping, or tenting—perfect for creating unforgettable outdoor experiences with family and friends. Whether you’re hosting a weekend getaway or just taking time to reconnect with nature, this property is built for recreation, relaxation, and year-round enjoyment.Located just minutes from Bethel Woods Center for the Arts, White Lake, and the Delaware River, this area offers endless opportunities for boating, hiking, kayaking, fishing, and taking in live music and local events. Enjoy nearby restaurants, farmer’s markets, and the rustic charm of the Catskills, all while being just two hours from NYC.Whether you’re looking for a full-time residence, weekend escape, or a property with room to grow, 670 Creamery Rd offers a rare blend of space, serenity, and adventure.

ML# :890810   Exceptional Opportunity to Own a Multi-Family Property.Don’t miss this rare opportunity to acquire a well-maintained corner multi-family property in the desirable West Farms neighborhood of the Bronx. This spacious residence offers flexibility for extended family living or rental income potential.The primary unit is a generous duplex featuring four well-sized bedrooms, one full bathroom, and a half bath. It includes a dedicated laundry room, a private office space, spacious dining room area and direct access to both the driveway and backyard—ideal for convenience and outdoor enjoyment.The second unit offers two comfortable bedrooms and a full bathroom, making it perfect for rental income or extended family accommodations. Both units provide ample closet space throughout.Conveniently located near major highways, public transportation, hospitals, shopping centers, the Bronx Zoo, and more—this property combines accessibility with comfortable urban living.PLEASE NOTE All Showings are by appointment Only and 24 hr. advance notice. Send Pre Approval Letter/Proof of Funds prior to appointment confirmation to brenda.melendez@randrealty.com. Showings from 12:00pm-6:00pm Daily. Listing Agent will provide access.

ML# :886727   Welcome to Sunny View Condominium, a boutique residential gem in the heart of Sunnyside, where modern design meets timeless sophistication.Thoughtfully crafted to enhance both form and function, residence 3A offers a seamless blend of comfort, style, and convenience. A split bedroom layout optimizes and maximizes space for living. The West-facing exposure offers an abundance of natural light and afternoon warmth enjoyed through expansive floor-to-ceiling windows.Designed for effortless living, the airy interiors feature high ceilings, central heating and cooling, and a private outdoor space, perfect for relaxation or entertaining. Smart home conveniences include an in-unit washer/dryer and an Akuvox intercom system, ensuring both practicality and security.The kitchen is a statement of elegance and efficiency, appointed with striking Gold Calacatta Quartz countertops and backsplash. A full suite of Samsung appliances offers premium functionality, while the modern design provides a refined aesthetic that seamlessly integrates into the home’s open-concept layout.The bathrooms are designed with relaxation in mind, complete with a luxurious rain shower in one, and a deep soaking tub in the primary, and radiant heated flooring in both. Meticulous attention to details, such as glass paneled shower doors and uniformed tiling throughout, create a spa-like ambiance.Beyond the private sanctuary, entertain on an expansive common rooftop terrace with sweeping views. Additional building amenities include a bike room, laundry room and virtual doorman, all modern conveniences of a lifestyle of ease at Sunny View.Situated in the heart of Sunnyside, Sunny View is surrounded by shopping and dining. Everything you need are just moments from your doorstep, from banks and supermarkets to the 7 train for an effortless commute to Manhattan and beyond.Experience a rare blend of contemporary elegance and urban convenience—schedule a viewing today!

ML# :882902   Discover the pinnacle of sophisticated living in this exquisite high-rise condo located in the vibrant heart of White Plains. This residence boasts 2 bedrooms and 2.5 bathrooms, offering an abundance of natural light and spectacular views. Experience unrivaled luxury with top-of-the-line appliances and ample closet space within a building that features five-star amenities such as a 24-hour concierge, lounge, media room, conference rooms, indoor pool, fitness center, and an on-site spa and salon. Perfectly positioned amidst shopping and dining options with an easy commute to NYC, this condo is ideal for discerning individuals seeking convenience and elegance. Elevate your lifestyle today by making this exceptional property your new home.

ML# :883093   Welcome to this charming brick two-family home, perfectly situated on a 53 by 100 R5-zoned lot. Listed at $925, 000, this property offers incredible potential and versatility. While it does need a bit of TLC and isn’t move-in ready, it presents a fantastic opportunity to customize and add value. Whether you’re looking to invest or create your dream home, this gem is a must-see

ML# :881541   Exceptional opportunity to create your dream home in one of Jackson Heights’ most iconic prewar co-ops. This grand 3-bedroom, 2-bathroom, Chateau apartment features a welcoming entry foyer, spacious living room with fireplace, formal dining room, hardwood floors, and an eat-in kitchen with dishwasher. The primary bedroom offers an en-suite bathroom and overlooks a beautifully landscaped private garden. While in excellent condition, both bathrooms and kitchen offer a blank canvas for your personal touch. Designed by Andrew J. Thomas in the 1920s, The Chateau is known for its limestone façade, slate mansard roofs, and English-style garden that spans nearly a full city block. A rare find in the Jackson Heights historic district.

ML# :877893   Turn-of-the-century duplex located directly across from SUNY New Paltz in the heart of the village—an exceptional opportunity to own a high-performing, income-generating property in one of the Hudson Valley’s most sought-after locations. This beautifully maintained home features a spacious two bedroom apartment on the first floor, currently listed at 2, 500/month, and six individual bedrooms upstairs, each rented at 905/month, (including al utilities) sharing two full bathrooms and a well-appointed kitchen—ideal for student housing or co-living. Perfect as a turnkey investment or potential owner-occupied residence with strong supplemental income. Tenants enjoy shared coin-operated laundry in the basement and limited off-street parking. A two-story garage offers significant potential for future expansion, studio space, or additional revenue. Perfectly positioned within walking distance to restaurants, coffee shops, boutiques, world-class dining, and the vibrant arts and culture scene of New Paltz, with easy access to NYC, Mohonk Preserve, and the Shawangunk Mountains. Rarely does a property offering this level of location, character, flexibility, and income potential come to market.

ML# :857263   Well maintained 2 Family corner home in the heart of Ozone Park. Conveniently various public transportation options, Subway A train station nearby, J & Z train. Providing easy access to Manhattan and other parts of the City. The location also poximity to shopping centers, restaurant, park, etc... 1st floor Kitchen, Larger living room, 2 bedroom, bath 2nd floor Kitchen, Living room, eat-in kitchen, 3 bedroom bath. basement with separate entrance. 5 parking space. Building size 25x37. Property tax $3796. Lot size 50x40

ML# :820212   This 3Brs/2Baths Colonial with it’s original charm located in a prime location of Rye. Very close to Marinas, Shore clubs, LI Sound, Rye Town, Summer Camps, Oakland Beach and Pool, Shopping, Restaurants, walking Trails, Rye Golf Course, and close to the Train Station for easy commune to NYC. Home is equiped with C/Vac and Generac generator and the attached Greehouse is a gardner’s dream. Also the French door off the Dining room offer easy access to the Sunroom, deck, and the level backyard for year round grilling. Flood insurance is required, please verify taxes and SQFT. Additional Information: ParkingFeatures:1 Car Attached and two cars additional parkings. Price reduced to under Million for immediate sale.

ML# :839337   Welcome to 43 Van Nostrand Avenue, a charming 3-bedroom, 2-bathroom home nestled in the heart of Great Neck, NY. This beautifully maintained property features an updated interior with two full bathrooms, offering both comfort and style. The spacious full basement provides ample storage space or the potential for additional living areas to suit your needs.Situated on a generous lot that backs up to the serene Kings Point Park, you’ll enjoy direct access to peaceful nature views right in your own backyard. Zoned for JFK Elementary, Great Neck North Middle School, and Great Neck North High School. Great Neck Park District access.Don’t miss this wonderful opportunity to own a home in one of Great Neck’s most desirable neighborhoods. With its prime location, updated features, and proximity to parks, schools, and places of worship, 43 Van Nostrand Avenue is the perfect place to call home!