My Company's Active Listings

$560,000 (USD)
Active

Middleburgh Area Single Family Home

Active

1499 Huntersland Road Middleburgh, NY 12122

5 Bed
3 Baths
4200 sqft
MLS# 202625648
Virtual Tour
Steeped in history and surrounded by nature's finest work, this magnificent 4,200-square-foot country property offers an unparalleled retreat on 38 acres in the hills of Middleburgh, Schoharie County. Perfectly positioned high above the Little Schoharie Creek, this unusual property blends a bygone era with a spectacular, private setting.
Spanning 4,200 square feet, the residence is adorned with original vintage floors, windows, and exquisite woodwork throughout.
• 5 spacious bedrooms and 3 full baths provide ample room for family and guests.
• The crown jewel of the home awaits on the second floor: an authentic ballroom, perfect for entertaining, an artist's studio, or a breathtaking primary suite.
The acreage is a true outdoor sanctuary, offering a dynamic landscape of rolling hills and historic stone walls that add timeless character to the grounds.
• Year-round waterfalls and a natural plunge pool carved into the stream offer an exclusive summer escape and a peaceful soundtrack.
• A generous screened back porch serves as your front-row seat to the changing seasons, overlooking the rushing creek from the fresh blooms of spring to the crisp beauty of winter.
While completely private, this estate keeps you effortlessly connected. The vibrant Village of Middleburgh is just 3.5 of a miles away, putting local restaurants, boutiques, the public library, and year-round community events right at your doorstep.
Listing by: GLOBAL MLS / Listed By: Ruth Anne Wilkinson, Century 21 North East
$559,900 (USD)
Active

Niagara Area Single Family Home

Active

3231-3233 Military Road Niagara, NY 14304

3 Bed
2.2 Baths
2538 sqft
MLS# B1688801
Welcome to this unique & versatile 1,878 sqft ranch home offering an exceptional location and lots of income potential. Situated on a highly visible main road, this residential home with attached storefront/income property features cathedral ceilings, 740 sqft, a half bathroom, an office, with separate utilities. This is a non-conforming use, providing a variety of potential opportunities. An attached storefront adds tremendous flexibility for a variety of permitted uses, rental income, hobby space, workshop needs, or additional storage.

Designed with accessibility in mind, the home offers a handicap-accessible entrance complete with a ramp in the garage & easy one-floor living. All doors are 36 inches wide. Parking lot can fit up to 5 cars without interfering with garage.

Inside, you’ll find cathedral ceilings, custom cabinetry throughout, & a spacious layout featuring two separate living areas, perfect for entertaining or multi-purpose use. The inviting living room showcases a beautiful fireplace currently used as a wood-burning fireplace, with existing gas piping available should a future owner choose to convert it.

A formal dining room provides the perfect setting for gatherings and holiday meals. The primary suite offers a private retreat with an attached full bathroom and walk-in closet. Two additional bedrooms & a second full bathroom with a jetted tub complete the main level.

Additional features include an attached two-car garage, alarm system, updated mechanics, and abundant storage space throughout. A custom 8 ft wide sliding glass door leads to the rear deck overlooking a private wooded lot, creating a peaceful outdoor retreat.

The partially finished basement boasts impressive 8-foot ceilings, a brand-new half bath, a convenient 4 foot wide basement staircase, & endless possibilities for additional living space, recreation, or storage.

Combining comfort, accessibility, & the added benefit of an attached storefront, this one-of-a-kind property offers a rare opportunity for buyers seeking flexibility, convenience, and private, partially vinyl fenced in yard in a high traffic location. Newly assessed at $579,000 in 2025.
Listing by: NYS ALLIANCE / Listed By: Abigail Stein, Century 21 North East
$559,000 (USD)
Active

Schiller Park Area Multi-Family Home

Active

4829 Forster Avenue Schiller Park, IL 60176

4 Bed
3 Baths
sqft
MLS# 12730823
Rarely Available Residential 2 Opportunity on Three Lots! Welcome to this beautifully remodeled and thoughtfully updated property in Schiller Park, offering flexible living arrangements, income potential, and an expansive fenced yard. The main residence features 2 bedrooms and 1 bath, along with its own kitchen and comfortable living room. The upper-level offers an additional 2 bedrooms, 1 full bath, kitchen, and living room, providing excellent separation and privacy between spaces. The finished basement adds even more versatility with laundry facilities, 1/2 bath and an additional family room-perfect for recreation, entertaining, a home office, or extra living space. The property sits on three separate lots with three individual PINs, creating an exceptionally large fenced-in yard with plenty of room for outdoor activities, gardening, entertaining, or future possibilities. While there is no garage, the property offers three on-site parking spaces. The home has been fully remodeled and extensively updated since 2015, offering modern finishes and improvements throughout. Additional features include airport-certified windows and the convenience of the home being hardwired with CAT 6 Ethernet cable, making it ideal for today's connected lifestyle. A unique opportunity to own a versatile Residential 2 property with multiple living spaces, substantial land, parking, and extensive updates in a convenient Schiller Park location. Move-in ready and full of possibilities! Property is being sold AS IS. Agent is related to seller.
Listing Courtesy of Midwest Real Estate Data as distributed by MLS GRID / Listed By: Jennifer Weigand, Century 21 Integra
$555,000 (USD)
Pending

Apopka Area Single Family Home

Pending

1016 Lakeside Dr. Drive Apopka, FL 32712

4 Bed
3 Baths
3012 sqft
MLS# O6418091
Virtual Tour
Under contract-accepting backup offers. This lakefront home is in the BEST location in Apopka. The one-of-a-kind Wekiva Glen subdivision, with its single gated entrance, makes the perfect walking or bicycling neighborhood. This three story, traditional home on 1.58 acres has 4 bedrooms, 2½ baths, two fireplaces, shaded second and third floor decks for observing sunrises and frequent wildlife visitations, as well as a 700 sq ft finished walk-out basement onto a concrete patio, giving this house an estimated 3,012 sq ft of climate controlled comfort. The basement can be used for multiple purposes all at once, including a den, office, recreation room (or man cave), perpetually cool/dry storage, and storm shelter. Built in 1990, the shell of the house (excluding a portion of garage) from top down was replaced in 2009: 2 chimney caps, roof shingles, roof fall protection system, aluminum soffit / fascia, moisture barrier, new Hardie plank lap siding, new French doors, and new paint. The AC air handler and condenser unit was replaced in 2022. Cozy rooms define this house with a grand entry, staircase, vaulted living room ceiling and built-in cabinets in the family room and in one bedroom. Located on Lake Prevatt in the Wekiva State Park and within minutes of Downtown Orlando, International airport, toll road expressways, Atlantic cost beaches, shopping, hospitals, restaurants, as well as many other wildlife parks.
Listing Courtesy of STELLAR as distributed by MLS GRID / Listed By: Absolute Realty Group, LLC