NOT LISTED FOR SALE

2564 Ingleside Farm W Germantown, TN 38139

Estimated Value: $1,475,000 - $1,639,000

6 Beds
7 Baths
7,000-7,999 Sq Ft
$194/Sq Ft Est. Value

Last Sold June 17, 2024

Last sale price $1,550,000 $194 Per Sq Ft

Current estimated payment $9,216/month

209 Days on Market

Highlights

  • Detached Guest House
  • Second Kitchen
  • Two Primary Bedrooms
  • Dogwood Elementary School Rated A
  • Pool House
  • Sitting Area In Primary Bedroom

About This Home

As of June 2024

Property is Pending Close. Auction Stopping Offer Accepted prior to the scheduled Luxury Live Auction! Bidding to start from $1,300,000! Germantown's prestigious Ingleside Farms! 7900 total sf + pool + plenty of yard space! Only home in Gtown available w pool/guest house! totally updated w elegant 2024 finishes, lighting, all new paint, 3 new baths & refinished hardwoods throughout (even upstairs). Kitchen w quartz counters, new backsplash, Viking Range & hearth rm. Best value in Germantown.

Last Agent to Sell the Property

Stacia Rosatti

Crye-Leike, Inc., REALTORS License #326726 Listed on: 09/18/2023

Crye-Leike, Inc., REALTORS

Co-Listed By

William Rosatti

Crye-Leike, Inc., REALTORS License #341545

Last Buyer's Agent

Stacia Rosatti

Crye-Leike, Inc., REALTORS License #326726 Listed on: 09/18/2023

Crye-Leike, Inc., REALTORS

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,633

Year Built

  • Built in 1998

Lot Details

  • 1 Acre Lot
  • Wrought Iron Fence
  • Wood Fence
  • Brick Fence
  • Landscaped Professionally
  • Level Lot
  • Sprinklers on Timer
  • Few Trees

HOA Fees

  • $58 Monthly HOA Fees

Home Design

  • Traditional Architecture
  • Slab Foundation
  • Composition Shingle Roof

Interior Spaces

  • 7,000-7,999 Sq Ft Home
  • 7,496 Sq Ft Home
  • 2-Story Property
  • Built-in Bookshelves
  • Smooth Ceilings
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Log Fireplace
  • Fireplace in Hearth Room
  • Some Wood Windows
  • Mud Room
  • Two Story Entrance Foyer
  • Great Room
  • Living Room with Fireplace
  • 3 Fireplaces
  • Dining Room
  • Den with Fireplace
  • Library
  • Bonus Room
  • Play Room
  • Screened Porch
  • Storage Room
  • Laundry Room
  • Efficiency Studio
  • Keeping Room

Kitchen

  • Updated Kitchen
  • Second Kitchen
  • Breakfast Bar
  • Double Self-Cleaning Oven
  • Gas Cooktop
  • Microwave
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Partially Carpeted
  • Tile

Bedrooms and Bathrooms

  • Sitting Area In Primary Bedroom
  • 6 Bedrooms | 1 Primary Bedroom on Main
  • Primary Bedroom Upstairs
  • Double Master Bedroom
  • En-Suite Bathroom
  • Cedar Closet
  • Walk-In Closet
  • Dressing Area
  • Remodeled Bathroom
  • Two Primary Bathrooms
  • Primary Bathroom is a Full Bathroom
  • Powder Room
  • In-Law or Guest Suite
  • Dual Vanity Sinks in Primary Bathroom
  • Whirlpool Bathtub
  • Bathtub With Separate Shower Stall

Attic

  • Attic Access Panel
  • Permanent Attic Stairs

Home Security

  • Home Security System
  • Termite Clearance

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway

Pool

  • Pool House
  • In Ground Pool
  • Pool Equipment or Cover

Outdoor Features

  • Patio
  • Outdoor Storage
  • Outdoor Gas Grill

Additional Homes

  • Detached Guest House

