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

8470 Ne 118th Terrace
Bronson, FL 32621

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $289,389
Beds: 5
Baths: 3
Status: Active
SqFt: 1976
Agency: Florida Homes Realty and Mortgage LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 2005
Notes: Welcome to your private oasis on over four acres of picturesque land! This enchanting 5-bedroom, 3-bathroom mobile home not only offers spacious living but also boasts delightful outdoor amenities, including an above-ground pool, spacious deck, and charming front porch. Step inside to discover a bright and airy living area, perfect for hosting gatherings or simply relaxing with loved ones. The well-equipped kitchen features modern appliances and a convenient dining area, making mealtime a joy. Retreat to the generously-sized bedrooms, each offering comfort and tranquility, with plush carpeting and ample closet space. The master suite is a true retreat, complete with a private en-suite bathroom featuring a luxurious soaking tub. Outside, the fun continues with an inviting above-ground pool, ideal for cooling off on hot summer days. Lounge on the spacious deck, perfect for barbecues and outdoor entertaining, or unwind on the charming front porch and soak in the serene surroundings. Set on over four acres of land, there's plenty of room for gardening, recreation, and enjoying the great outdoors. Conveniently located in the outskirt of Bronson and only minutes from Archer and Gainesville, Florida, this property offers the perfect blend of privacy and convenience. Don't miss your chance to experience the ultimate in country living - schedule a showing today and make this your own slice of paradise!
MlsNumber: GC520958


Listing Provided By: Florida Homes Realty and Mortgage LLC, original listing
Name: Florida Homes Realty and Mortgage LLC
Phone: (904) 363-8395
Office Name: FLORIDA HOMES REALTY & MORTGAGE LLC
Office Phone: (352) 240-1133
Agent Name: Xavrae Burse
Disclaimer: Copyright © 2024 Stellar 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