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

40703 Stewart Rd
Dade City, FL 33525

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $49,900
Beds: 1
Baths: 1
Status: Active
SqFt: 483
Agency: Sandbar RV Resort

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: --
Notes: Amazing Deal: 2023 Cottage Park Model - Only $49,900!Discover the epitome of style and comfort in this charming Cottage Park Model, now available at an unbeatable price! Don't miss out on this incredible opportunity!Enjoy modern touches throughout the home, including recessed lighting and soft-close shaker cabinetry. Bask in natural light streaming through oversized windows, creating a bright and airy atmosphere. The kitchen boasts ample storage with a pantry, full-size gas stove and refrigerator, deep stainless-steel sink, and elegant granite countertops. Indulge in luxury with a spacious bathroom featuring a step-in shower with glass door enclosures, tile surround, transom window for additional lighting, and both handheld and rain shower heads. Step outside to your inviting front porch, perfect for savoring morning coffee or evening drinks.Enhanced exterior features include upgraded Hardi board cement siding and a durable metal roof, providing both elegance and superior protection. Must-See to Appreciate! Don't let this opportunity slip away. Schedule your viewing today and envision yourself living in the lap of luxury at an unbeatable price!Luxurious Living with Resort-Style Amenities!Immerse yourself in the ultimate leisure lifestyle with breathtaking views of the pool and clubhouse right across from your new home. Get ready to experience a community like no other, offering a plethora of amenities to enhance your daily life.Amenities Include:Shuffleboard, Cornhole, and Horseshoes: Challenge your friends and neighbors to friendly competitions near the pavilion, where fun is always on the agenda.Poolside Bliss: Dive into relaxation mode with easy access to the sparkling pool, perfect for soaking up the sun or enjoying a refreshing swim.Billiards in the Pavilion: Gather for a game of pool in the pavilion, where laughter and camaraderie fill the air.Furry Friend Haven: Treat your beloved pet to playtime at the dog park, just a stone's throw away from your doorstep.Stay Active with Ease:Embrace a healthy lifestyle effortlessly with the convenience of a scenic walk around the community. Whether you're looking for a brisk morning jog or a relaxing evening stroll, the well-maintained pathways offer the perfect setting to get your steps in while enjoying the beauty of your surroundings.From active recreation to serene relaxation, there's something for everyone in this vibrant community. Don't miss out on the chance to elevate your lifestyle with these incredible amenities!Schedule your viewing today and discover the epitome of resort-style living right at your fingertips. Your dream lifestyle awaits!
MlsNumber: 11164771


Listing Provided By: Sandbar RV Resort, original listing
Name: Sandbar RV Resort
Phone: (352) 567-8667
Office Name: Sandbar RV Resort
Office Phone: (352) 567-8667
Agent Name: Martha Rosbough
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 = 374 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 Jason Slone
Jason Slone
ASCIILPT Realty
Call Today!: (727) 505-7700

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App