Utilities

  • Multiple cooling system units
  • Central Heating and Cooling System
  • Multiple Heating Units
  • Vented Exhaust Fan

Community Details

  • Ingleside Farms Subdivision
  • Mandatory home owners association

Listing and Financial Details

  • Assessor Parcel Number G0232O A00019

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,633

Year Built

Built in 1998

Lot Details

0

HOA Fees

$58 per month

Listing Details

  • Class: Residential
  • Type: Detached Single Family
  • Style: Traditional
  • Detached Unit Type: General Residential
  • MLS Map #: 863C
  • MAAR Subdivision Name: INGLESIDE FARMS
  • Number Of Stories: 2
  • Price Per Sq Ft: 206.78
  • Prop Construction Status: Existing Property
  • Estimated Sq Ft: 7496
  • Termite Contract: Yes
  • Year Built: 1998
  • List Price/ Sq Ft: 173
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • First Story Floor Plan: Living Room, Dining Room, Den/Great Room, Kitchen, Primary Bedroom, 1/2 Bath, 1 Bath, 1 1/2 Bath, Laundry Room, Keeping/Hearth Room, Office
  • Second Story Floor Plan: 2nd Bedroom, 3rd Bedroom, 4th or More Bedrooms, 2 or More Baths, Play Room/Rec Room, Bonus Room
  • Additional Bedroom Bathroom Info: 1 or More BR Down, Primary Down, Primary Up, Vaulted/Coffered Primary, Two Primaries, Renovated Bathroom, Luxury Primary Bath, Double Vanity Bath, Separate Tub & Shower, 2 Full Primary Baths, Full Bath Down, Eff/Studio, Half Bath Down
  • Estimated Heated Sq Ft Range: 7000 - 7999
  • Bedroom 2 Description: Level 2, Walk-In Closet, Private Full Bath, Smooth Ceiling, Hardwood Floor
  • Bedroom 3 Description: Level 2, Walk-In Closet, Shared Bath, Built-In Cabinets/Bkcases, Smooth Ceiling, Hardwood Floor
  • Bedroom 4 Description: Level 2, Walk-In Closet, Private Full Bath, Built-In Cabinets/Bkcases, Smooth Ceiling, Hardwood Floor, Carpet
  • Bedroom 5 Description: Level 2, Walk-In Closet, Shared Bath, Smooth Ceiling, Hardwood Floor
  • Bedrooms: 6
  • Bedrooms Down: 1
  • Fireplace: In Living Room, In Den/Great Room, In Keeping/Hearth room, Gas Logs
  • Floors/Ceilings: Hardwood Throughout, Part Carpet, Tile, Smooth Ceiling, 9 or more Ft. Ceiling, Two Story Foyer
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Equipment: Range/Oven, Self Cleaning Oven, Double Oven, Gas Cooking, Disposal, Dishwasher, Microwave, Refrigerator, Separate Ice Maker
  • Living Dining Kitchen: Separate Living Room, Separate Dining Room, Great Room, Updated/Renovated Kitchen, Breakfast Bar, Island In Kitchen, Keeping/Hearth Room
  • Misc Interior: Walk-In Closet(s), Cedar Lined Closet(s), Permanent Attic Stairs, Attic Access, Rear Stairs to Playroom, Mud Room, Powder/Dressing Room, Cat/Dog Free House, Security System, Vent Hood/Exhaust Fan
  • Number Of Fireplaces: 3
  • Other Rooms: Laundry Room, Library/Study, Bonus Room, Office/Sewing Room, In-Law Quarters, Separate Guest House, 2nd Kitchen, Entry Hall, Attic, Storage Room
  • Total Bathrooms: 5.2
  • Primary Bathroom Description: Double Sinks, Whirlpool Tub, Separate Shower, Dressing Area, Smooth Ceiling, Tile Floor
  • P R I M A R Y B E D R O O M: Level 1, Walk-In Closet, Full Bath, Sitting Area, Built-In Cabinets/Bkcases, Smooth Ceiling, Hardwood Floor

