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 = 390 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 = 390 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 = 390 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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;

3254 Quail Ridge Drive
Chipley, FL 32428
Harvey Webb with Counts Real Estate Group, original listing - (850) 248-3615

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1596 Square Feet
Agency: Counts Real Estate Group
Agency Phone: (850) 248-3615

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Welcome to Leisure Lakes, a gated lake subdivision that offers a slower pace of life where residents enjoy amenities like a resort. This custom built is far different from homes in other subdivisions. Located in a private setting on 2.75 (+/-) acres, much of the property is fenced for pets or kids. Most of the trees are oaks that provide plenty of shade. The home has an open floor plan, 9 foot ceilings throughout, an electric fireplace, office area, covered porch, covered back patio that is screened to enjoy the cool evenings. The main bedroom suite is off the kitchen that features an island/breakfast bar with cabinets, granite counter tops, stainless steel appliances, pantry, and is adjacent to the dining area that overlooks the back yard. The main bathroom has a soaker tub, a standup shower, his and hers closets, a toilet closet, and 2 sinks in a large counter top and drawers and doors below. The split bedroom design has the main suite just off the kitchen. It has a walk-in pantry with shelving, and a separate laundry room with shelves. The floors look like vinyl planks but actually are ceramic tiles and run throughout the custom home. The living room has a writing area by 2 large windows to view the landscaped front yard. A great feature is a large, screen room to enjoy some outdoor living. It has 2 ceiling fans with light kits, string accent lighting, and a door that leads to an uncovered deck for a grilling station. There are 2 sheds in the back yard that has a concrete block fire pit, fenced and cross fenced, bird bath and feeders, and lots of oak trees. The tall pole barn is great for RV storage and has 50 amp service. Also is an attached workshop that has electric service just as the 2 sheds in the back yard. The 2-car garage has a storage closet, and a door that leads to a side deck that is partially covered inside the fenced yard. The corner lot is flat and much of the land is not currently used, but would good for a horse or a large garden. All property owners can enjoy the amenities at the recreation area including a swimming pool, toddler playground, men's and women's restrooms, covered pavilion with picnic tables, grill stations, basketball court, tennis court, and a concrete boat launch. Live security gate guards are on duty weekdays. Click on the 'Photos' tab to see the many photos, and click on 'Documents' to see more information. The hot tub does not remain.
MlsNumber: --
ListingId: 772785


Listing Provided By: Counts Real Estate Group, original listing
Phone: (850) 248-3615
Office Phone: (850) 248-3615
Agent Name: Harvey Webb
Disclaimer: Copyright © 2025 Central Panhandle Association of REALTORS. 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