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 = 483 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 = 483 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 = 483 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;

5842 Riviera Prado
Lake Park, GA 31636
Victoria Ordway with Canopy Realty Group, original listing - (229) 630-2400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,900
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 2157 Square Feet
Agency: Canopy Realty Group
Agency Phone: (229) 630-2400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1980
Notes: Come on down South where you can vacation all year round in this contemporary home located on beautiful long pond(twin lakes) where you can ski, swim, fish, or just go boat riding. Step into the large kitchen & have a seat at the large wrap around bar with granite tops. Lots of cabinets, pretty cherry wood cabinets black appliances, tons of counter space all opening up to gorgeous sunken great room with high soaring wood ceiling & very large stone fireplace. all glass wall with sliding doors leading out to a 644 feet of deck. Outside on the deck you will be overlooking the lake & the gunite pool which has a tanning ledge. All of this outdoors is perfect for entertaining your friends or family. Inside you will have Two bedrooms downstairs with very unique hall bath, nice tile shower, & laundry area. Upstairs you will find the large master suite vaulted wood ceiling, with nice bath overlooking the great room downstairs. You have a view of the lake from the upstairs master bedroom. Solid wood doors and lots of built in wood cabinets in bedrooms and extra built ins in kitchen. Need extra room for guest? Look at the 1110 square foot garage apartment which can be rented out, or use as a mother in law suite. Great storage in the garage under the apartment. 70 feet on the water. Come enjoy the nice quite life at the quaint little town of Lake Park.
MlsNumber: --
ListingId: 143476


Listing Provided By: Canopy Realty Group, original listing
Phone: (229) 563-6066
Office Phone: (229) 630-2400
Agent Name: Victoria Ordway
Disclaimer: Copyright © 2025 South Georgia MLS (Valdosta). 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