Rare opportunity Waterfront Lakeview house at Ashbrooke neighborhood, good school district in Madison.
This home is a 3 Bedroom, 2 Bath...with Partial Friendly Wood Fence on front and Lovely Wrought Iron Fence across back yard to see beautiful lakefront water view. Seawall has been added 8 years ago. Scored Concrete Floors thruout home except Carpet in Bedrooms. There is a Side 2 Car Garage, then you walk into front of home with covered front porch into Foyer, and Living Room area with Tons of Built-Ins to left and Lovely Gas Fireplace,with a beautiful ornate mantle for those cool fall/winter evenings, Then to Breakfast Bar/Kitchen area with solid granite surface countertops, and stainless Whirlpool Appliances. Gas Range and Built-In Microwave. Walking further down Hallway to Large Laundry Room and Mud area with Coat/Backpack hooks and bench seat. On same side of house, You will enter Master Bedroom with exceptional shower with seat inside, jetted bathtub, double vanity, and huge closet space. Other side of home, has 2 secondary bedrooms with bathroom in between. Outside the backdoor, you have an extended covered back patio, and Huge back yard and Lakefront water view that you may have a boat in as well. ( without motor) Side Gate is double to get boat in if needed. Please don't miss this chance to own a lovely waterfront home, convenient to medical clinics, churches, shopping and the best schools in Madison Co!! .......Call for an Appointment today!
Closed
Price Unknown
117 Memory Ln, Madison, MS 39110
3beds
1,800sqft
Residential, Single Family Residence
Built in 2009
0.5 Acres Lot
$334,500 Zestimate®
$--/sqft
$2,392 Estimated rent
Home value
$334,500
$318,000 - $351,000
$2,392/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: August 28, 2025 at 11:42am
Listed by:
Nice Shirley Bowman 769-230-5100,
Home Again Realty
Bought with:
Lenetta Lee, S57932
Edwards Realty Co.
Source: MLS United,MLS#: 4112232
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Heating
- Central
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Cooktop, Dishwasher, Disposal, Exhaust Fan, Free-Standing Range, Microwave, Refrigerator, Vented Exhaust Fan, Water Heater
- Laundry: Laundry Room
Features
- Breakfast Bar, Ceiling Fan(s), Double Vanity, Eat-in Kitchen, Entrance Foyer, High Ceilings, Pantry, Walk-In Closet(s), Granite Counters
- Flooring: Carpet, Stamped, Stone
- Doors: Dead Bolt Lock(s)
- Windows: Insulated Windows, Window Treatments
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total structure area: 1,800
- Total interior livable area: 1,800 sqft
Property
Parking
- Total spaces: 2
- Parking features: Concrete
- Garage spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Porch
- Exterior features: None
- Fencing: Back Yard,Fenced
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Lake, Lake Front, Waterfront
Lot
- Size: 0.50 Acres
Details
- Additional structures: Garage(s)
- Parcel number: Unknown
- Zoning description: Single Family Residence
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Residential, Single Family Residence
Materials
- Brick
- Foundation: Slab
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2009
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected, Electricity Connected, Natural Gas Connected, Water Connected
Community & neighborhood
Security
- Security features: Prewired, Security System, Smoke Detector(s)
Community
- Community features: Clubhouse, Fishing, Lake, Park, Playground, Pool
Location
- Region: Madison
- Subdivision: Ashbrooke
Price history
| Date | Event | Price |
|---|---|---|
| 9/23/2025 | Listing removed | $2,400$1/sqft |
Source: Zillow Rentals | ||
| 8/28/2025 | Listed for rent | $2,400$1/sqft |
Source: Zillow Rentals | ||
| 8/25/2025 | Sold | -- |
Source: MLS United #4112232 | ||
| 7/3/2025 | Pending sale | $344,900$192/sqft |
Source: MLS United #4112232 | ||
| 6/18/2025 | Price change | $344,900-1.4%$192/sqft |
Source: MLS United #4112232 | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $1,540 -15.9% | $17,917 +0.5% |
| 2023 | $1,831 | $17,829 |
| 2022 | $1,831 +5.9% | $17,829 +3.8% |
Find assessor info on the county website
Neighborhood: 39110
Nearby schools
GreatSchools rating
- 9/10Mannsdale Elementary SchoolGrades: K-2Distance: 2.8 mi
- 8/10Germantown Middle SchoolGrades: 6-8Distance: 2.7 mi
- 8/10Germantown High SchoolGrades: 9-12Distance: 2.6 mi
Schools provided by the listing agent
- Elementary: Mannsdale
- Middle: German Towne
- High: Germantown
Source: MLS United. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.