224 S Monterey Farms Cv, Collierville, TN, 38017
About This Home
Majestically situated WaterFront and Water Back 2 acres with a 5800sf “WOW” house…because when someone sees it, that’s what they will say…”WOW”. Granite Kitchen overlooking adjacent Hearth Room has JennAir 6 Burner Gas + Grill, Stainless, Dbl Convections, Pot Filler, 28 Cabinets, 15 Drawers and a Wine/Beverage Room! Looking for both a Primary and 2nd Suite Down and a THIRD Suite up (plus 2 more BRs)…and, an Office Down? And Playroom AND Media/Theatre Room? This is it! But, you also get a Stay-cation upscale home with beautiful neutral finishes in the serene country, with no City Taxes. Walls of Windows across the rear of the house overlooking the park-like rear grounds and Gunite Poool (Water Back) & Vaulted/Covered Patio! Pond in front with Bream and 6 Turtles, and rooms and spaces for entertaining, guests or extended family. Unbelievable list of Features attached or in the house or I can email…
Getting Around
Car-Dependent
Very Limited Transit
Somewhat BikeableSchools
Construction
Condition
- New construction: Yes
- Year built: 2007
Materials
- Foundation: Slab
- Roof: Composition Shingles
- Construction materials: Brick Veneer,Stone
Other
- Builder name: Harrell Homes
Type & Style
- Home type: SingleFamily
- Architectural style: French,Traditional
- Property subType: Single Family Residence
Interior
Appliances
- Appliances included: Gas Water Heater,Dishwasher,Disposal,Double Oven,Microwave,Range/Oven
- Laundry features: Laundry Room
Bedroom2
- Features: Hardwood Floor,Private Full Bath,Smooth Ceiling,Walk-In Closet(s)
- Level: First
- Area: 168
Bedroom3
- Features: Carpet,Private Full Bath,Smooth Ceiling
- Level: Second
- Area: 182
Bedroom4
- Features: Carpet,Smooth Ceiling,Walk-In Closet(s)
- Level: Second
- Area: 196
Bedroom5
- Features: Carpet,Smooth Ceiling
- Level: Second
- Area: 204
Bedrooms & Bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Bonus Room
- Area: 420
Dining Room
- Features: Separate Dining Room
- Area: 234
Features
- 1 or More BR Down,Double Vanity Bath,Full Bath Down,Half Bath Down,Luxury Primary Bath,Primary Down,Separate Tub & Shower,High Ceilings,Smooth Ceiling,Two Story Foyer,Vaulted/Coff/Tray Ceiling,Powder/Dressing Room,2 or More Baths,2nd Bedroom,Breakfast Room,Dining Room,Keeping/Hearth Room,Kitchen,Laundry Room,Living Room,Office,Primary Bedroom,2 or More Baths,3rd Bedroom,4th or More Bedrooms,Media Room,Play Room/Rec Room,Storage,Square Feet Source: Appraisal
- Window features: Double Pane Windows,Wood Frames
- Flooring: Part Carpet,Part Hardwood,Tile
- Number of fireplaces: 2
- Fireplace features: Gas Log,In Keeping/Hearth room,Primary Bedroom
- Fireplace: Yes
Heating & Cooling
- Heating features: Central
- Cooling features: 220 Wiring,3 or More Systems,Ceiling Fan(s),Central Air
Interior Area
- Total interior livable area: 5,808 sqft
Kitchen
- Features: Keeping/Hearth Room,Separate Breakfast Room,Updated/Renovated Kitchen
- Area: 252
Living Room
- Features: Separate Living Room
- Area: 342
Master Bathroom
- Features: Double Vanity,Dressing Area,Separate Shower,Smooth Ceiling,Tile Floor,Whirlpool Tub,Full Bath
Master Bedroom
- Features: Hardwood Floor,Sitting Area,Smooth Ceiling,Walk-In Closet(s)
- Level: First
- Area: 360
Office
- Level: First
- Area: 99
Property
Details
- Parcel number: D0223Y A00027
Features
- Stories: 1
- Private pool: Yes
- Pool features: Pool Cleaning Equipment,In Ground
- Patio & porch: Patio,Covered Patio
- Exterior features: Auto Lawn Sprinkler
- Has spa: Yes
- Spa features: Whirlpool(s),Bath
- Waterfront features: Lake/Pond on Property
Lot
- Lot size: 2 Acres
- Features: Corner Lot,Landscaped,Some Trees
- Lot size dimensions: 87670 SF 281 x 334
Parking
- Total spaces: 3
- Parking features: Circular Driveway,Driveway/Pad,Garage Door Opener,Garage Faces Side
- Has garage: Yes
- Covered spaces: 3
- Has uncovered spaces: Yes
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Tornado
- Cold Wave
- Earthquake
- Heat Wave
- Inland Flooding
How This Home’s Risks Compare
FEMA Declared Disasters Across Tennessee Counties
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $4,930 | $59,160 |
| Home Insurance | $585 | $7,020 |
| Property Taxes | $788 | $9,456 |
| Electricity | $471 | $5,662 |
| Total | $6,774 | $81,288 |
Income You'd Need if You Spent...
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
Price History
| Date | Event | Price |
|---|---|---|
| 2026-04-27 | Listed for sale | $995,000 |
| 2026-01-10 | Listing removed | $1,024,000 |
| 2025-11-18 | Price change | $1,024,000 |
| 2025-11-13 | Price change | $1,049,000 |
| 2025-10-14 | Price change | $1,049,999 |
| 2025-09-19 | Price change | $1,059,000 |
| 2025-09-08 | Price change | $1,074,999 |
| 2025-08-21 | Listed for sale | $1,089,999 |
| 2024-04-26 | Sold | $1,001,000 |
| 2024-03-15 | Pending sale | $995,000 |
| 2024-03-15 | Contingent | $995,000 |
| 2024-03-08 | Listed for sale | $995,000 |
| 2021-06-09 | Sold | $899,900 |
| 2021-06-02 | Pending sale | $899,900 |
| 2021-05-07 | Listed for sale | $899,900 |
| 2021-03-24 | Listing removed | -- |
| 2015-08-29 | Listing removed | $699,000 |
| 2015-06-10 | Listed for sale | $699,000 |
| 2006-11-06 | Sold | $95,000 |
View on Zillow