Modern Farmhouse on Horse Property in Warren, Utah This beautifully remodeled 3-bedroom, 1-bath home blends modern farmhouse style with peaceful small-town living. Set on a spacious horse property, it offers room to spread out while still feeling cozy and welcoming. Enjoy a shaded backyard perfect for relaxing, a 2-car garage, and plenty of space for animals, hobbies, or outdoor fun. Inside, you'll find fresh updates with a clean, stylish feel - ideal for anyone looking for a move-in-ready home with character. If you're dreaming of rural charm with modern comfort, this one's for you.
Accepting backups
Price cut: $9.1K (8/7)
$459,900
1797 N 5900 W, Ogden, UT 84404
3beds
1,638sqft
Est.:
Single Family Residence
Built in 1945
0.65 Acres Lot
$450,400 Zestimate®
$281/sqft
$-- HOA
What's special
Spacious horse propertyShaded backyardMove-in-ready homeFresh updatesClean stylish feel
- 84 days
- on Zillow |
- 514 |
- 12 |
Zillow last checked: 7 hours ago
Listing updated: August 19, 2025 at 08:58pm
Listed by:
Sadie L Scheffler 801-864-7343,
KW Success Keller Williams Realty,
Trevor Scheffler 801-690-5832,
KW Success Keller Williams Realty
Source: UtahRealEstate.com,MLS#: 2090453

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 1
- Full bathrooms: 1
- Main level bedrooms: 3
Heating
- Forced Air, Central
Cooling
- Central Air
Features
- Flooring: Carpet
- Windows: None
- Basement: None
- Has fireplace: No
Interior area
- Total structure area: 1,638
- Total interior livable area: 1,638 sqft
- Finished area above ground: 1,638
Property
Parking
- Total spaces: 2
- Parking features: RV Access/Parking
- Garage spaces: 2
Features
- Stories: 1
Lot
- Size: 0.65 Acres
- Residential vegetation: Mature Trees
Details
- Parcel number: 100280043
- Zoning description: Single-Family
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Rambler/Ranch
- Property subtype: Single Family Residence
Materials
- Brick
- Roof: Asphalt
Condition
- Blt./Standing
- New construction: No
- Year built: 1945
Utilities & green energy
- Utilities for property: Natural Gas Connected, Electricity Connected, Sewer Connected, Water Connected
Community & HOA
HOA
- Has HOA: No
Location
- Region: Ogden
Financial & listing details
- Price per square foot: $281/sqft
- Tax assessed value: $441,000
- Annual tax amount: $2,969
- Date on market: 6/6/2025
- Listing terms: Cash,Conventional,FHA,VA Loan
- Acres allowed for irrigation: 0
- Electric utility on property: Yes
- Loading