My Company's Active Listings

$520,000 (USD)
Active

Campbell Area Single Family Home

Active

5596 Mills Road Campbell, NY 14821

3 Bed
3.1 Baths
5106 sqft
MLS# R1679412
Nestled on 16 sprawling acres in Campbell, this custom-built country estate offers a masterclass in rustic elegance and thoughtful craftsmanship. Boasting over 5,000 sq ft of exquisite knotty pine finishes, the interior creates an immediate sense of warmth and grandeur with its soaring cathedral ceilings and gleaming hardwood floors. The heart of the home is designed for seamless entertaining, featuring a bar room situated perfectly between the living room and kitchen. This inviting space showcases a custom hand crafted log bar with matching stools, making it the ultimate hub for social gatherings. The layout includes 3 to 4 spacious bedrooms and 3 full bathrooms, highlighted by an owner’s suite that serves as a private sanctuary w/ a personal balcony overlooking the lush grounds. Every corner of this home reveals high-end details, from the custom log staircases to two built-in gun safes, with the unique opportunity to purchase the custom furniture to complete the home’s signature aesthetic.

The property is a dream for those who require ample space for vehicles & hobbies, offering an unparalleled seven garage bays. This includes a 3-car attached garage equipped with heat for year-round comfort, a 3-car detached garage, and an additional 1-car detached garage. The living space extends into a fully finished basement, providing massive additional square footage for a family room, home gym, or media center, all kept cozy by a brand-new propane furnace. Additionally, a versatile FROG offers a quiet retreat perfect for a home office, guest suite, or extra bedroom.

Outdoor living at this estate is a private resort experience blended with a sportsman’s paradise. The expansive 16-acre lot features road access all the way to the top of the property, making it ideal for hiking or hunting enthusiasts. Near the main residence, an expansive deck leads to a sparkling inground pool and a tranquil koi pond, while the surrounding landscape is both beautiful and bountiful. A meticulously tiered rock wall produces seasonal grapes, blueberries, and raspberries, adding a literal taste of the country life to this one-of-a-kind Campbell treasure.

Sq ftg per seller.
Listing by: NYS ALLIANCE / Listed By: Valerie Clark, Warren Real Estate
$515,000 (USD)
Active

Elmira Area Single Family Home

Active

1159 W Water Street Elmira, NY 14905

6 Bed
4.1 Baths
5533 sqft
MLS# R1686816
Welcome home to this sprawling, meticulously updated Colonial that perfectly blends luxury, scale, and multi-purpose living. Completely remodeled in 2022, the property boasts major capital upgrades including a brand-new roof, windows, and high-efficiency HVAC systems with central AC.

The main residence is defined by its soaring high ceilings and an expansive layout designed for both grand entertaining and quiet productivity. At the heart of the home is a true chef’s kitchen, fully equipped with a premium THOR range, a sleek French door refrigerator, and a massive walk-through butler's pantry. For formal gatherings, the elegant living room features a cozy wood-burning fireplace and opens directly into a sunlit three-seasons porch. Additional living spaces include a dedicated home office/study and a large secondary living room perfect for media or relaxation. Upstairs, you will find four bedrooms and three bathrooms, highlighted by a spacious owner’s suite with a spa-like soaking tub and walk-in shower, alongside a secondary guest suite complete with its own private bath.

Bridging the main home and the private living quarters is a bonus room currently utilized as a home gym, which features a secured door to maintain maximum privacy between the wings. The fully independent in-law suite—also beautifully remodeled in 2022—features two bedrooms, one full bathroom, and its own dedicated laundry room to mirror the main house's amenities. Engineered for true independence, the suite includes its own separate entrance, dedicated parking, and independent electrical service.

Situated on a generous, partially fenced corner lot, the exterior offers plenty of privacy and curb appeal, rounded out by a large storage shed at the rear of the property. This rare estate offers unparalleled versatility, modern luxury, and true dual-living capability.
Listing by: NYS ALLIANCE / Listed By: Valerie Clark, Warren Real Estate
$499,000 (USD)
Active

Ithaca Town Area Single Family Home

Active

135 Ridgecrest Road Ithaca Town, NY 14850

4 Bed
2 Baths
1914 sqft
MLS# R1695545
Experience the exceptional comfort in this beautifully updated 4-bedroom, 2-bath Cape Cod, perfectly situated on nearly three-quarters of an acre. Thoughtfully designed and impeccably maintained, this home offers a seamless blend of classic charm and modern convenience. Step inside to discover sun-drenched living spaces filled with natural light and a versatile floor plan featuring two spacious bedrooms on the main level, ideal for guests, multigenerational living, or a private home office. The beautifully updated kitchen serves as the heart of the home, offering a stylish and functional space for everyday living and entertaining. Outdoor living is equally impressive. A sprawling deck creates the perfect setting for summer barbecues, outdoor dining, and evenings spent with family and friends. Beyond the deck, your private backyard oasis awaits with a sparkling in-ground pool surrounded by expansive green space, offering the perfect escape for relaxation and recreation. Additional premium features include central air conditioning, efficient natural gas heating, municipal water, a brand-new furnace, and a new roof, providing comfort and peace of mind for years to come. The full walk-out basement offers endless possibilities for additional living space, a home gym, workshop, or recreation room, while the attached two-car garage provides convenience and ample storage. Located just moments from scenic walking trails, this exceptional property offers the rare opportunity to enjoy peaceful surroundings without sacrificing modern conveniences. Every detail has been thoughtfully updated, creating a home that is as inviting as it is impressive.

This is more than a home; it's a lifestyle.
Listing by: NYS ALLIANCE / Listed By: Andrew "Andy" Schreck, Warren Real Estate
$499,000 (USD)
Active

Horseheads Area Single Family Home

Active

3 Turnberry Drive Horseheads, NY 14845

4 Bed
3.1 Baths
3809 sqft
MLS# R1688977
From the moment you arrive you will notice the updates on this home which include a new roof in 2022 with transferable warranty, new engineered hardwood flooring and ceiling fans, Central A/C upstairs and mini splits on the main level, Trex Decking and exterior doors. New stainless steel appliances and new toilets in all bathrooms. Primary bath renovations included new shower and flooring!

Step inside to a breathtaking two-story foyer that opens to a spacious, light-filled layout designed for both everyday living and effortless entertaining.

The formal living and dining rooms offer timeless elegance, while the heart of the home — a beautifully appointed kitchen — features solid surface countertops, and a center island complete with a convenient bar sink. The adjacent gas fireplace creates a warm, inviting ambiance that makes every gathering feel special.

Upstairs, the oversized primary suite is a true retreat, boasting granite countertops. Two additional bedrooms share a thoughtfully designed Jack and Jill bathroom, keeping the upper level both functional and polished. Stunning tray ceilings add architectural charm that elevates the space.

The fully finished walkout basement expands your possibilities — whether you envision a fifth bedroom, home gym, or a recreation room, the space is ready to grow with you.

Additional highlights include first-floor laundry and a renovated half bath on the main level.

This is the one you’ve been waiting for — thoughtfully updated, move-in ready, and perfectly placed in Barrington Estates.
Listing by: NYS ALLIANCE / Listed By: Dawn Dimon, Warren Real Estate