Price - High to Low Price - Low to High Date Listed - New to Old Date Listed - Old to New
stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active
[last] => Active
[changed] => 2025-05-03T15:17:00
)
[ml_number] => 2627037
[price] => stdClass Object
(
[amount] => 650990
[original] => 650990
[last_changed_on] => 2025-05-03T15:17:00
)
[listing_flags] => Array
(
[0] => New
)
[available_on] => stdClass Object
(
[$date] => 2025-04-26T04:00:00Z
)
[description] => MOVE-IN READY! BIERSTADT plan with optional 3rd car garage, 4th bed & 3rd bath offers an open living space for your guests to come together! Granite & stainless appliances complement your beautifully presented kitchen with an extra-large island! Your Owner's Bath has a tiled, walk-in shower for a large, spa-inspired vibe. We make living in your new home very "EASY" with our expanded, included smart home features. All homes come with an extensive, included feature package. Come to Norman Farm and discover your new lifestyle with unforgettable views plus the location close to everything you need.
[location] => stdClass Object
(
[city] => Hendersonville
[state] => Tennessee
[postal_code] => 37075
[county] => Sumner County, TN
[subdivision] => The Retreat at Norman Farm
[street] => stdClass Object
(
[number] => 165
[name] => John T Alexander BLVD
[full] => 165 John T Alexander BLVD
)
[directions] => I-65 N to TN-386 N/Vietnam Veterans Blvd. Exit 7 from TN-386 N/Vietnam Veterans Blvd. Turn left onto Indian Lake Blvd. Continue onto Calendar Ln/Drakes Creek Rd. Right onto Anderson Rd follow the curve. Right onto John T Alexander BLVD. Model on Left.
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Traditional
)
[construction] => Array
(
[0] => Fiber Cement
[1] => Brick
)
[square_feet] => stdClass Object
(
[size] => 2560
[source] => Professional Measurement
)
[stories] => 2
[built_in] => 2025
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 4
)
[baths] => stdClass Object
(
[full] => 3
)
[basement] => Array
(
[0] => Crawl Space
)
)
[features] => Array
(
[0] => Walk-In Closet(s)
[1] => Entrance Foyer
[2] => Primary Bedroom Main Floor
)
[appliances] => Array
(
[0] => Disposal
[1] => Microwave
[2] => Dishwasher
)
[hvac] => Array
(
[0] => Array
(
[0] => Electric
[1] => Central Air
)
)
[fireplaces] => stdClass Object
(
[exists] =>
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[services] => Array
(
[0] => Playground
[1] => Underground Utilities
[2] => Trail(s)
)
[parking] => Array
(
[0] => Garage Door Opener
[1] => Garage Faces Front
[2] => Concrete
)
[parking_spaces] => 3
[school] => stdClass Object
(
[elementary] => Dr. William Burrus Elementary at Drakes Creek
[junior] => Knox Doss Middle School at Drakes Creek
[high] => Beech Sr High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-05-03T19:17:00Z
)
[office] => stdClass Object
(
[name] => CastleRock dba The Jones Company
[broker_id] => 3606
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Nicole
[last] => Melroe
)
[phone] => stdClass Object
(
[preferred] => 6159311422
[mobile] => 6157728948
)
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[description] => Welcome to the Bierstadt!! One of eight beautiful elevations to choose from. Photo not of actual home. The Bierstadt is our model home at River Oaks. Come tour it today!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/0.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[description] => Hide away in this flex room located in the front of the house. Did I mention the French doors are included? Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/1.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[description] => Welcome guests to your new home in this beautiful foyer! Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/2.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[description] => One of two cozy secondary bedrooms downstairs. Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/3.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[description] => Second additional bedroom downstairs. Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/4.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[description] => Nice size hall bath downstairs conveniently located between the two secondary bedrooms. Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/5.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[description] => Separate casual dining that is very open to kitchen and great room for all of your entertaining needs. Great use of open space for entertaining! Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/6.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[description] => This space was made to entertain!! Everyone is included in this open kitchen and living room area. Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/7.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[description] => Staggered height cabinets, vaulted ceilings and granite counter tops are included in kitchen. Can it get any better?! Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/8.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[description] => Imagine having friends or family over with this huge island!! Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/9.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[description] => Host parties and family get-togethers in this room! Tons of memories to be made here! Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/10.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[description] => Large owner's bedroom downstairs with included trey ceiling. Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/11.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[description] => Separate shower / tub in owner's bath with double vanities! Different options of bathroom layout to choose from. Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/12.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[description] => Large Utility space! Photo not of actual home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/13.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[description] => Standard first floor of the Bierstadt floor plan. This shows the option to have shower only in the master bath.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/14.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[description] => Optional water closet in the master bathroom.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/15.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[description] => Optional bonus room with bedroom and full bathroom upstairs.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/16.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/17.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/18.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2627037/19.jpg
[215x] => https://new.photos.idx.io/rt2/2627037/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2627037/19/440x.jpg
)
)
)
)
[key] => rt-2627037
[added_at] => stdClass Object
(
[$date] => 2025-05-03T19:17:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2627037
)
Interior Details
Bedrooms 4 Bathrooms 3 Basement Crawl Space Features Walk-In Closet(s), Entrance Foyer, Primary Bedroom Main Floor Appliances Disposal, Microwave, Dishwasher HVAC Array
Exterior Details
Style Traditional Construction Fiber Cement, Brick Built In 2025 Stories 2 Parking Garage Door Opener, Garage Faces Front, Concrete Garage Bays 3 Services Playground, Underground Utilities, Trail(s) Sewer Public Sewer