stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active
[last] => Coming Soon
[changed] => 2025-03-18T11:48:01
)
[ml_number] => 2804712
[price] => stdClass Object
(
[amount] => 699000
[original] => 650000
[last_changed_on] => 2025-04-17T15:04:00
)
[listing_flags] => Array
(
[0] => Existing
)
[available_on] => stdClass Object
(
[$date] => 2025-03-18T04:00:00Z
)
[description] => Enjoy this stunning home located in one of the most sought-after neighborhoods. This showstopper has an all-brick exterior and features an open, light, and airy concept throughout. It has been tastefully updated with brand new windows and flooring, fresh paint, and high-end finishes. The gourmet kitchen offers ample space and is equipped with new appliances, seamlessly flowing into the spacious living area, while high ceilings enhance the overall sense of openness. The bonus room provides breathtaking views, adding to the appeal of the home. The primary suite is designed for luxury, features tray ceilings and an exquisite ensuite bathroom complete with dual sinks, heated floors, a lavish soaking bathtub, and a custom tile walk-in shower. Additionally, the double-sided fireplace provides a cozy atmosphere that can be enjoyed from both the living room and the beautiful sunroom. Entertain or relax on the expansive double decks, which offer stunning views. Enjoy 2 community pools and a pool house, all within a convenient 10 minute's drive of shopping and amenities. This home truly epitomizes comfort and elegance in a desirable location.
[location] => stdClass Object
(
[city] => Hendersonville
[state] => Tennessee
[postal_code] => 37075
[county] => Sumner County, TN
[subdivision] => Mansker Park/Mansker
[street] => stdClass Object
(
[number] => 152
[name] => Mansker Park Dr
[full] => 152 Mansker Park Dr
)
[directions] => Take I-65 N to Hendersonville, ta exit 2 from TN-386 N/Vietnam Veterans Blvd, turn left on Center Point Road, Continue on Center Point Rd. Drive, turn left on Mansker Farms Blvd, Turn left onto Mansker Park Dr, turn right to stay on Mansker Park dr.
[coordinates] => stdClass Object
(
[latitude] => 36.327928
[longitude] => -86.658552
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.658552
[1] => 36.327928
)
)
)
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Traditional
)
[construction] => Array
(
[0] => Brick
)
[square_feet] => stdClass Object
(
[size] => 3966
[source] => Assessor
)
[stories] => 2
[built_in] => 1996
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 4
)
[baths] => stdClass Object
(
[full] => 2
[half] => 1
)
[basement] => Array
(
[0] => Crawl Space
)
)
[features] => Array
(
[0] => High Speed Internet
)
[appliances] => Array
(
[0] => Electric Oven
[1] => Electric Range
[2] => Dishwasher
[3] => Disposal
[4] => Microwave
[5] => Refrigerator
[6] => Stainless Steel Appliance(s)
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
)
)
[fireplaces] => stdClass Object
(
[count] => 1
[exists] => 1
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[parking] => Array
(
[0] => Garage Faces Front
)
[parking_spaces] => 2
[land] => stdClass Object
(
[size] => stdClass Object
(
[dimensions] => 80 X 166.69 IRR
[acres] => 0.3
)
)
[school] => stdClass Object
(
[elementary] => Madison Creek Elementary
[junior] => T. W. Hunter Middle School
[high] => Beech Sr High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-04-17T19:04:00Z
)
[office] => stdClass Object
(
[name] => Reliant Realty ERA Powered
[broker_id] => 1613
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Courtney
[last] => Hambrick
)
[phone] => stdClass Object
(
[preferred] => 6152393496
[mobile] => 6152393496
)
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/0.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/1.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[description] => High ceiling view from standing in front door.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/2.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[description] => High ceiling view of front door
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/3.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[description] => Living room
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/4.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[description] => Living room
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/5.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[description] => Gorgeous views from the Living room space
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/6.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[description] => Office
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/7.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[description] => Office
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/8.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[description] => Downstairs half bath
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/9.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[description] => Open Kitchen
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/10.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/11.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/12.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/13.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[description] => Gorgeous Sunroom
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/14.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/15.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[description] => Staged Sunroom
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/16.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[description] => 2nd living room space
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/17.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[description] => Double sided fireplace that you can enjoy in the living room or Sunroom
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/18.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/19.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[description] => Bedroom 2
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/20.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[description] => Bedroom 3
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/21.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[description] => Bedroom 4
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/22.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[description] => Full Bathroom upstairs
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/23.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[description] => Full Bathroom upstairs
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/24.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[description] => Bonus room
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/25.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[description] => Bonus room with closet
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/26.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[description] => Luxury Owners Bedroom
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/27.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[description] => Owners Bedroom
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/28.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/28/440x.jpg
)
)
[29] => stdClass Object
(
[position] => 29
[description] => Owners Bathroom with heated floors
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/29.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/29/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/29/440x.jpg
)
)
[30] => stdClass Object
(
[position] => 30
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/30.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/30/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/30/440x.jpg
)
)
[31] => stdClass Object
(
[position] => 31
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/31.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/31/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/31/440x.jpg
)
)
[32] => stdClass Object
(
[position] => 32
[description] => Owners' custom closet
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/32.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/32/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/32/440x.jpg
)
)
[33] => stdClass Object
(
[position] => 33
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/33.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/33/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/33/440x.jpg
)
)
[34] => stdClass Object
(
[position] => 34
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/34.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/34/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/34/440x.jpg
)
)
[35] => stdClass Object
(
[position] => 35
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/35.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/35/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/35/440x.jpg
)
)
[36] => stdClass Object
(
[position] => 36
[description] => Screened in Deck
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/36.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/36/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/36/440x.jpg
)
)
[37] => stdClass Object
(
[position] => 37
[description] => Double deck
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/37.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/37/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/37/440x.jpg
)
)
[38] => stdClass Object
(
[position] => 38
[description] => Laundry room
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/38.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/38/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/38/440x.jpg
)
)
[39] => stdClass Object
(
[position] => 39
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2804712/39.jpg
[215x] => https://new.photos.idx.io/rt2/2804712/39/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2804712/39/440x.jpg
)
)
)
)
[key] => rt-2804712
[added_at] => stdClass Object
(
[$date] => 2025-03-16T00:11:01Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2804712
)
- Bedrooms4
- Bathrooms2
- Half Baths1
- BasementCrawl Space
- FeaturesHigh Speed Internet
- AppliancesElectric Oven, Electric Range, Dishwasher, Disposal, Microwave, Refrigerator, Stainless Steel Appliance(s)
- HVACArray
- Fireplaces1
Interior Details
- StyleTraditional
- ConstructionBrick
- Built In1996
- Stories2
- ParkingGarage Faces Front
- Garage Bays2
- SewerPublic Sewer
- Lot Dimensions80 X 166.69 IRR
- Acres0.3