Easy living here! Beautiful brick home with a tornado shelter in Schilling Farms! Covered back patio overlooking the peaceful green space. Fenced yard, too! Spacious and functional kitchen w/island overlooking the great room and a wonderful butler's pantry. Large dining room with tons of natural light. Custom cabinets and desks in the office area just off the living space-so many options here! Gorgeous hardwoods down! 3 extra large bedrooms upstairs. So much to love: new tankless hot water heater, vinyl windows replaced 2015, primary bath remodel 2022, roof 2021, HVAC 2017. Neighborhood Pool! ALL yard maintenance addressed by the HOA-mowing, trimming, weeding!! Collierville Schools! Perfect location!
For sale
Price cut: $9K (4/26)
$500,000
340 Sterling Oaks Cv, Collierville, TN 38017
3beds
--sqft
Est.:
Detached Single Family
Built in 2002
3,920.4 Square Feet Lot
$498,000 Zestimate®
$--/sqft
$123/mo HOA
What's special
Fenced yardCovered back patioSpacious and functional kitchenTons of natural lightLarge dining roomCustom cabinetsGorgeous hardwoods
- 70 days
- on Zillow |
- 306 |
- 10 |
Zillow last checked: 7 hours ago
Listing updated: May 09, 2025 at 03:15pm
Listed by:
Maureen Fraser,
John Green & Co., REALTORS 901-853-0763
Source: MAAR,MLS#: 10191181

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: 2
- 1/2 bathrooms: 1
Rooms
- Room types: Attic, Entry Hall, Library/Study, Loft/Balcony
Primary bedroom
- Features: Carpet, Sitting Area, Walk-In Closet(s)
- Level: Second
- Area: 338
- Dimensions: 13 x 26
Bedroom 2
- Features: Carpet, Pullman Bath, Walk-In Closet(s)
- Level: Second
- Area: 140
- Dimensions: 10 x 14
Bedroom 3
- Features: Carpet, Shared Bath
- Level: Second
- Area: 312
- Dimensions: 12 x 26
Primary bathroom
- Features: Double Vanity, Separate Shower, Smooth Ceiling, Tile Floor, Full Bath
Dining room
- Features: Separate Dining Room
- Area: 208
- Dimensions: 13 x 16
Kitchen
- Features: Breakfast Bar, Kitchen Island, Pantry, Updated/Renovated Kitchen
- Area: 192
- Dimensions: 12 x 16
Living room
- Features: Great Room
- Dimensions: 0 x 0
Office
- Area: 143
- Dimensions: 11 x 13
Heating
- Central, Dual System, Natural Gas
Cooling
- Ceiling Fan(s), Central Air, Dual
Appliances
- Included: Cooktop, Disposal, Dishwasher, Microwave, Refrigerator
- Laundry: Laundry Room
Features
- Cable Wired, High Ceilings, Smooth Ceiling, Sprayed Ceiling, 1/2 Bath, Den/Great Room, Dining Room, Kitchen, Office, 2 or More Baths, 2nd Bedroom, 3rd Bedroom, Primary Bedroom, All Bedrooms Up, Double Vanity, Half Bath Down, Luxury Primary Bath, Primary Up, Renovated Bathroom, Split Bedroom Plan, Vaulted/Coffered Primary
- Flooring: Part Carpet, Part Hardwood, Tile
- Windows: Window Treatments
- Attic: Pull Down Stairs,Walk-In
- Number of fireplaces: 1
- Fireplace features: Gas Log, Gas Starter, In Den/Great Room, Factory Built, Ventless
Interior area
- Living area range: 2800-2999 Square Feet
Property
Parking
- Total spaces: 2
- Parking features: Garage Faces Rear, Garage Door Opener, Other (See REMARKS)
- Has garage: Yes
- Covered spaces: 2
Features
- Stories: 2
- Patio & porch: Porch, Covered Patio
- Pool features: Community, Neighborhood
- Fencing: Wrought Iron
- Waterfront features: Cove
Lot
- Size: 3,920.4 Square Feet
- Dimensions: 4113 SF 47 X 147
- Features: Level, Professionally Landscaped, Some Trees
Details
- Parcel number: C0244J B00023
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Detached Single Family
Materials
- Brick Veneer, Wood/Composition
- Foundation: Slab
- Roof: Composition Shingles
Condition
- New construction: No
- Year built: 2002
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available
Community & HOA
Community
- Security: Security System, Smoke Detector(s), Burglar Alarm
- Subdivision: Schilling Farms Pd Area 10 Ph 17b
HOA
- HOA fee: $1,480 annually
Location
- Region: Collierville
Financial & listing details
- Annual tax amount: $4,659
- Price range: $500K - $500K
- Date on market: 3/4/2025
- Listing terms: Conventional,FHA,VA Loan
- Loading
- Loading