stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active
[last] => Coming Soon
[changed] => 2024-11-01T01:04:19
)
[ml_number] => 2754249
[price] => stdClass Object
(
[amount] => 799900
[original] => 799900
[last_changed_on] => 2024-10-31T12:30:00
)
[listing_flags] => Array
(
[0] => Existing
)
[available_on] => stdClass Object
(
[$date] => 2024-11-01T04:00:00Z
)
[description] => Welcome to this stunning, completely renovated home in the highly sought-after Riverview subdivision! Inside you'll find new engineered hw floors flowing seamlessly through the main living space, lending warmth & elegance to every room. The kitchen is a chef’s dream, featuring custom cabinets by Henry’s, high-end ZLINE appl's, & a gas range for precision cooking. A large butler’s pantry with floor-to-ceiling cabinetry provides ample storage, making organization a breeze. The primary suite includes a custom-built closet system & a luxurious bathroom adorned with a marble mosaic tile floor, heated tub, & designer finishes. The secondary bathroom spares no detail, offering a zelliage-tiled, zero-entry shower for a modern, spa-like feel. Updated lighting throughout the home add a contemporary touch. Relax by the floor to ceiling gas fp in the vaulted great room. Outside is a flagstone patio that overlooks a pristine saltwater pool in a fenced yard. This home is just a short golf cart ride to course!
[location] => stdClass Object
(
[city] => Murfreesboro
[state] => Tennessee
[postal_code] => 37129
[county] => Rutherford County, TN
[subdivision] => Riverview Resub Sec 2
[street] => stdClass Object
(
[number] => 1806
[name] => Oxford Dr
[full] => 1806 Oxford Dr
)
[directions] => From Broad and Northfield take Northfield East to Left on Battleground, Left on Riverview, Right on Rugby, Left on Oxford.
[coordinates] => stdClass Object
(
[latitude] => 35.881427
[longitude] => -86.416695
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.416695
[1] => 35.881427
)
)
)
)
[building] => stdClass Object
(
[construction] => Array
(
[0] => Brick
)
[square_feet] => stdClass Object
(
[size] => 2715
[source] => Professional Measurement
)
[stories] => 1
[built_in] => 1972
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 3
)
[baths] => stdClass Object
(
[full] => 2
[half] => 1
)
[basement] => Array
(
[0] => Crawl Space
)
)
[pool] => Array
(
[0] => In Ground
)
[features] => Array
(
[0] => Bookcases
[1] => Built-in Features
[2] => Ceiling Fan(s)
[3] => High Ceilings
)
[appliances] => Array
(
[0] => Dishwasher
[1] => Disposal
[2] => Refrigerator
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
[1] => Electric
)
)
[fireplaces] => stdClass Object
(
[count] => 1
[exists] => 1
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[features] => Array
(
[0] => Storage
)
[land] => stdClass Object
(
[size] => stdClass Object
(
[dimensions] => 140 X 210.45 IRR
[acres] => 0.66
)
)
[school] => stdClass Object
(
[elementary] => Northfield Elementary
[junior] => Siegel Middle School
[high] => Siegel High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2024-11-10T21:02:03Z
)
[office] => stdClass Object
(
[name] => John Jones Real Estate LLC
[broker_id] => 2421
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Melaine
[last] => Melton
)
[phone] => stdClass Object
(
[preferred] => 6153086173
[mobile] => 6153086173
)
[agent_id] => 63448
)
)
[media] => stdClass Object
(
[virtual_tours] => Array
(
[0] => https://www.facebook.com/MurfreesboroRealEstate/videos/559696929760246
)
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/0.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[description] => Inground pool and partial covered patio make for a great entertaining space!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/1.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/2.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/3.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[description] => This front formal dining room would make a perfect library as well!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/4.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/5.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/6.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[description] => The butlers pantry area just off the kitchen.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/7.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/8.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/9.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[description] => Beautiful ZLINE appliances and custom cabinets in this light and airy kitchen.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/10.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/11.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/12.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[description] => Past this eat-in area leads down into your den.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/13.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/14.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/15.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/16.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/17.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/18.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/19.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[description] => The primary suite also includes built-ins and it's own private bath.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/20.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/21.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/22.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[description] => The primary bedroom also has its own doors leading out to the backyard.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/23.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/24.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[description] => The secondary bath connects bedrooms two & three.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/25.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/26.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[description] => Check out this shower!!!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/27.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/28.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/28/440x.jpg
)
)
[29] => stdClass Object
(
[position] => 29
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/29.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/29/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/29/440x.jpg
)
)
[30] => stdClass Object
(
[position] => 30
[description] => Plenty of space in this laundry room with sink.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/30.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/30/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/30/440x.jpg
)
)
[31] => stdClass Object
(
[position] => 31
[description] => Huge den/rec space just off the kitchen!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/31.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/31/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/31/440x.jpg
)
)
[32] => stdClass Object
(
[position] => 32
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/32.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/32/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/32/440x.jpg
)
)
[33] => stdClass Object
(
[position] => 33
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/33.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/33/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/33/440x.jpg
)
)
[34] => stdClass Object
(
[position] => 34
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/34.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/34/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/34/440x.jpg
)
)
[35] => stdClass Object
(
[position] => 35
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/35.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/35/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/35/440x.jpg
)
)
[36] => stdClass Object
(
[position] => 36
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/36.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/36/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/36/440x.jpg
)
)
[37] => stdClass Object
(
[position] => 37
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/37.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/37/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/37/440x.jpg
)
)
[38] => stdClass Object
(
[position] => 38
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/38.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/38/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/38/440x.jpg
)
)
[39] => stdClass Object
(
[position] => 39
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/39.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/39/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/39/440x.jpg
)
)
[40] => stdClass Object
(
[position] => 40
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/40.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/40/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/40/440x.jpg
)
)
[41] => stdClass Object
(
[position] => 41
[description] => A shed that offers extra storage.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/41.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/41/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/41/440x.jpg
)
)
[42] => stdClass Object
(
[position] => 42
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/42.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/42/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/42/440x.jpg
)
)
[43] => stdClass Object
(
[position] => 43
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/43.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/43/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/43/440x.jpg
)
)
[44] => stdClass Object
(
[position] => 44
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2754249/44.jpg
[215x] => https://new.photos.idx.io/rt2/2754249/44/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2754249/44/440x.jpg
)
)
)
)
[key] => rt-2754249
[added_at] => stdClass Object
(
[$date] => 2024-10-31T16:30:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2754249
)
Interior Details
- Bedrooms3
- Bathrooms2
- Half Baths1
- BasementCrawl Space
- FeaturesBookcases, Built-in Features, Ceiling Fan(s), High Ceilings
- AppliancesDishwasher, Disposal, Refrigerator
- HVACArray
- Fireplaces1
Exterior Details
- ConstructionBrick
- Built In1972
- Stories1
- PoolIn Ground
- FeaturesStorage
- SewerPublic Sewer
- Lot Dimensions140 X 210.45 IRR
- Acres0.66