Rand Realty Open Houses

$775,000 (USD)
Active

Ulster Area Multi-Family Home

Active

2096 Ulster Lake Katrine, NY 12449

4 Bed
0 Baths
3216 sqft
MLS# 20263172
Opportunity Knocks! This fully renovated triplex offers a rare combination of quality craftsmanship, energy efficiency, and strong income potential. Major upgrades include brand-new central heating and air conditioning systems, hot water heaters, updated electrical and plumbing, a new roof, and newly paved driveway and parking areas. The property has also been extensively enhanced with 6-inch spray foam insulation throughout the building and attached garage, improving energy efficiency while creating the potential for additional rental income through valuable storage space. A newly installed sprinkler system provides an added layer of safety and peace of mind. Each unit features a private entrance, offering convenience and privacy for tenants. The first-floor unit provides generous living space and a spacious bedroom. The second-floor unit includes one bedroom plus a dedicated office, ideal for remote work or additional living flexibility. Unit 3 is the standout feature of the property. Upon entry, you'll find a full apartment, complemented by a stunning staircase leading to a third-floor loft area. This unique space includes a second full bathroom, wet bar, large gathering room, and a separate office, creating an exceptional living environment. Ideally located between Kingston and Saugerties, with convenient access to the New York State Thruway, this property enjoys a highly desirable setting. Outdoor enthusiasts will appreciate its proximity to Windham Mountain Club, Hunter Mountain, and Mohonk Mountain, as well as the renowned HITS Hudson Valley Horse Show Series. Exceptional craftsmanship and quality finishes throughout provide years of low-maintenance ownership. With an attractive cap rate and extensive renovations already completed, this turnkey investment property is ready to generate income from day one!
Listing by: Hudson Valley Catskills MLS / Listed By: Amie Durham, Howard Hanna | Rand Realty
$729,000 (USD)
Active

Par-Troy Hills Twp Area Townhouse

Active

209 Raymound Boulevard Par-Troy Hills Twp., NJ 07054

3 Bed
3 Baths
sqft
MLS# 26025084
Welcome to one of the largest 3-bedroom townhomes model in the sought-after Mazdabrook community! Beautifully maintained and thoughtfully designed, this spacious 3-bedroom, 2.5-bath end-unit offers the perfect blend of comfort, style, and convenience all with low maintenance fees of just $116/month. The generous living room features a cozy gas fireplace perfect for relaxing evenings and sliding glass doors to a private rear deck, ideal for grilling or entertaining. An elegant dining room, framed by a wide cased opening, provides the perfect setting for intimate dinners or lively gatherings. The well-appointed kitchen boasts custom cabinetry, abundant counter space, stainless steel appliances, and a center island for both function and style. A convenient powder room completes the first floor. Upstairs, the serene primary suite offers a walk-in closet and private en suite bath. Two additional oversized bedrooms and a full hall bath complete the second level. The full, unfinished walkout basement provides laundry, storage, and endless potential for future living space. Enjoy the ease of an attached garage plus ample driveway parking. The Mazdabrook community enhances your lifestyle with tennis courts and beautifully landscaped grounds all just minutes from NYC transportation, shopping, and dining.This rare, oversized end-unit delivers the best of townhouse living: more space than most 3-bedroom models.
Listing Courtesy of NJMLS / Listed By: Hassan Gebril, Howard Hanna | Rand Realty
$729,000 (USD)
Active

Parsippany-Troy Hills Twp Area Townhome

Active

209 Raymound Blvd Parsippany-Troy Hills Twp., NJ 07054

3 Bed
3 Baths
sqft
MLS# 4038615
Welcome to one of the largest 3-bedroom townhomes model in the sought-after Mazdabrook community! Beautifully maintained and thoughtfully designed, this spacious 3-bedroom, 2.5-bath end-unit offers the perfect blend of comfort, style, and convenience all with low maintenance fees of just $116/month. The generous living room features a cozy gas fireplace perfect for relaxing evenings and sliding glass doors to a private rear deck, ideal for grilling or entertaining. An elegant dining room, framed by a wide cased opening, provides the perfect setting for intimate dinners or lively gatherings. The well-appointed kitchen boasts custom cabinetry, abundant counter space, stainless steel appliances, and a center island for both function and style. A convenient powder room completes the first floor. Upstairs, the serene primary suite offers a walk-in closet and private en suite bath. Two additional oversized bedrooms and a full hall bath complete the second level. The full, unfinished walkout basement provides laundry, storage, and endless potential for future living space. Enjoy the ease of an attached garage plus ample driveway parking. The Mazdabrook community enhances your lifestyle with tennis courts and beautifully landscaped grounds all just minutes from NYC transportation, shopping, and dining.This rare, oversized end-unit delivers the best of townhouse living: more space than most 3-bedroom models.
Listing Courtesy of GARDEN STATE MLS - IDX / Listed By: Hassan Gebril, Howard Hanna | Rand Realty
$664,900 (USD)
Active

