NOT LISTED FOR SALE

405 Rose Trellis Rd Collierville, TN 38017

Collierville Area

Estimated Value: $296,000 - $331,000

3 Beds
2 Baths
1,400-1,599 Sq Ft
$201/Sq Ft Est. Value

Sale Details

Date Sold: January 12, 2015

Last sale price $157,300 $98 Per Sq Ft

Est. 100% increase in value since last sale

Current estimated payment $1,849 / mo

4 Days on Market

Highlights

  • Traditional Architecture
  • Whirlpool Bathtub
  • Window or Skylight in Bathroom
  • Collierville Elementary School Rated A-
  • Sun or Florida Room
  • Corner Lot

About This Home

As of January 2015

Charming & Quaint 3BR 2 Full BA Brick Home in Collierville! Carpet Throughout ~ Gas Fireplace in Living Room ~ Tile in Kitchen ~ Breakfast Bar & Breakfast Area ~ Completely Enclosed Sun Room ~ Large Master BR w/ Nice Sized Walk In Closet, Whirlpool Tub/Shower Combo ~ Large Fenced in Yard

Last Agent to Sell the Property

Angela Davis

Epique Realty License #273345 Listed on: 12/01/2014

Epique Realty

Last Buyer's Agent

Diane Peterson

Keller Williams License #277676

Keller Williams

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1990

Lot Details

  • 14,810 Sq Ft Lot
  • Wood Fence
  • Landscaped
  • Corner Lot
  • Few Trees

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Slab Foundation
  • Composition Shingle Roof

Interior Spaces

  • 1,400-1,599 Sq Ft Home
  • 1,457 Sq Ft Home
  • 1-Story Property
  • Ceiling Fan
  • Gas Fireplace
  • Living Room with Fireplace
  • Sun or Florida Room
  • Attic Access Panel
  • Iron Doors
  • Laundry closet

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Oven or Range
  • Gas Cooktop

Flooring

  • Wall to Wall Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Main Level Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms
  • Whirlpool Bathtub
  • Window or Skylight in Bathroom

Parking

  • 2 Car Garage
  • Front Facing Garage
  • Driveway

Additional Features

  • Patio
  • Central Heating and Cooling System

Community Details

  • Plantation Estates Pud Subdivision

Listing and Financial Details

  • Assessor Parcel Number C0245T G00014

Home Details

Home Type

Single Family

Year Built

Built in 1990

Lot Details

0.34 Acres

Listing Details

  • Class: Residential
  • Type: Detached Single Family
  • Style: Traditional
  • Detached Unit Type: General Residential
  • MAAR Subdivision Name: PLANTATION ESTATES
  • List Price Per Sq Ft: 103
  • Number Of Stories: 1
  • Prop Construction Status: Existing Property
  • Estimated Sq Ft: 1457
  • Year Built: 1990
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • First Story Floor Plan: Living Room, Kitchen, Primary Bedroom, 2nd Bedroom, 3rd Bedroom, 2 or More Baths, Sun Room
  • Additional Bedroom Bathroom Info: All Bedrooms Down, Whirlpool(s), Sky Light(s) in Bath, Full Bath Down
  • Estimated Heated Sq Ft Range: 1400-1599
  • Bedroom 2 Description: Level 1, Shared Bath, Carpet
  • Bedroom 3 Description: Level 1, Shared Bath, Carpet
  • Bedrooms: 3
  • Bedrooms Down: 3
  • Fireplace: Vented Gas Fireplace, In Living Room
  • Floors/Ceilings: Wall to Wall Carpet, Tile
  • Full Bathrooms: 2
  • Equipment: Range/Oven, Gas Cooking
  • Living Dining Kitchen: Separate Living Room, Eat-In Kitchen, Breakfast Bar, Pantry
  • Misc Interior: Walk-In Closet(s), Attic Access, Sky Light(s)
  • Number Of Fireplaces: 1
  • Other Rooms: Laundry Closet, Sun Room
  • Primary Bathroom Description: Whirlpool Tub, Tile Floor
  • P R I M A R Y B E D R O O M: Level 1, Carpet

Exterior Features

  • Misc Exterior: Wrought Iron Security Drs, Patio, Wood Fence
  • Exterior Windows: Brick Veneer
  • Foundation: Slab
  • Roof: Composition Shingles

Garage/Parking

  • Number Covered Parking Spaces: 2
  • Parking Display: 2
  • Parking Storage: Driveway/Pad, Front-Load Garage

Utilities

  • Cooling: Central, Ceiling Fan(s)
  • Heating: Central

Lot Info

  • Lot Description: Some Trees, Corner, Landscaped, Wood Fenced
  • Lot Number: 172
  • Acreage: 0.34
  • Lot Size: 104.4/105.11X145/139.27

Tax Info

  • Assessor Parcel Number: C0245T G00014

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Closed on
Apr 22, 2022
Sold by
William Locastro Joseph and Lepeard Nealy
Bought by
Current Estimated Value
$314,278

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$200,000
Outstanding Balance
$184,740
Interest Rate
4.16%
Mortgage Type
New Conventional
Estimated Equity
$136,207

Purchase Details

