Rare Two-Family Raised Ranch in Halcyon Park - Ideal for Extended Families or Rental Income.
Welcome to this exceptional raised ranch in desirable Halcyon Park—a rare legal two-family home offering versatility, space, and investment potential. Perfectly located near shopping, schools, and convenient bus transportation, this property is ideal for a large family or those seeking added income from rental opportunities.
The main level features an open-concept layout with 4 spacious bedrooms and 2 full bathrooms, including a primary suite. The cherry wood kitchen is beautifully appointed with Granite countertops, seamlessly flowing into a generous living and dining area. An additional great room with vaulted ceilings and French doors provides an impressive space for entertaining or relaxing.
The ground level offers 2 more bedrooms, a full bath, a second kitchen, and living room—complete with separate heating and electric, making it an ideal in-law suite or rental unit.
An expansive three-season room adds 700+ square feet of Extra space, perfect for a workshop, playroom, or lounge area, and connects to a large two-car garage. The home also includes a private backyard and a wide paved driveway with parking for multiple vehicles.
Whether you're looking for a multi-generational home or a smart investment, this rare find in Halcyon Park delivers space, flexibility, and long-term value.
Listing by: ULSTER / Howard Hanna | Rand Realty / Charlet Wenzel
$349,900
Cairo Area Single Family Home
Active
29 Jerome Cairo, NY 12413
4 Bed
2 Baths
1512 sqft
MLS# 20251791
This meticulously cared-for two-story home in the Village of Cairo blends comfort, flexibility, and charm—all within walking distance to coffee shops, restaurants, and everything town life offers.
Step inside and be welcomed by a bright, open-concept living, dining, and kitchen area. The updated kitchen features modern appliances and sliding glass doors that lead to a spacious deck—perfect for entertaining or relaxing outdoors.
The main level includes:
Two bedrooms (one currently used as an office/den)
A full bath
Seamless flow between rooms with plenty of natural light
Upstairs, you'll find:
Two more bedrooms
Another full bath
A versatile sitting area or second living room with direct access to a second upper deck
A large extra room, ideal for a studio, playroom, or creative space
Need more flexibility? This layout is perfect for a mother-daughter setup with minimal adjustments.
Additional features:
Above-ground pool
Walk-out basement with a pool/game room for the kids
Peaceful neighborhood with walkable access to local dining and shopping
Move-in ready, lovingly maintained, and full of possibilities—this is the kind of home that fits your lifestyle now and grows with you.
THIS IS IN A FLOOD ZONE
10 min off NYS thruway exit 21 and 30 Min to Windham Mt Skiing.
Listing by: ULSTER / Howard Hanna | Rand Realty / Charlet Wenzel
$309,900
Kingston Area Single Family Home
Active
28 Tietjen Kingston, NY 12401
4 Bed
2 Baths
2171 sqft
MLS# 20252929
Spacious 2-Story Home with Character & Room to Grow
Welcome to this generously sized two-story home, full of potential and ready for your personal touch. The first floor features a bright living room, formal dining room, a beautifully updated kitchen, and a full bath with a Jacuzzi tub. A large bedroom on this level makes hosting guests or extended family a breeze.
Upstairs opens to a roomy landing with a convenient washer and dryer setup, three spacious bedrooms, and a charming full bath complete with a classic clawfoot tub. The pull-down attic is finished—ideal for storage or extra space as needed.
Sitting on a large lot with space for gardening, play, and pets, this home offers endless possibilities for transformation. Bring your vision and make it your own.
Listing by: ULSTER / Howard Hanna | Rand Realty / Charlet Wenzel
$284,900
Saugerties Area Single Family Home
Pending
2 Plattekill Mt. Marion, NY 12456
3 Bed
1 Baths
925 sqft
MLS# 20251325
Welcome to easy, one-floor living in this well-maintained 3 bed, 1 bath ranch located in the desirable Mt. Marion Park neighborhood. The open-concept layout connects the living room and kitchen, creating a bright, airy space perfect for everyday living or entertaining.
Enjoy even more room to relax with the extra 3-season room, adding over 100 square feet of extra living space—ideal for morning coffee, hobbies, or hosting.
Recent updates give peace of mind and modern comfort:
New roof, furnace, and seamless gutters (2016)
New backyard shed (2017)
New hot water heater (2022)
Fresh flooring and paint (2023)
Outside, the fully fenced backyard is a private oasis with peach trees and raspberry bushes—ready for summer enjoyment.
A solid, move-in-ready home in a great location—this one won't last.
Listing by: ULSTER / Howard Hanna | Rand Realty / Charlet Wenzel
$199,900
Rochester Area Single Family Home
Active
514 Upper Cherrytown Kerhonkson, NY 12446
2 Bed
1 Baths
464 sqft
MLS# 20252401
Charming 3-Season Cottage — 2 Hours from NYC
Lovingly enjoyed by generations. This cozy two-bedroom, one-bath cottage is your perfect summer escape. Tucked along a quiet country road, it offers easy access to hiking trails, local farmers markets, and the best of upstate living.
Unwind on the enclosed porch as you listen to the gentle stream flowing through the backyard. Host family gatherings, grill under the trees, or explore the nearby outdoors.
The spacious shed out back comes with electricity and offers potential for a studio, guest space, or creative retreat.
Move-in ready and full of possibilities—your peaceful getaway is waiting.
Listing by: ULSTER / Howard Hanna | Rand Realty / Charlet Wenzel
$179,900
Deer Park Area Single Family Home
Pending
651 US Route 209 Deer Park, NY 11729
1 Bed
1 Baths
1624 sqft
MLS# 20250196
This rare and unique property offers a wealth of charm and history, perfect for those seeking a creative restoration project. Originally a church, it has been converted into a single-family home with a studio on the main level. The studio features a kitchen, a spacious bathroom, and plenty of possibilities.
Situated on a serene 0.50-acre lot, the property boasts a natural spring, a partially fenced yard, and plenty of room to enjoy the outdoors. Inside, you'll find original features that exude character, including large windows that flood the space with natural light, high ceilings, and wood floors. A balcony overlooks the main level, adding to the property's distinctive appeal.
Conveniently located near the Neversink Campgrounds, shopping, the NYS Rail Trail, and NYC railroad transportation, this property offers both charm and accessibility.
The owner notes that the property is grandfathered for mixed-use, opening up a world of possibilities. Whether you dream of a unique residence, a studio space, or something entirely different, this property is ready for your imagination to bring it to life!
Don't miss this extraordinary opportunity—schedule a viewing today!
Listing by: ULSTER / Howard Hanna | Rand Realty / Charlet Wenzel
$159,900
Esopus Area Manufactured Home
Active
14 Forest Port Ewen, NY 12466
3 Bed
2 Baths
1400 sqft
MLS# 20252590
Dutcher Mobile Home Park. Wonderful 1999 Champion Double Wide. Beautifully maintained. Open Concept Kitchen. Dining Room, Living Room, Primary Suite and much more. Roof is 6 years old.
Listing by: ULSTER / Howard Hanna | Rand Realty / Charlet Wenzel
$700 / mo
City Of Kingston Area Rental Property
Active
79-83 Green Kingston, NY 12401
0 Bed
1 Baths
200 sqft
MLS# 20244474
Uptown Kingston One Room Rentals, each comes with a Refrigerator & Microwave , Shared Bathroom. Application a must . No Pets.
Listing by: ULSTER / Howard Hanna | Rand Realty / Charlet Wenzel