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] => Pending
[last] => Pending
[changed] => 2024-03-06T15:09:02
)
[ml_number] => 2627037
[price] => stdClass Object
(
[amount] => 657900
[original] => 627046
[last_changed_on] => 2025-03-04T14:10:02
)
[listing_flags] => Array
(
[0] => Spec
)
[description] => Come to Norman Farm and discover your new lifestyle with unforgettable views plus the location close to everything you need. TO BE BUILT BIERSTADT with optional 4th bed & 3rd bath offers an open living space for your guests to come together with chic hardwood floors in an array of rooms! 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. Come today & choose your lot, floor plan, & interior/exterior colors/ finishes. All homes come with an extensive, included feature package. ASK ABOUT OUR 10K LENDER INCENTIVE DESIGNED TO SAVE YOU LOTS OF MONEY ON YOUR MONTHLY MORTGAGE!
[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.
[coordinates] => stdClass Object
(
[latitude] => 36.351496
[longitude] => -86.579161
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.579161
[1] => 36.351496
)
)
)
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Traditional
)
[construction] => Array
(
[0] => Fiber Cement
[1] => Brick
)
[square_feet] => stdClass Object
(
[size] => 2627
[source] => Professional Measurement
)
[stories] => 1.5
[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] => Entry Foyer
[2] => Primary Bedroom Main Floor
)
[appliances] => Array
(
[0] => Disposal
[1] => Microwave
[2] => Dishwasher
[3] => Gas Oven
[4] => Gas Range
)
[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 Faces Front
[1] => Concrete
)
[parking_spaces] => 2
[features] => Array
(
[0] => Garage Door Opener
)
[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-03-04T19:10:02Z
)
[office] => stdClass Object
(
[name] => CastleRock dba The Jones Company
[broker_id] => 3606
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Amber
[middle] => R
[last] => Mast
)
[phone] => stdClass Object
(
[preferred] => 6154189250
[mobile] => 6154189250
)
[agent_id] => 49378
)
[1] => stdClass Object
(
[name] => stdClass Object
(
[first] => Donna
[last] => Bowman
)
[phone] => stdClass Object
(
[preferred] => 6154986233
[mobile] => 6154986233
)
[agent_id] => 24214
)
)
[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
)
)
)
)
[selling_agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Tina
[last] => Cole
)
[phone] => stdClass Object
(
[preferred] => 6158784145
[mobile] => 6158784145
)
[agent_id] => 60414
)
)
[key] => rt-2627037
[added_at] => stdClass Object
(
[$date] => 2024-03-06T20:09:02Z
)
[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), Entry Foyer, Primary Bedroom Main Floor Appliances Disposal, Microwave, Dishwasher, Gas Oven, Gas Range HVAC Array
Exterior Details
Style Traditional Construction Fiber Cement, Brick Built In 2025 Stories 1.5 Parking Garage Faces Front, Concrete Garage Bays 2 Features Garage Door Opener Services Playground, Underground Utilities, Trail(s) Sewer Public Sewer
