Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 532 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 532 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 532 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

3006 White Oak Court
Lagrange, GA 30240

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $524,900
Beds: 4
Baths: 5
Status: Pending
SqFt: 3834
Agency: GO Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1987
Notes: Welcome home to this traditional colonial plantation home featuring a rocking chair front porch in the coveted Riverside community which offer tennis courts and a playground. The entry-way foyer will welcome you to the main level with 10 foot ceilings, crown molding, HARDWOOD FLOORING THROUGHOUT and a grand staircase leading to the second level. On the main level you will find the living room and den both boasts BUILT-IN SHELVINGS, PLANTATION SHUTTERS, and a pocket door leading from the living room to the den where you will want to spend your winter nights by the wood burning fireplace. The kitchen has been updated with a DOUBLE OVEN, farm sink, granite countertops, LARGE ISLAND, lighted glass cabinets, pantry, garbage disposal, BAY WINDOW, window treatment, and an entryway to the screened in porch and open deck. The separate dining room also features plantation shutters and is large enough to fit the entire family and the neighbors. Even the laundry room in this home is grand having built in cabinets, a sink, and shelving! On the second level you will find the hardwood flooring remains throughout, 9 ft ceilings, crown molding, and chair rail. The master suite has built-in shelving, a door to the upper balcony and a sitting area. The master bathroom features a spa tub, two separate marble top vanities with a cherry base, not one but TWO WALK-IN CLOSETS, and a tiled walk-in shower! The two additional bedrooms upstairs both feature their own suite with granite vanity and tub/shower. Upstairs you also will also find an office and an attic with appx 1,600 sq ft of storage with a cedar lined closet. The basement features approximately 800 sq ft of living space including a bathroom and an exterior entry from the oversized garage. If all of this isn't enough you will be delighted to know there is a marathon water heater with LIFETIME WARRANTY, BRAND NEW SEPTIC, HVAC REPLACED within last 5 years, recently replaced dishwasher, and BRAND NEW ROOF. THE SELLER IS PROVIDING HOME WARRANTY and credit towards interior paint. This home has been maintained with the utmost care. Outside you will enjoy a picket fence garden, the arbor with stone pathway, firepit, playhouse and wood shed. The home is a heaven for those who enjoy plants having multiple fruit bearing trees & shrubs and an abundance of blooming flowers. Schedule your showing today and spend Christmas in the home of your dreams!
MlsNumber: 20173932


Listing Provided By: GO Realty, original listing
Name: GO Realty
Phone: (706) 884-3882
Office Name: Go Realty
Office Phone: (706) 884-3882
Agent Name: Vickie Smith
Disclaimer: Copyright © 2024 Georgia Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App