Closed on
Sep 15, 2016
Sold by
Rothie Karina Ann Marie
Bought by
Locastro Joseph W

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$175,698
Interest Rate
3.43%
Mortgage Type
VA

Purchase Details

Listed on
Dec 1, 2014
Closed on
Jan 12, 2015
Sold by
Mills James Andrew and Mills Bishop Charlotte Irene
Bought by
Marie Rothie Karina Ann
Seller's Agent
Angela Davis
Epique Realty
Buyer's Agent
Diane Peterson
Keller Williams
List Price
$150,000
Sold Price
$157,300
Premium/Discount to List
$7,300
4.87%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.30%
Original Mortgage
$154,443
Interest Rate
3.99%
Mortgage Type
FHA
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Collierville, TN

  • Toni Green Real Estate Agent - Crye-Leike, Inc., REALTORS

    Toni Green

    Crye-Leike, Inc., REALTORS

    (901) 437-4651

    33 Total Sales

    3 in Collierville

    $383K - $590K Price Range

    Toni Green
     Section Image
  • Carole Ann Burns Real Estate Agent - Crye-Leike, Inc., REALTORS

    Carole Ann Burns

    Crye-Leike, Inc., REALTORS

    (901) 979-0941

    48 Total Sales

    2 in Collierville

    $335K - $605K Price Range

    Carole Ann Burns
     Section Image
  • Jason Miller Real Estate Agent - eXp Realty, LLC

    Jason Miller

    Responds Quickly

    eXp Realty, LLC

    (901) 531-9258

    235 Total Sales

    2 in Collierville

    $680K - $828K Price Range

    Jason Miller
     Section Image
  • Stephanie Koshak Real Estate Agent - Crye-Leike, Inc., REALTORS

    Stephanie Koshak

    Crye-Leike, Inc., REALTORS

    (858) 304-7237

    33 Total Sales

    7 in Collierville

    $325K - $850K Price Range

    Stephanie Koshak
     Section Image
  • Carrie Stewart Real Estate Agent - Regency Realty, LLC

    Carrie Stewart

    Regency Realty, LLC

    (901) 425-0719

    73 Total Sales

    3 in Collierville

    $360K - $538K Price Range

    Carrie Stewart
     Section Image
  • Aubrey Tilson Real Estate Agent - Crye-Leike, Inc., REALTORS

    Aubrey Tilson

    Crye-Leike, Inc., REALTORS

    (901) 450-5420

    199 Total Sales

    19 in Collierville

    $372K - $1.6M Price Range

    Aubrey Tilson
     Section Image
See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$250,000 Lowrance Law Firm Plc
Locastro Joseph W $172,000 Southern Trust Title Co
Marie Rothie Karina Ann $157,300 Edco Title
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $200,000
Previous Owner Locastro Joseph W $175,698
Previous Owner Marie Rothie Karina Ann $154,443
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
01/12/2015 01/12/15 Sold $157,300 +4.9% $112 / Sq Ft
12/05/2014 12/05/14 Pending -- -- --
12/01/2014 12/01/14 For Sale $150,000 -- $107 / Sq Ft
Source: Memphis Area Association of REALTORS®

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $1,278 $78,875 $18,150 $60,725
2024 $1,975 $58,250 $10,850 $47,400
2023 $3,046 $58,250 $10,850 $47,400
2022 $2,977 $58,250 $10,850 $47,400
2021 $2,010 $58,250 $10,850 $47,400
2020 $1,928 $47,600 $10,850 $36,750
2019 $1,928 $47,600 $10,850 $36,750
2018 $1,928 $47,600 $10,850 $36,750
2017 $2,732 $47,600 $10,850 $36,750
2016 $1,841 $42,125 $0 $0
2014 $1,841 $42,125 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Angela Davis Real Estate Agent - Epique Realty

    Seller's Agent in 2015

    Angela Davis

    Epique Realty

    (901) 870-3064

    14 Total Sales

    Angela Davis
    Section Image
  • Diane Peterson Real Estate Agent - Keller Williams

    Buyer's Agent in 2015

    Diane Peterson

    Keller Williams

    (901) 619-6881

    61 Total Sales

    Diane Peterson
    Section Image

  • RK

    Buyer Co-Listing Agent in 2015

    Roamy Kilmer

    RE/MAX

    Section Image
  • Kelly Day Real Estate Agent - SimpliHOM

    Buyer Co-Listing Agent in 2015

    Kelly Day

    SimpliHOM

    (901) 289-9227

    41 Total Sales

    Kelly Day
    Section Image
See All Agents

Map

Source: Memphis Area Association of REALTORS®

MLS Number: 9940989

Memphis Area Association of REALTORS®

APN: C0-245T-G0-0014

Tennessee Shelby County Collierville 38017

405 Rose Trellis Rd, Collierville, TN

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Memphis Area Association of REALTORS® Listing content and images Copyright 2026 Memphis Area Association of REALTORS®. Information provided is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Do not rely upon listing data without independently verifying it.
Some or all of the listings displayed may not belong to the firm whose website is being visited.

Listing Information presented by local MLS brokerage: Ten-X, LLC dba Homes.com, local broker - Arlene Richardson - 888-952-6393 - 17600 Laguna Canyon Rd, Irvine, CA 92618.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.