City Of Kingston Area Single Family Home

Active

154 Marius Kingston, NY 12401

4 Bed
2 Baths
2259 sqft
MLS# 20262912
Never before on the market! This 1965 classic, original owner Center Hall Colonial, set on a rare 1.6 wooded acres in the heart of Kingston, ideally situated midway between the vibrant Uptown Stockade District and Downtown waterfront amenities, is an untouched gem awaiting the perfect stewards to usher it into contemporary life.
The spacious 2,259 square foot, 2-story home offers an eat-in kitchen, 2 full baths, 4 generous sized bedrooms, and original hardwood floors (up and down) and slate tiled entry hall.
One of the highlights of the home is its spectacular sunroom (added in 1980), with cathedral ceilings, floor to ceiling windows, an easy service pass-through window from the kitchen, and sliding glass doors that open onto a large deck overlooking the private wooded setting. An exterior staircase leads from the deck to the lower level drive (suitable for ample parking), the attached 1-car garage, and a small patio area.
A separate, finished basement recreation room, with access to the ground level patio, is anchored by a cozy wood burning fireplace - perfect for a work from home office and relaxing year-round. Also located on the lower level (below the sunroom) is an additional work/storage space that has great potential as a workshop, wine cellar, or gardeners area.
Additional features include a mini-split in the kitchen, a whole house fan in the attic, and a 5,000 watt Generac generator (2023).
A rare opportunity to enjoy a charming living space in a serene wooded setting, with a central Kingston location adjacent to the popular rail trail and within walking distance of Kingston's wide selection of shops, restaurants, and historic sites.
Listing by: Hudson Valley Catskills MLS / Listed By: Mark Haldeman, Howard Hanna | Rand Realty
$664,900 (USD)
Active

Kingston Area Single Family Home

Active

154 Marius Street Kingston, NY 12401

3 Bed
2 Baths
2259 sqft
MLS# 1012143
Never before on the market! This 1965 classic, original owner Center Hall Colonial, set on a rare 1.6 wooded acres in the heart of Kingston, ideally situated midway between the vibrant Uptown Stockade District and Downtown waterfront amenities, is an untouched gem awaiting the perfect stewards to usher it into contemporary life. The spacious 2,259 square foot, 2-story home offers an eat-in kitchen, 2 full baths, 4 generous sized bedrooms, and original hardwood floors (up and down) and slate tiled entry hall. One of the highlights of the home is its spectacular sunroom (added in 1980), with cathedral ceilings, floor to ceiling windows, an easy service pass-through window from the kitchen, and sliding glass doors that open onto a large deck overlooking the private wooded setting. An exterior staircase leads from the deck to the lower level drive (suitable for ample parking), the attached 1-car garage, and a small patio area. A separate, finished basement recreation room, with access to the ground level patio, is anchored by a cozy wood burning fireplace - perfect for a work from home office and relaxing year-round. Also located on the lower level (below the sunroom) is an additional work/storage space that has great potential as a workshop, wine cellar, or gardeners area. Additional features include a mini-split in the kitchen, a whole house fan in the attic, and a 5,000 watt Generac generator (2023). A rare opportunity to enjoy a charming living space in a serene wooded setting, with a central Kingston location adjacent to the popular rail trail and within walking distance of Kingston's wide selection of shops, restaurants, and historic sites.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Mark Haldeman, Howard Hanna | Rand Realty
$599,000 (USD)
Active

Stony Point Area Single Family Home

Active

9 Walter Drive Stony Point, NY 10980

4 Bed
2 Baths
1592 sqft
MLS# 1000773
Welcome home... MAJOR UPDATES include a young roof, newer forced-air heating and central air system, upgraded 200-amp electric service, and a 2021 water softener offering peace of mind for years to come. Set on just shy of an acre of gorgeous level, parklike property, this spacious 4-bedroom, 2 full bath Cape offers the space, layout, and outdoor lifestyle you have been searching for.

Inside, you’ll find a beautifully updated kitchen featuring refreshed cabinetry and an inviting layout ideal for everyday living and entertaining alike. The first floor has been freshly painted in modern neutral tones, creating a bright, warm, move-in-ready feel throughout. With 2 generously sized bedrooms on the main level and 2 additional oversized bedrooms upstairs, this flexible layout accommodates extended family, guests, home office space, or multigenerational living with ease.

The partially finished basement offers endless potential. Perfect for a future family room, gym, playroom, media space, or additional entertaining area ready for your personal finishing touches.

Step outside onto the expansive Trex deck overlooking the stunning backyard oasis, a truly special outdoor setting with room to entertain, garden, play, or simply unwind. Two oversized cement pads create the ultimate setup for outdoor grilling stations or summer gatherings.

A rare combination of property, updates, and flexible living space this is the kind of home you have been waiting for.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Brenda Santos, Howard Hanna | Rand Realty