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

4523 166th Place
Wellborn, FL 32094
Susanna Dicks with UNITED COUNTRY DICKS REALTY, original listing - (386) 752-8585

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $630,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1782 Square Feet
Agency: UNITED COUNTRY DICKS REALTY
Agency Phone: (386) 752-8585

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: This newly constructed country home, completed in 2023, offers a modern and luxurious living space with 3 bedrooms, 1 office/gym, and 2 bathrooms. Enjoy high-speed Rapid Fiber internet connectivity, perfect for remote work or streaming.The kitchen is fully equipped with quartz countertops, a stainless farmhouse sink, kitchen island with breakfast bar that adds both counter space and seating, top-of-the-line LG appliances including a fridge, dish washer, microwave, and stove with an 800 CFM range hood.The laundry room has a matching Samsung washer and dryer make laundry a breeze.It has a lovely front porch, and a full length back porch with an outdoor entertainment area.The home is outfitted with a gutter system with pop-up yard drains, a water softening system, and operates on well water and septic.You'll find fiberglass double bore doors, YKK windows, and architectural shingles.The 8’ interior and exterior doors add a touch of elegance, while security cameras ensure peace of mind. Each room is equipped with Ethernet connections.There is a control panel box for the Ethernet along with PEX plumbing. The living areas and bedrooms feature durable LVP flooring, while the master bath boasts oversized tile.Outside, a 24x36 carport with a gutter system provides covered parking. The property sits on 1.2 acres of cleared land out of a total 4.73 acres, with lush centipede grass, an orange tree, a lemon tree, and a chicken coop adding to the charm of the surroundings. (Use Google Maps)
MlsNumber: --
ListingId: 124577


Listing Provided By: UNITED COUNTRY DICKS REALTY, original listing
Phone: (386) 365-3307
Office Phone: (386) 752-8585
Agent Name: Susanna Dicks
Disclaimer: Copyright © 2024 North Florida MLS. 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