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] => Coming Soon
[changed] => 2025-04-14T16:57:00
)
[ml_number] => 2815760
[price] => stdClass Object
(
[amount] => 527225
[original] => 550000
[last_changed_on] => 2025-06-09T20:51:00
)
[listing_flags] => Array
(
[0] => Existing
)
[available_on] => stdClass Object
(
[$date] => 2025-04-11T04:00:00Z
)
[description] => PRICE REDUCTION! Seller will assist with buyers closing cost! This 4 Bedroom 2.5 Bath is waiting for a new owner. Home Features a large open floorplan with Gas burning Fireplace, Formal Dining Room for the large gatherings! Update eat in Kitchen with Breakfast Bar and Island, Washer and Dryer, New Dishwasher and allowance for new Gas or Electric Stove, Refrigerator. Fantastic Master with Master Bath Double Sink and Vanity, Shower and Tub. Large Walk In Closet. Other 2 Bedrooms have large closets. Hall Bath with new Walk In shower. Roof is only 2 years old, one of the Heat Air units is just a 2 years old other unit about 5 years old. Back Yard has a new Privacy Fence. Seller will consider all offers!
[location] => stdClass Object
(
[city] => Mount Juliet
[state] => Tennessee
[postal_code] => 37122
[county] => Wilson County, TN
[subdivision] => Park Glen
[street] => stdClass Object
(
[number] => 497
[name] => Creek Pt
[full] => 497 Creek Pt
)
[directions] => Mt Juliet Rd to Right turn on Lebanon Rd to Right into Park Glen, Left on Creek Pt
[coordinates] => stdClass Object
(
[latitude] => 36.226696
[longitude] => -86.502848
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.502848
[1] => 36.226696
)
)
)
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Colonial
)
[construction] => Array
(
[0] => Brick
[1] => Vinyl Siding
)
[square_feet] => stdClass Object
(
[size] => 2507
[source] => Assessor
)
[stories] => 2
[built_in] => 1988
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 4
)
[baths] => stdClass Object
(
[full] => 2
[half] => 1
)
[basement] => Array
(
[0] => Crawl Space
)
)
[features] => Array
(
[0] => Ceiling Fan(s)
[1] => Entrance Foyer
[2] => Open Floorplan
[3] => Walk-In Closet(s)
[4] => High Speed Internet
[5] => Kitchen Island
)
[appliances] => Array
(
[0] => Electric Range
[1] => Dishwasher
[2] => Dryer
[3] => Ice Maker
[4] => Microwave
[5] => Refrigerator
[6] => Stainless Steel Appliance(s)
[7] => Washer
)
[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] => Attached
[1] => Driveway
)
[parking_spaces] => 2
[land] => stdClass Object
(
[size] => stdClass Object
(
[dimensions] => 69X140
[acres] => 0.23
)
[description] => Array
(
[0] => Cul-De-Sac
)
)
[school] => stdClass Object
(
[elementary] => Elzie D Patton Elementary School
[junior] => West Wilson Middle School
[high] => Mt. Juliet High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-06-10T00:51:00Z
)
[office] => stdClass Object
(
[name] => Ritter Real Estate Services
[broker_id] => 1273
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Donna
[middle] => J
[last] => Ritter
)
[phone] => stdClass Object
(
[preferred] => 6155168296
[mobile] => 6155168296
[fax] => 6152204237
)
[agent_id] => 8769
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[description] => Welcome to your NEW HOME
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/0.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[description] => Two Car Garage and plenty of parking in Drive area. Quiet CAL DE SACK
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/1.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[description] => Covered Front Porch
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/2.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[description] => Front Foyer to Living Room
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/3.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[description] => Front Foyer view as you enter your new home
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/4.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[description] => Large Formal Living Room with Gas Logs Fireplace
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/5.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[description] => Open Floor Plan from Living Room to Formal Dining Room
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/6.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[description] => View from Dining Room to Living Room and Front Foyer
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/7.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[description] => Large Formal Dining Room with great view of large back yard
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/8.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[description] => Updated Kitchen with large Eating Bar and Island, Mabel Counter Tops New Dishwasher Refrigerator and Stove allowance for Gas or Electric Stove
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/9.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[description] => Kitchen feature lots of Cabinets
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/10.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/11.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[description] => Family Room with view of the back yard
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/12.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[description] => Half Bath on Lower Leven
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/13.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[description] => Family Room with view of large Privacy Fenced Back Yard, steps to the upper level and Laundry Room
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/14.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[description] => Washer and Dryer included
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/15.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[description] => Upstairs landing to 3 large bedrooms and Office
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/16.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[description] => Extra Large Master Bedroom
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/17.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[description] => Master Bath with Double sinks
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/18.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[description] => Master Bath with Tub and Shower area
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/19.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[description] => Huge Master Bedroom Closet
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/20.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[description] => Bedroom 2 with view of back yard and large closet
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/21.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[description] => Front Bedroom with Large Closet
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/22.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[description] => Working from Home Office area
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/23.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[description] => Hall Bath with large walk in shower
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/24.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[description] => Master That has large vanity top
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/25.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[description] => Large Back yard
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/26.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[description] => Almost new Privacy Fence around full back yard
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2815760/27.jpg
[215x] => https://new.photos.idx.io/rt2/2815760/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2815760/27/440x.jpg
)
)
)
)
[key] => rt-2815760
[added_at] => stdClass Object
(
[$date] => 2025-04-09T21:00:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2815760
)
Interior Details
Bedrooms 4 Bathrooms 2 Half Baths 1 Basement Crawl Space Features Ceiling Fan(s), Entrance Foyer, Open Floorplan, Walk-In Closet(s), High Speed Internet, Kitchen Island Appliances Electric Range, Dishwasher, Dryer, Ice Maker, Microwave, Refrigerator, Stainless Steel Appliance(s), Washer HVAC Array Fireplaces 1
Exterior Details
Style Colonial Construction Brick, Vinyl Siding Built In 1988 Stories 2 Parking Attached, Driveway Garage Bays 2 Sewer Public Sewer Lot Description Cul-De-Sac Lot Dimensions 69X140 Acres 0.23
