Don’t miss this rare opportunity to own your slice of lakefront paradise! Escape the hustle and find serenity at this semi-secluded lakefront home, nestled on nearly 3 wooded acres in beautiful Foxboro. This unique home offers stunning views of a 27-acre private lake – ideal for fishing, swimming, kayaking, or simply relaxing and enjoying nature. With the potential for 3 bedrooms and 3 bathrooms, this home features: A striking stone fireplace, Gorgeous hardwood floors, Partial walkout basement with fireplace, upstairs loft with 2 bedrooms and rustic charm with opportunity to renovate
While the home needs some TLC, it’s being sold AS IS and presents an incredible opportunity to restore it to its original beauty. Whether you're seeking a weekend escape or a peaceful full-time residence, this property offers endless sunset views and the peaceful lake lifestyle you’ve been dreaming of. (New roof will be installed before closing, home does need new HVAC system, basement bathroom remodeled, drywall repair in bsmt and updates) HOA does not allow short term rentals/interior pics coming soon
Active
$229,900
210 Foxboro Rd, Gerald, MO 63037
3beds
1,952sqft
Est.:
Single Family Residence
Built in 1981
2.8 Acres Lot
$320,700 Zestimate®
$118/sqft
$50/mo HOA
What's special
Stone fireplaceGorgeous hardwood floorsRustic charmSemi-secluded lakefront home
- 2 days
- on Zillow |
- 1,429 |
- 114 |
Likely to sell faster than
Zillow last checked: 7 hours ago
Listing updated: August 23, 2025 at 12:38pm
Listing Provided by:
Stacee M Busenhart 314-606-5585,
Koehn, REALTORS
Source: MARIS,MLS#: 25053686
Originating MLS: Franklin County Board of REALTORS

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
- Main level bathrooms: 1
- Main level bedrooms: 1
Heating
- Forced Air, Wood
Cooling
- Attic Fan, Ceiling Fan(s), Dual
Appliances
- Included: Cooktop, Dishwasher, Refrigerator
- Laundry: In Basement
Features
- Flooring: Hardwood
- Doors: Sliding Doors
- Windows: Wood Frames
- Basement: Crawl Space,Partial,Walk-Out Access
- Number of fireplaces: 2
- Fireplace features: Basement, Living Room
Interior area
- Total interior livable area: 1,952 sqft
- Finished area above ground: 1,952
Property
Parking
- Parking features: No Garage
Accessibility
- Accessibility features: Accessible Entrance
Features
- Levels: One and One Half
- Patio & porch: Covered, Deck, Patio, Wrap Around
- Exterior features: Balcony, Dock
- Waterfront features: Waterfront, Lake Front, Lake Privileges
Lot
- Size: 2.8 Acres
- Features: Secluded, Waterfront, Wooded
Details
- Parcel number: 2561400001033000
- Special conditions: Listing As Is
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Rustic
- Property subtype: Single Family Residence
- Attached to another structure: Yes
Materials
- Other
- Roof: Architectural Shingle
Condition
- Fixer
- New construction: No
- Year built: 1981
Utilities & green energy
- Electric: 220 Volts
- Sewer: Septic Tank
- Water: Community
- Utilities for property: Cable Available, Phone Available, Sewer Connected, Underground Utilities, Water Connected
Community & HOA
Community
- Subdivision: Foxboro
HOA
- Has HOA: Yes
- Amenities included: Common Ground, Lake
- Services included: Maintenance Parking/Roads, Common Area Maintenance
- HOA fee: $600 annually
- HOA name: Foxboro
Location
- Region: Gerald
Financial & listing details
- Price per square foot: $118/sqft
- Tax assessed value: $259,660
- Annual tax amount: $2,721
- Date on market: 8/23/2025
- Listing terms: Cash,Conventional
- Ownership: Private
- Road surface type: Chip And Seal
- Loading
- Loading