Title Page Background
DEBUG FN args: Array ( [0] => 3343 [1] => [2] => [3] => agent ) BEFORE: Site: 3343 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3343 Igate: njhud LocID: 3343 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3343 AND i.igate IN ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3343 [1] => [2] => [3] => lender ) BEFORE: Site: 3343 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3343 Igate: njhud LocID: 3343 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3343 AND i.igate IN ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3343 [1] => [2] => [3] => other ) BEFORE: Site: 3343 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3343 Igate: njhud LocID: 3343 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3343 AND i.igate IN ('flhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2420 Pier Drive
Ruskin, FL 33570

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $239,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1920 Square Feet
Agency: Sunny Days Manufactured & Mobile Home Brokers, LLC
Agency Phone: (813) 296-1666

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Other-Mobile Home
Year Built: 2005
Notes: Welcome to 2420 Pier Drive, an exceptional home in the Riverside Club Golf & Marina Community. This 2005 Palm Harbor residence is a haven of comfort, style, and accessibility, ideal for both full-time living and vacation getaways. With its thoughtful design and extensive updates, this home is ready to welcome you. As you arrive, you'll immediately appreciate the 6 CAR ELONGATE DRIVEWAY and spacious 2-CAR GARAGE, offering ample storage for all your needs. The home's layout is perfect for handicapped individuals with an extra long handicap concrete ramp and rails, also inside with extra-large doors and hallways that allow easy access for wheelchairs and walkers. Entering the home from the driveway and moving into the kitchen, you'll discover an impressive LAUNDRY ROOM, fully equipped with an upgraded LG washer and dryer, a sink, and ample cabinetry that will surely impress. The heart of this home is the EAT-IN KITCHEN, featuring a large double sink, abundant counter and cabinet space, all newer LG appliances making it a dream for cooking enthusiasts. The connected bright and airy living room boasts Step into the expansive LIVING ROOM, where ample space meets comfort and style. This generously sized room is perfect for entertaining guests or enjoying cozy family nights. Natural light floods the area, highlighting the elegant features such as a tray ceiling, crown molding, and double-pane hurricane-proof windows that flood the space with natural light. making the room feel even more welcoming. Adjacent to the living room is a spacious DINING ROOM, designed to host everything from intimate dinners to large gatherings. The seamless flow between the living and dining areas creates an open-concept feel, perfect for both daily living and special occasions. Whether you're hosting a dinner party or simply relaxing with a good book, these rooms provide the ideal setting for all your needs. This home boasts a well-designed SPLIT-LAYOUT, offering maximum privacy and convenience. The spacious MASTER BEDROOM is a true retreat complete with an ensuite bathroom that includes a handicap tub/shower combo, double vanity, and a walk-in closet and is located on one side of the home, and on the opposite side, you'll find the guest bedroom and bathroom, perfect for accommodating visitors. The guest bathroom is also thoughtfully equipped with a handicap tub/shower combo and a single sink vanity, ensuring comfort and accessibility for all. The LANAI is fully enclosed and equipped with a SPLIT A/C and heating unit, offering the perfect spot to watch golfers on the 6th hole fairway. It's another wonderful space to entertain guests, providing comfort and a scenic view in any season. Enjoy the charming front covered porch, perfect for morning coffee or evening cocktails while greeting friendly neighbors. Recent updates include hurricane windows, a water filtration system, and blinds installed in 2019. The main roof was replaced in 2023, and the lanai roof in 2021, ensuring peace of mind for years to come. But wait, there's more! This home boasts a whole-house KOHLER GENERATOR, fueled by an underground propane tank, providing seamless power during outages. As if that weren't enough, the sale also includes a golf cart and a 24-foot pontoon boat with a trailer, offering unparalleled value and convenience. Don't miss out on this incredible opportunity - it's truly the deal of a lifetime! Riverside Club is a five-star resort community for ages 55+, offering unparalleled amenities such as two clubhouses, two heated pools, a riverfront bar & grill, a private marina, fenced dog parks, shuffleboard, pickleball courts, a fitness room, sauna, and a Lifestyles office. Daily planned activities ensure there's always something to do. Please note, while we provide accurate listing information, we recommend independent home inspections for assurance. Additionally, lot rents are determined by the community office.
MlsNumber: --
ListingId: 11282648


Listing Provided By: Sunny Days Manufactured & Mobile Home Brokers, LLC, original listing
Phone: (813) 296-1666
Office Phone: (813) 296-1666
Agent Name: Darlene Colombo
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 Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => hillsborough-southeast [3] => FL [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: hillsborough-southeast State: FL Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: hillsborough-southeast State: FL Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3343 AND i.igate IN ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Joe Spellman NMLS# 2142845
Joe Spellman NMLS# 2142845
ASCIIFamily First Mortgage USA empowered by NEXA
Call Today!: (863) 559-8288

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App