Skip main navigation
For sale
  • $138,900

    574 Queen Palm St, Largo, FL 33778

    2beds
    945sqft
    : 
    Mobile Home
    Built in 1978
    163.91 Acres Lot
    $-- Zestimate®
    $147/sqft
    $554/mo HOA

    What's special

    Large carportClosed lanaiEn-suit bathroomWasher and dryerBright sunny kitchenNew bosch dishwasher
    Welcome to Palm Hill Country Club and Golf Community. This well maintained double wide mobile home is move in ready and has been fully updated. This is a 2 bedroom 2 bath unit with an open living room dining room floor plan. There is a large carport with lots of space for entertaining and parking adjacent to a closed lanai and next to an enclosed shed with washer and dryer and plenty of storage. The large master bedroom has a spacious en-suit bathroom along with a separate room with commode and walk in shower. The 2nd bedroom is also spacious. The bright sunny kitchen has a new Bosch Dishwasher and all appliances are included. A/C 2021, Lanai Windows 2022, Lanai tile 2022, Roof over 2017 and seams and screws sealed 1/21, New Commodes 2021, New floors & plywood 2017, Upgraded electric 2017, New 40 Gallon Hot Water Tank 2022, New vinyl window 2017, Irrigation System Updated 2022, New Irrigation controller & Driveway Painted 2021. Centrally located in Largo where shopping, dining and theatre are within 5 minutes. The share value of $35K is included in the Purchase Price. Palm Hill Country Club has lots of amenities such as a Nine hole par 30 Golf Course with Pro Shop. Two Clubhouses, each with a Recreation Club. Three Swimming Pools and Jacuzzis with sun decks in each of the two recreation areas. Three Tennis Courts, Two Bocce Courts, Two complete sets of Shuffleboard Courts, one completely enclosed, Two Billiard Rooms, Horseshoe Pit, Bicycle Club, Pickleball Court, Two Libraries and Two Laundry Facilities. Motorcycles prohibited, however; scooters and mopeds up to 50cc are allowed.
    202 days
    on Zillow
    |
    55
    |
    1
    |

    Zillow last checked: 7 hours ago

    Listing updated: August 17, 2025 at 05:55am

    Listing Provided by:

    Dana Heston 813-431-9118,

    CHARLES RUTENBERG REALTY INC 727-538-9200

    Source: Stellar MLS,MLS#: TB8347685MLS LogoOriginating MLS: Suncoast Tampa

    Travel times

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 2
    • Bathrooms: 2
    • Full bathrooms: 2
    Primary bedroom
    • Features: Built-in Closet
    • Level: First
    • Area: 140 Square Feet
    • Dimensions: 14x10
    Bedroom 2
    • Features: Built-in Closet
    • Level: First
    • Area: 104.4 Square Feet
    • Dimensions: 11.6x9
    Primary bathroom
    • Level: First
    • Area: 40 Square Feet
    • Dimensions: 10x4
    Bathroom 2
    • Level: First
    • Area: 38.7 Square Feet
    • Dimensions: 8.6x4.5
    Balcony porch lanai
    • Level: First
    • Area: 132 Square Feet
    • Dimensions: 12x11
    Great room
    • Level: First
    • Area: 221 Square Feet
    • Dimensions: 13x17
    Kitchen
    • Level: First
    • Area: 100 Square Feet
    • Dimensions: 10x10
    Heating
    • Central
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Disposal, Dryer, Electric Water Heater, Exhaust Fan, Microwave, Range, Refrigerator, Washer
    • Laundry: Other
    Features
    • Open Floorplan, Thermostat
    • Flooring: Luxury Vinyl
    • Windows: Window Treatments
    • Has fireplace: No
    Interior area
    • Total structure area: 1,480
    • Total interior livable area: 945 sqft
    Video & virtual tour

    Property

    Parking
    • Total spaces: 2
    • Parking features: Carport
    • Carport spaces: 2
    Features
    • Levels: One
    • Stories: 1
    • Exterior features: Irrigation System
    Lot
    • Size: 163.91 Acres
    Details
    • Parcel number: 033015656840015740
    • Special conditions: None

    Construction

    Type & style
    • Home type: MobileManufactured
    • Property subtype: Mobile Home
    Materials
    • Metal Frame
    • Foundation: Pillar/Post/Pier
    • Roof: Membrane,Metal,Roof Over
    Condition
    • Completed
    • New construction: No
    • Year built: 1978

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: BB/HS Internet Available, Cable Connected, Electricity Connected, Sewer Connected, Sprinkler Recycled, Street Lights, Water Connected
    Green energy
    • Water conservation: Irrigation-Reclaimed Water

    Community & HOA

    Community
    • Features: Clubhouse, Deed Restrictions, Golf Carts OK, Golf, Irrigation-Reclaimed Water, Tennis Court(s)
    • Senior community: Yes
    • Subdivision: PALM HILL MOBILE HOME PARK UNREC
    HOA
    • Has HOA: Yes
    • Amenities included: Golf Course, Optional Additional Fees, Pool
    • Services included: Cable TV, Community Pool, Reserve Fund, Internet, Maintenance Grounds, Manager, Recreational Facilities, Sewer, Trash, Water
    • HOA fee: $554 monthly
    • HOA name: Megan DiBello
    • HOA phone: 727-581-8729
    • Pet fee: $0 monthly
    Location
    • Region: Largo

    Financial & listing details

    • Price per square foot: $147/sqft
    • Tax assessed value: $89,630
    • Annual tax amount: $464
    • Date on market: 2/8/2025
    • Cumulative days on market: 203 days
    • Listing terms: Cash
    • Ownership: Co-op
    • Total actual rent: 0
    • Electric utility on property: Yes
    • Road surface type: Asphalt
    • Body type: Double Wide
    • Loading