stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active
[last] => Active
[changed] => 2025-04-07T20:23:00
)
[ml_number] => 2814758
[price] => stdClass Object
(
[amount] => 635000
[original] => 635000
[last_changed_on] => 2025-04-07T20:23:00
)
[listing_flags] => Array
(
[0] => Existing
)
[available_on] => stdClass Object
(
[$date] => 2025-04-07T04:00:00Z
)
[description] => This community is gated for additional security and the HOA on this property covers the mowing, trimming, mulching and treating of the lawn. This home is luxurious and comfortable. It features commercial appliances to include a 48” stove/double oven and griddle, 60” wide refrigerator/freezer and in-drawer microwave. Some unique features include a complete sprinkler system, a whole-home Sonos system for TV and music, central vacuum system, level 2 EV charger, low-voltage lighting around entire house, electric screen for patio, five generous walk-in closets, waterfall fountain on patio, a security system and a lifetime custom tile covering for garage floor. There are two bedrooms downstairs plus a room that could be used as a dining room, study or den. The guest bedroom, full bath and sitting area are upstairs plus three (3) extra closets/storage rooms. This home truly is move-in ready. Measurements are as follows: my piano room is 13'10" x 17'9", entry is 7'x11', the great room is 35'x18'2", kitchen is 12'1"x15'8", the pantry is 10'4"x3'4", the MBR is 16'10"x15'7", second bedroom (my office at present) is 15'4"x14'9", the garage is oversized at 21'x23'10".
[location] => stdClass Object
(
[city] => Jackson
[state] => Tennessee
[postal_code] => 38305
[county] => Madison County, TN
[subdivision] => Waterstone
[street] => stdClass Object
(
[number] => 79
[name] => Water Ridge PL
[full] => 79 Water Ridge PL
)
[directions] => Take I-40 West to Exit 82B; head north on US-45 Bypass, turn right on Oil Well Rd, then right on Water Ridge Pl.
[coordinates] => stdClass Object
(
[latitude] => 35.718058
[longitude] => -88.872274
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -88.872274
[1] => 35.718058
)
)
)
)
[building] => stdClass Object
(
[construction] => Array
(
[0] => Brick
)
[square_feet] => stdClass Object
(
[size] => 3200
)
[stories] => 2
[built_in] => 2014
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 3
)
[baths] => stdClass Object
(
[full] => 3
)
)
[features] => Array
(
[0] => Central Vacuum
[1] => Entrance Foyer
[2] => Extra Closets
[3] => High Ceilings
[4] => In-Law Floorplan
[5] => Open Floorplan
[6] => Pantry
[7] => Smart Light(s)
[8] => Storage
[9] => Primary Bedroom Main Floor
)
[appliances] => Array
(
[0] => Built-In Electric Oven
[1] => Double Oven
[2] => Built-In Gas Range
[3] => Dishwasher
[4] => Disposal
[5] => Freezer
)
[hvac] => Array
(
[0] => Array
(
[0] => Ceiling Fan(s)
[1] => Central Air
)
)
[fireplaces] => stdClass Object
(
[exists] =>
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[parking] => Array
(
[0] => Garage Door Opener
[1] => Attached
)
[parking_spaces] => 2
[features] => Array
(
[0] => Smart Irrigation
[1] => Sprinkler System
)
[land] => stdClass Object
(
[size] => stdClass Object
(
[acres] => 0.22
)
)
[school] => stdClass Object
(
[elementary] => Pope School
[junior] => Northeast Middle School
[high] => North Side High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-04-15T18:03:21Z
)
[office] => stdClass Object
(
[name] => Beycome Brokerage Realty, LLC
[broker_id] => 50864
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Kevin
[last] => Gioia
)
[phone] => stdClass Object
(
[mobile] => 8046565007
)
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/0.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/1.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/2.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/3.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/4.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/5.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/6.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/7.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/8.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/9.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/10.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/11.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/12.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/13.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2814758/14.jpg
[215x] => https://new.photos.idx.io/rt2/2814758/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2814758/14/440x.jpg
)
)
)
)
[key] => rt-2814758
[added_at] => stdClass Object
(
[$date] => 2025-04-08T00:23:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2814758
)
Interior Details
- Bedrooms3
- Bathrooms3
- FeaturesCentral Vacuum, Entrance Foyer, Extra Closets, High Ceilings, In-Law Floorplan, Open Floorplan, Pantry, Smart Light(s), Storage, Primary Bedroom Main Floor
- AppliancesBuilt-In Electric Oven, Double Oven, Built-In Gas Range, Dishwasher, Disposal, Freezer
- HVACArray
Exterior Details
- ConstructionBrick
- Built In2014
- Stories2
- ParkingGarage Door Opener, Attached
- Garage Bays2
- FeaturesSmart Irrigation, Sprinkler System
- SewerPublic Sewer
- Acres0.22