Luxury homes for sale & real estate in Madison County, NY

Luxury Home for sale in Madison County, NY:

Rare mixed-use property now available in Schuyler! This income-producing property includes the well-known Papa Charlie’s Country Barbeque & Ice Cream along with 14 apartment units, all situated on approximately 2 acres in a prime location along State Route 5. This property offers multiple streams of income with a fully operational restaurant and residential units already in place — making it an ideal opportunity for investors or owner-operators looking to step into an established business. The restaurant is currently owner-operated and has built a strong local presence, while the apartments provide consistent rental income. Whether you’re looking to expand your portf

Luxury Home for sale in Madison County, NY:

An Extraordinary Private Estate on 70+ Pristine Acres More than a home—this is a lifestyle. Set amid 70+ pristine acres, this exceptional 4,000+ sq. ft. brick ranch offers an extraordinary combination of privacy, craftsmanship, comfort, and versatility. From the moment you arrive, the setting makes a statement. Expansive grounds, beautiful countryside, a private pond, and fenced acreage create a peaceful estate setting with endless possibilities for gardens, animals, recreation, or simply enjoying the luxury of space and privacy. Inside, quality is evident throughout. Hardwood floors and heated tile floors complement spacious, beautifully designed living areas. The impressive kitch

Luxury Home for sale in Madison County, NY:

Discover an extraordinary 7000+square foot estate offering space, luxury, and amenities rarely found in one property. This impressive home is set on 29 beautiful acres and offers an exceptional lifestyle both inside and out. Step into the dramatic two-story foyer and take in the elegance of the home featuring beautiful hardwood floors, glass doors, a private office, formal dining, and inviting morning room. The spacious large kitchen opens to a spectacular great room and family room, creating the perfect setting for everyday living and entertaining. There is a two sided stair case or take the elevator to the next level. This home offers four generously sized bedrooms with two having a jack

Luxury Home for sale in Madison County, NY:

3 solid brick buildings built in the 1990s, containing 25 apartments for sale. 13 units are 2 bedrooms 1 bath each. 12 units are 1 bedroom 1 bath each. Cold water and heat included in rent. Tenants pay electricity. 2 paved parking lots with EV charging station. Property spans almost an entire block. Please see marketing brochure for more information. Listing includes the following properties: 1. 312 Blandina Street, Utica, NY 13501 (Tax Map# 318.59-3-10) 15 Units 2. 310 Blandina Street, Utica, NY 13501 (Tax Map# 318.59-3-9) 3. 314 Blandina Street, Utica, NY 13501 (Tax Map# 318.59-3-11) 4. 308 Blandina Street, Utica, NY 13501 (Tax Map # 318.59-3-8) 5. 316-322

Luxury Home for sale in Madison County, NY:

3 solid brick buildings built in the 1990s, containing 25 apartments for sale. 13 units are 2 bedrooms 1 bath each. 12 units are 1 bedroom 1 bath each. Cold water and heat included in rent. Tenants pay electricity. 2 paved parking lots with EV charging station. Property spans almost an entire block. Please see marketing brochure for more information. Listing includes the following properties: 1. 312 Blandina Street, Utica, NY 13501 (Tax Map# 318.59-3-10) 15 Units 2. 310 Blandina Street, Utica, NY 13501 (Tax Map# 318.59-3-9) 3. 314 Blandina Street, Utica, NY 13501 (Tax Map# 318.59-3-11) 4. 308 Blandina Street, Utica, NY 13501 (Tax Map # 318.59-3-8) 5. 316-322

Luxury Home for sale in Madison County, NY:

Enduring design, exceptional craftsmanship, and abundant grandeur define this distinguished estate at the top of Shalimar Way. Brick pillars frame the newly paved circular driveway while a pristine paver walkway, meticulously maintained landscaping, and classic fencing surround the 12,438-square-foot brick residence with heated five-car garage, set on 2.61 acres. The grand main entrance opens to a two-story foyer with marble floors, a walk-in coat closet, and an elegant guest bath. The foyer leads to a formal living room and dining room on either side, both featuring exquisite crystal chandeliers and marble wood-burning fireplaces. The first floor also offers a comfortable sitting room and