Perfect for first-time buyers or those looking to downsize! This charming ranch-style home offers 3 bedrooms and 1 full bath on the main floor, with recent updates and low-maintenance luxury vinyl flooring throughout. The kitchen shines with a large pantry and stainless-steel appliances—all included! Downstairs, you'll find a finished lower level complete with a spacious family room, a second full bath, and a versatile office/media room or bonus space perfect for relaxing or entertaining. The oversized 2-car garage is a standout feature, boasting a custom workshop area and built-in shelving that stays with the home. Enjoy the outdoors in your easy-to-maintain, fenced backyard—featuring a patio, deck area, equipment shed, and even a basketball goal for fun and fitness. All kitchen appliances, washer, dryer, and garage refrigerator STAY! Home also features a 200-amp service panel, 50-gallon water heater, and a roof that's less than 10 years old! Don't miss this move-in ready gem! Showings start Friday, July 18th at 1:00 p.m.
Closed
Price Unknown
510 Olive St, New Haven, MO 63068
3beds
2,170sqft
Single Family Residence
Built in 1988
0.37 Acres Lot
$260,000 Zestimate®
$--/sqft
$1,891 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: August 22, 2025 at 11:26am
Listing Provided by:
Michelle A Otten 636-259-6289,
RE/MAX Today
Bought with:
Stacee M Busenhart, 2002029338
Koehn, REALTORS
Source: MARIS,MLS#: 25046089
Originating MLS: Franklin County Board of REALTORS

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 1
- Main level bedrooms: 3
Heating
- Forced Air
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Stainless Steel Appliance(s), Dishwasher, Microwave, Electric Oven, Electric Range, Refrigerator, Washer/Dryer
- Laundry: In Basement, Laundry Room, Lower Level
Features
- Ceiling Fan(s), Center Hall Floorplan, Eat-in Kitchen, High Speed Internet, Kitchen/Dining Room Combo, Pantry, Shower, Walk-In Closet(s), Workshop/Hobby Area
- Flooring: Vinyl
- Doors: Panel Door(s), Storm Door(s)
- Basement: Concrete,Finished,Full,Walk-Out Access
- Has fireplace: No
Interior area
- Total structure area: 2,170
- Total interior livable area: 2,170 sqft
- Finished area above ground: 1,170
- Finished area below ground: 1,000
Property
Parking
- Total spaces: 2
- Parking features: Garage, Garage Door Opener, Garage Faces Side
- Attached garage spaces: 2
Features
- Levels: One
- Patio & porch: Covered, Deck, Front Porch, Patio
- Exterior features: Basketball Court, Private Yard
- Fencing: Back Yard,Chain Link,Fenced
Lot
- Size: 0.37 Acres
- Features: Back Yard, City Lot, Front Yard, Level, Open Lot, Some Trees
Details
- Additional structures: Equipment Shed
- Parcel number: 0473500008021000
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Patio,Ranch,Traditional
- Property subtype: Single Family Residence
Materials
- Brick Veneer, Frame, Vinyl Siding
- Foundation: Permanent
- Roof: Architectural Shingle
Condition
- Updated/Remodeled
- New construction: No
- Year built: 1988
Utilities & green energy
- Electric: Ameren
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Electricity Connected, Sewer Connected, Water Connected
Community & neighborhood
Location
- Region: New Haven
- Subdivision: Trail Hill
Other
Other facts
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
- Ownership: Private
- Road surface type: Asphalt