My Company's Active Listings

$829,900 (USD)
Active

Marlborough Area Single Family Home

Active

29 Orchard View Marlboro, NY 12542

4 Bed
3 Baths
3384 sqft
MLS# 20261103
This is not your cookie cutter colonial. This exceptional custom home was built in 2020 and they spared no expense. Modern design, superior construction, and Hudson Valley lifestyle come together seamlessly. Thoughtfully crafted with insulated concrete form (ICF) construction, this home offers outstanding energy efficiency, durability, sound insulation, healthy living and long-term value. From the moment you arrive, you will notice pride of ownership. The covered front porch and beautifully maintained landscaping is just the beginning of this special property. Step inside to a welcoming yet impressive foyer that sets the tone for the thoughtfully designed interior. The chef's kitchen and open concept living spaces are truly the heart of the home, perfectly designed for both everyday living and entertaining. The kitchen features quartz countertops, an oversized island, coffee bar, wine fridge, outfitted pantry, and Café Series appliances. The adjoining living room centers around a gas fireplace, while large sliding doors lead to the back deck, creating seamless indoor-outdoor flow for hosting and gatherings. Two stylish and convenient dining spaces offer practical options. A main-level office provides an ideal space for working from home or quiet study. Upstairs, four bedrooms offer comfortable accommodations, including the impressive primary suite featuring a spa-inspired ensuite with freestanding soaking tub, large tiled shower, double vanity, and spacious walk-in closet. A convenient second-floor laundry room and additional full bathroom complete the level. The full basement with an additional garage bay offers excellent space for hobbies, storage, or outdoor equipment. Outside, the park-like backyard invites you to enjoy every season with a fenced yard, retention pond, and pickleball court. Set on 1.9 acres at the end of a quiet cul-de-sac, this property offers privacy while remaining close to the region's renowned apple orchards, wineries, farm markets, and outdoor recreation, with easy access to the Hudson River and all that the Hudson Valley lifestyle is known for. A truly luxurious take on Upstate living.
Listing by: Hudson Valley Catskills MLS / Howard Hanna | Rand Realty / Danielle Bartula
$825,000 (USD)
Active

Cottekill Area Single Family Home

Active

374 Marcott Road Cottekill, NY 12419

4 Bed
4 Baths
2704 sqft
MLS# 980386
Experience a private Hudson Valley estate where farmhouse chic meets SoHo inspired edge. Enjoy refined country living blended with sophistication & serene natural beauty on 3 secluded acres. Designed for both comfort and elevated entertaining, this 4 bedroom, 3.5 bath home offers a seamless fusion of modern design and timeless character. The light filled open concept living and kitchen area creates an elegant yet inviting space for gatherings. The full floor primary suite serves as a true haven, while the lower level provides endless flexibility for a home gym, media room or private guest accommodations. Outdoors the property reveals an inviting private sanctuary. Lush manicured grounds are layered with mature perennial plantings, creating texture, color and privacy throughout the seasons. A sweeping wraparound porch invites peaceful afternoons and seamless entertaining in a serene setting. Equestrian and lifestyle amenities are beautifully integrated into the landscape with discretion and intention. A well designed barn with two stalls, wet stall, tack room, and hay loft is complemented by fenced paddocks and a run in shed. A nearby duck pond offers a rare blend of beauty and function with an enclosed kennel area. Bordering the scenic O&W trail, the property provides direct access to miles of riding and cycling through some of the regions most picturesque terrain. Perfectly positioned just minutes from vibrant enclaves of Rosendale, Kingston, and Saugerties known for their acclaimed history, dining, galleries, and boutiques. This home offers both complete privacy and effortless accessibility, with the NYS Thruway nearby. A rare offering where design, land and lifestyle converge with quiet distinction.
Listing by: ONEKEY as distributed by MLS GRID / Howard Hanna | Rand Realty / Jennifer Loprieno
$825,000 (USD)
Pending

Yorktown Heights Area Single Family Home

Pending

271 Colonel Greene Road Yorktown Heights, NY 10598

4 Bed
3 Baths
2900 sqft
MLS# 960547
Some homes have a layout. This one has a story.

Set on a full private acre in Yorktown Heights, this beautifully updated 4-bedroom, 3-bathroom home is completely move-in ready — freshly renovated throughout with quality that shows the moment you walk in. The signature feature is a dramatic exposed stone wall that flows seamlessly from the outside in, giving the home a warmth and character that no new construction can replicate.

New hardwood floors run through every level. The kitchen has been fully updated with new cabinetry and new appliances including a new refrigerator and oven. Washer and dryer are included.

Here is how the home lives:

First floor — Your gathering space. A soaring living room anchored by a stone fireplace, a fully updated eat-in kitchen, a formal dining room, and a private guest suite with its own separate entrance. This suite is a genuine asset — use it as an in-law apartment, au pair quarters, a home office with independent client access, or simply the best guest room your family has ever had.

Second floor — Room to grow. Two bedrooms, a full bathroom, and a flexible playroom and dressing area. Perfect for kids, a home office, or a creative studio.

Third floor — Your retreat. An entire level dedicated exclusively to the primary suite. Quiet, private, and completely removed from the rest of the home.

Nearly 2,900 square feet — all above grade, no basement living. Mature landscaping, natural stonework throughout the grounds, and the kind of privacy that is increasingly hard to find this close to the Taconic Parkway, top-rated Yorktown schools, shopping, and dining.

If you have been looking for something with real character, real space, and nothing left to do — this is it.
Listing by: ONEKEY as distributed by MLS GRID / Howard Hanna | Rand Realty / Klevis Tana