Exterior Features

  • Misc Exterior: Auto Lawn Sprinkler, Pool Cleaning Equipment, Gas Grill, Porch, Screen Porch, Patio, Covered Patio, Pool House, Well Landscaped Grounds, Wood Fence, Storage, Brick/Ironed Fence, Iron Fence
  • Exterior Windows: Brick Veneer, Wood Window(s)
  • Foundation: Slab
  • Pool Description: In Ground
  • Roof: Composition Shingles

Garage/Parking

  • Attached Detached Parking: Attached
  • Carport Garage: Garage
  • Number Covered Parking Spaces: 3
  • Parking Display: G3A
  • Parking Storage: Driveway/Pad, Storage Room(s), Garage Door Opener(s), Side-Load Garage

Utilities

  • Cooling: Central, Ceiling Fan(s), 3 or More Systems
  • Heating: Central, 3 or More Systems
  • Security: Dead Bolt Lock(s)
  • Water Sewer: Public Water, Public Sewer

Association/Amenities

  • Annual Association Fee: 700
  • Neighborhood Association: Mandatory

Lot Info

  • Lot Description: Some Trees, Level, Professionally Landscaped, Wood Fenced, Iron Fenced, Brick/Iron Fenced
  • Lot Number: 19
  • Acreage: 1
  • Keeping Hearth Dimension: 26x16
  • Lot Size: 43587 SF 178 X 245
  • Price Per Acre: 1300000

Multi Family

  • Number Of Rooms: 14

Tax Info

  • Assessor Parcel Number: G0232O A00019

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 18, 2023
Closed on
Jun 14, 2024
Sold by
Simmons Franklin S and Simmons Tera T
Bought by
Middleton Valerie Slone and Middleton Matthew
Seller's Agent
Stacia Rosatti
Crye-Leike, Inc., REALTORS
Buyer's Agent
Stacia Rosatti
Crye-Leike, Inc., REALTORS
List Price
$1,300,000
Sold Price
$1,550,000
Premium/Discount to List
$250,000
19.23%
Views
2679
Current Estimated Value
$1,551,787

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,787
Avg. Annual Appreciation
0.11%
Original Mortgage
$995,000
Outstanding Balance
$984,207
Interest Rate
7.09%
Mortgage Type
New Conventional
Estimated Equity
$567,831

Purchase Details

Listed on
Mar 30, 2023
Closed on
May 26, 2023
Sold by
Henry Christopher and Henry Rebecca
Bought by
Simmons Franklin S and Simmons Tera T
Seller's Agent
Chuck House
Keller Williams
Buyer's Agent
Stacia Rosatti
Crye-Leike, Inc., REALTORS
List Price
$1,475,000
Sold Price
$1,425,000
Premium/Discount to List
-$50,000
-3.39%
Views
214

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.26%
Original Mortgage
$413,800
Interest Rate
6.43%

Purchase Details

Listed on
Jan 28, 2016
Closed on
Jun 15, 2016
Sold by
Smolin Matthew K and Smolin Sandra C
Bought by
Henry Christopher and Henry Rebecca
Seller's Agent
Chuck House
Keller Williams
Buyer's Agent
Chuck House
Keller Williams
List Price
$1,125,000
Sold Price
$990,000
Premium/Discount to List
-$135,000
-12%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.38%
Original Mortgage
$417,000
Interest Rate
3.61%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 11, 2007
Sold by
Reid David E and Reid Tracie A
Bought by
Smolin Matthew K and Smolin Sandra C

Purchase Details

Closed on
Jul 11, 1996
Sold by
Ingleside Farms Development
Bought by
Reid David E and Reid Tracie A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$480,000
Interest Rate
7.99%
Mortgage Type
Construction
Source: Public Records

