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

590 Raulerson Road #1
Seville, FL 32190
Christie Di Lemme with Florida Homes Realty and Mortgage, original listing - (904) 996-9115

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,247,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 3752 Square Feet
Agency: Florida Homes Realty and Mortgage
Agency Phone: (904) 996-9115

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: MOTIVATED SELLER - SCHEDULE A PRIVATE TOUR! This move-in ready, 3,752 sq foot 10 Acre Country Estate is perfectly positioned at the end of the road adjacent to over 4,000 acres of protected lands that can never be built on. While it's located just two miles off Hwy 17, you can't hear any road noise, and there's no traffic constantly driving by the home. There are also huge oak trees that provide shade for horses, livestock, and other animals. Neighbors are few and far between. It's serene, secure, and secluded for your privacy yet only a short drive to monumental growth that will skyrocket your property value including the much-anticipated Bass Pro Shops development. Enjoy the peace and quiet of this ranch 3 bedroom, 2 bath home with an office that could be converted to a fourth bedroom. Featuring a resort style saltwater pool in a country setting with No HOA. A gated entrance leads you into the front yard of the estate. Upon entrance, you're greeted by hardwood floors and an open floor plan seamlessly connecting the dining room, kitchen, and living room. Meticulous attention to detail is presented in the kitchen with custom cabinets, stainless-steel appliances, and two pantries with tons of storage. Cathedral ceilings, French doors and oversize windows invite you to your country getaway. Walk outside to your backyard oasis complete with a saltwater pool surrounded by a brick paver deck, fence, and palm trees for privacy. The pool cabana is air conditioned with a loft, shower, and kitchenette complete with microwave, refrigerator, and table. There's also a grilling area. The single level home features two guest rooms, that comfortably fit king beds, with spacious closets. A full bathroom with a cabinet, sink and closet, is centrally located between the two guest rooms. There's also an office that could be converted into another bedroom. On the opposite side of the home, you'll enter into your own private retreat featuring an oversized master bedroom with vaulted ceilings and ceiling fan, a walk-in closet, a tiled master bathroom with custom cabinets, double vanities, soaking tub, closet, and walk-in shower. The master bedroom has direct access to the sunroom overlooking the saltwater pool. The outdoor area boasts two fenced pastures with water troughs and an open wooded area. A 24 x 32 barn with two lean-tos (sheds) on each side provides storage for machinery, supplies, etc. There are horse/livestock pens on the north side of the barn and dog kennels on the backside plus two small chicken coops across from the barn. A 4 foot well that pumps 93 gallons per minute provides water to the house, paddocks, and land. In addition to a personal residence, other opportunities for this property include Airbnb rentals, horse stables, livestock grazing, camping (tents & RVs), etc. There's plenty of space for parking and to add additional structures. To the East of the property is the Crescent Lake Conservation Area, a habitat for wildlife including eagles, osprey, and waterfowl. Perfect for biking, horseback riding, hiking, camping, and more. While the property is secluded, it's still close to Daytona Beach, Ocala, Orlando, and Flagler Beach. Plus you're minutes away from Crescent City, the bass capital of the world! Local shopping is within 15 minutes. Furnishings are negotiable. Property is well-cared and ready for you! ALL OFFERS are considered by motivated sellers, the original owners.
MlsNumber: --
ListingId: 11317701


Listing Provided By: Florida Homes Realty and Mortgage, original listing
Phone: (561) 644-0578
Office Phone: (904) 996-9115
Agent Name: Christie Di Lemme
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 3220 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;
Real Estate Expert Photo for Sharlene Barhoo
Sharlene Barhoo
UTF-8WEICHERT, REALTORS® - Hallmark Properties
Call Today!: (386) 334-6822

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App