This 34.77-acre country estate combines luxury living with exceptional functionality. The 3,344 sq ft home features 3 bedrooms, 2.5 baths, and an office that can serve as a 4th bedroom. Interior highlights include hickory floors, custom cabinetry, crown molding, and an open layout ideal for entertaining. The kitchen is fully equipped with a commercial-grade gas range, double ovens, built-in fridge/freezer, nugget ice maker, quartz countertops, and a large island. The primary suite offers a spa-like retreat with a clawfoot tub, walk-in shower, and custom closet. Outdoor living shines with a screened porch, pellet stove, flagstone patio, pergola, and multiple entertaining areas. A resort-style backyard includes an inground pool, cabana with bath and outdoor shower, and hot tub. Additional amenities include a pickleball court/RV space, workshop, barns, dog kennel, 3-car garage, whole-home generator, and more. With wooded and open land, it offers privacy, recreation, and versatility.
Active
Price cut: $50K (7/9)
$1,049,000
242 Geneva Church Rd, De Queen, AR 71832
3beds
3,344sqft
Single Family Residence
Built in 2016
34.77 Acres Lot
$980,400 Zestimate®
$314/sqft
$-- HOA
What's special
Inground poolFlagstone patioHot tubWooded and open landCustom closetWalk-in showerPellet stove
- 157 days
- 131
- 3
Zillow last checked:
Listing updated:
Listed by:
Steven J Tidwell 479-806-4905,
Bradford & Udouj Realtors 479-646-5539
Source: CARMLS,MLS#: 26013895
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Rooms
- Room types: Formal Living Room, Den/Family Room, Office/Study, Sun Room, Workshop/Craft
Dining room
- Features: Separate Dining Room, Eat-in Kitchen, Separate Breakfast Rm
Heating
- Electric, Heat Pump
Cooling
- Electric
Appliances
- Included: Built-In Range, Double Oven, Gas Range, Dishwasher, Disposal, Trash Compactor, Refrigerator, Freezer, Ice Maker
- Laundry: Laundry Room
Features
- Pantry, Primary Bedroom/Main Lv, Guest Bedroom/Main Lv, Primary Bed. Sitting Area, 2 Bedrooms Same Level, 3 Bedrooms Same Level
- Flooring: Carpet, Wood, Tile
- Has fireplace: No
- Fireplace features: None
Interior area
- Total structure area: 3,344
- Total interior livable area: 3,344 sqft
Property
Parking
- Total spaces: 3
- Parking features: RV Access/Parking, Garage, Three Car
- Has garage: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Screened, Porch
- Exterior features: Rain Gutters, Tennis Court(s), Shop, Dog Run
- Has private pool: Yes
- Pool features: In Ground
- Has spa: Yes
- Spa features: Hot Tub/Spa
- Fencing: Partial
- Waterfront features: Creek
Lot
- Size: 34.77 Acres
- Dimensions: 1470 x 1019 x 1473 x 1019
- Features: Level, Rural Property, Wooded, Cleared, Extra Landscaping, Not in Subdivision, Lawn Sprinkler
Details
- Additional structures: Cabana/Pool House
- Parcel number: 00202349000
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Slab
- Roof: Shingle
Condition
- New construction: No
- Year built: 2016
Utilities & green energy
- Electric: Elec-Municipal (+Entergy)
- Gas: Gas-Propane/Butane
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Gas-Propane/Butane
Community & HOA
Community
- Subdivision: Metes & Bounds
HOA
- Has HOA: No
Location
- Region: De Queen
Financial & listing details
- Price per square foot: $314/sqft
- Tax assessed value: $325,700
- Annual tax amount: $2,184
- Date on market: 4/9/2026
- Road surface type: Gravel, Paved
Estimated market value
$980,400
$931,000 - $1.03M
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 7/9/2026 | Price change | $1,049,000-4.5%$314/sqft |
Source: Western River Valley BOR #1088284 Report a problem | ||
| 4/9/2026 | Listed for sale | $1,099,000+10.5%$329/sqft |
Source:  CARMLS #26013895 Report a problem | ||
| 1/5/2026 | Listing removed | $995,000$298/sqft |
Source: CARMLS #25032154 Report a problem | ||
| 8/12/2025 | Listed for sale | $995,000$298/sqft |
Source: CARMLS #25032154 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $1,577 +7.2% | $55,010 +10.5% |
| 2024 | $1,471 -4.9% | $49,800 |
| 2023 | $1,546 -3.1% | $49,800 |
| 2022 | $1,596 | $49,800 |
| 2021 | $1,596 | $49,800 |
| 2020 | $1,596 -0.2% | $49,800 -0.3% |
| 2019 | $1,598 -1.5% | $49,960 |
| 2018 | $1,623 +2234.2% | $49,960 +2385.6% |
| 2017 | $70 | $2,010 |
| 2016 | $70 | $2,010 |
| 2015 | $70 +12.9% | $2,010 +12.9% |
| 2014 | $62 +41.6% | $1,780 +41.6% |
| 2013 | $43 +7.7% | $1,257 +7.7% |
| 2012 | $40 | $1,167 |
| 2011 | $40 +8.4% | $1,167 +8.4% |
| 2010 | $37 +30.1% | $1,077 +30.1% |
| 2009 | $29 | $828 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 71832
Similar homes
- $579,0004 bd3 ba3.8k sqft104 Rhonda Dr, De Queen, AR 71832For Sale
MLS ID #26024324, Tara L Morphew, Tri-Lakes Realty. CARMLS - $675,0003 bd2 ba2.4k sqft374 Avon Rd, De Queen, AR 71832For Sale
MLS ID #11852412, Rachel Bradshaw, Smith and Mounts Inc.. My State MLS - $550,0004 bd2 ba2.6k sqft301 Story Creek Rd, De Queen, AR 71832For Sale
MLS ID #25039055, Luke Alston, SmallTown Hunting Properties & Real Estate. CARMLS - $850,0003 bd2 ba1.7k sqft343 Almond Rd, Gillham, AR 71841For Sale
MLS ID #59141, Will Beuck. REALSTACK
