242 Geneva Church RD, De Queen, AR 71832

Welcome to a rare opportunity to own a fully equipped country estate that blends luxury living with unmatched functionality on 34.77 acres. This 3,344 sq ft home offers 3 bedrooms, 2.5 baths, plus a dedicated office that can easily serve as a 4th bedroom.

Inside, you'll find rich hickory floors, custom cabinetry throughout, detailed crown molding, and a spacious open layout designed for both everyday living and entertaining. The kitchen is built to perform, featuring a commercial-grade gas range with griddle and double convection ovens, built-in refrigerator/freezer, nugget ice maker, trash compactor, and custom hickory cabinets with quartz countertops.

A large island with prep sink and seating for six flows seamlessly into the main living space, complete with a custom-built entertainment center. The private primary suite offers a true retreat with an oversized clawfoot tub, large walk-in shower, and a custom walk-in closet with built-ins.

The property itself separates from anything else on the market. Enjoy a screened 20x20 porch with pellet stove, TV, and custom vinyl curtains, plus a flagstone patio with covered pergola, gas and electric hookups, and multiple entertaining spaces. The backyard is built for resort-style living with an 18x36 inground pool, cabana with bathroom and outdoor shower, and hot tub-all overlooking your private acreage.

Also includes: Covered and lighted pickleball court (also doubles as RV parking with hookups) 30x40 workshop with side shed Hay barn and additional storage structures Stalled barn with wash bay, feed room, fans, and hot/cold water Covered dog kennel with run Additional features include a heated and cooled 3-car garage, whole-home generator system, 3-zone HVAC, central vacuum, recirculating hot water, and irrigation system.

With approximately 18 acres of timber and wide-open usable land, this property offers the perfect balance of privacy, recreation, and functionality-all in one place.