Range of Values:

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 Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Middleton Valerie Slone $1,550,000 Home Surety Title & Escrow
Simmons Franklin S $1,425,000 Home Surety Title & Escrow
Henry Christopher $990,000 Saddle Creek Title Llc
Smolin Matthew K $1,490,000 None Available
Reid David E $150,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Middleton Valerie Slone $995,000
Previous Owner Simmons Franklin S $413,800
Previous Owner Simmons Franklin S $726,200
Previous Owner Henry Rebecca $150,200
Previous Owner Henry Christopher $417,000
Previous Owner Reid David E $400,000
Previous Owner Reid David E $800,300
Previous Owner Reid David E $100,000
Previous Owner Reid David E $584,000
Previous Owner Reid David E $480,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/17/2024 06/17/24 Sold $1,550,000 +19.2% $221 / Sq Ft
04/18/2024 04/18/24 For Sale $1,300,000 0.0% $186 / Sq Ft
04/18/2024 04/18/24 Price Changed $1,300,000 -16.1% $186 / Sq Ft
04/14/2024 04/14/24 Pending -- -- --
04/05/2024 04/05/24 Off Market $1,550,000 -- --
03/08/2024 03/08/24 Price Changed $1,625,000 -1.5% $232 / Sq Ft
11/21/2023 11/21/23 Price Changed $1,650,000 -2.9% $236 / Sq Ft
11/03/2023 11/03/23 Price Changed $1,700,000 -5.3% $243 / Sq Ft
10/17/2023 10/17/23 Price Changed $1,795,000 -3.0% $256 / Sq Ft
09/18/2023 09/18/23 For Sale $1,850,000 +29.8% $264 / Sq Ft
05/26/2023 05/26/23 Sold $1,425,000 -3.4% $204 / Sq Ft
03/30/2023 03/30/23 For Sale $1,475,000 +49.0% $211 / Sq Ft
06/15/2016 06/15/16 Sold $990,000 -12.0% $124 / Sq Ft
05/01/2016 05/01/16 Pending -- -- --
01/28/2016 01/28/16 For Sale $1,125,000 -- $141 / Sq Ft
Source: Memphis Area Association of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

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 $8,633 $384,975 $73,600 $311,375
2024 $8,633 $254,650 $73,600 $181,050
2023 $13,314 $254,650 $73,600 $181,050
2022 $12,893 $254,650 $73,600 $181,050
2021 $13,058 $254,650 $73,600 $181,050
2020 $14,850 $247,500 $73,600 $173,900
2019 $10,024 $247,500 $73,600 $173,900
2018 $10,024 $247,500 $73,600 $173,900
2017 $10,172 $247,500 $73,600 $173,900
2016 $11,394 $260,725 $0 $0
2014 $11,394 $260,725 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Stacia Rosatti

    Seller's Agent in 2024

    Stacia Rosatti

    Crye-Leike

    (901) 270-9019

    54 in this area

    133 Total Sales

    Stacia Rosatti
    Section Image
  • William Rosatti

    Seller Co-Listing Agent in 2024

    William Rosatti

    Crye-Leike

    (901) 485-3009

    34 in this area

    69 Total Sales

    William Rosatti
    Section Image
  • Chuck House

    Seller's Agent in 2023

    Chuck House

    Keller Williams

    (901) 461-6900

    49 in this area

    320 Total Sales

    Chuck House
    Section Image
See All Agents

Map

Source: Memphis Area Association of REALTORS®

MLS Number: 10156981

Memphis Area Association of REALTORS®

APN: G0-232O-A0-0019

Tennessee Shelby County Germantown 38139

2564 Ingleside Farm W, Germantown, TN

This home is located at 2564 Ingleside Farm W, Germantown, TN 38139 since 18 September 2023 and is currently estimated at $1,551,787, approximately $193 per square foot. This property was built in 1998. 2564 Ingleside Farm W is a home located in Shelby County with nearby schools including Dogwood Elementary School, Houston Middle School, and Houston High School.

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® IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Some or all of the listings displayed may not belong to the firm whose website is being visited. Copyright© 2025 Memphis Area Association of REALTORS®.

Nearby Homes