Skip main navigation
For sale
  • Price cut: $5K (3/8)
    $110,000

    574 Queen Palm St, Largo, FL 33778

    2beds
    945sqft
    : 
    Manufactured Home, Single Family Residence
    Built in 1978
    163.91 Acres Lot
    $-- Zestimate®
    $116/sqft
    $554/mo HOA

    What's special

    Large carportClosed lanaiWasher and dryerBright sunny kitchenNew bosch dishwasher
    PRICE REDUCTION.....Welcome to Palm Hill Country Club and Golf Community. This well maintained double wide mobile home is move in ready. This is a 2 bedroom 2 bath unit with an open living room dining room floor plan. There is a large carport 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. Furnishing included except some decorative items. 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.
    399 days
    |
    965
    |
    12
    |

    Zillow last checked: 7 hours ago

    Listing updated: March 08, 2026 at 11:17am

    Listing Provided by:

    Dana Heston 813-431-9118,

    CHARLES RUTENBERG REALTY INC 727-538-9200

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

    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: 1
    • Parking features: Carport
    • Carport spaces: 1
    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: Manufactured Home, Single Family Residence
    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: $116/sqft
    • Tax assessed value: $89,630
    • Annual tax amount: $464
    • Date on market: 2/8/2025
    • Cumulative days on market: 399 days
    • Listing terms: Cash
    • Ownership: Co-op
    • Total actual rent: 0
    • Electric utility on property: Yes
    • Road surface type: Asphalt
    • Body type: Double Wide
    Dana Heston

    (813) 431-9118

    By pressing Contact Agent, you agree that the real estate professional identified above may call/text you about your search, which may involve use of automated means and pre-recorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you're looking for in a home.

    Estimated market value

    Not available

    Estimated sales range

    Not available

    $1,747/mo

    Price history

    Price history
    DateEventPrice
    3/8/2026Price change$110,000-4.3%$116/sqft
    Source: Stellar MLS #TB8347685 Report a problem
    2/19/2026Price change$115,000-4.2%$122/sqft
    Source: Stellar MLS #TB8347685 Report a problem
    1/21/2026Price change$120,000-4%$127/sqft
    Source: Stellar MLS #TB8347685 Report a problem
    12/2/2025Price change$125,000-7.4%$132/sqft
    Source: Stellar MLS #TB8347685 Report a problem
    10/25/2025Price change$135,000-2.8%$143/sqft
    Source: Stellar MLS #TB8347685 Report a problem
    2/8/2025Listed for sale$138,900$147/sqft
    Source: Stellar MLS #TB8347685 Report a problem

    Public tax history

    Public tax history
    YearProperty taxesTax assessment
    2024$465 +0.6%$66,004 +3%
    2023$462 -14.3%$64,082 +3%
    2022$539 -49.9%$62,216 +15.4%
    2021$1,075 -2%$53,903 -0.5%
    2020$1,098 +25.6%$54,196 +26.6%
    2019$874 $42,797 -8.7%
    2018$874 -9.9%$46,850 -3.5%
    2017$970 +17%$48,555 +10.3%
    2016$829 +6.2%$44,001 +7%
    2015$780 +19.1%$41,121 +33.7%
    2014$655 +3.5%$30,753 +4.7%
    2013$633 -1.2%$29,369 -2.2%
    2012$640 $30,031 -10%
    2011-- $33,383 +6.9%
    2010-- $31,228 -1.7%
    2009-- $31,755 -32.9%
    2004$1,039 +15.4%$47,300 +10.8%
    2003$900 +16.8%$42,700 +26%
    2002$770 $33,900 -7.6%
    2001$770 $36,700

    Find assessor info on the county website

    BuyAbility℠ payment

    Est. payment
    $1,287/mo
    Principal & interest
    $567
    HOA Fees
    $554
    Property taxes
    $166
    More affordability tools

      Climate risks

      Neighborhood: Palm Hill

      Getting around

      34 / 100
      Car-Dependent
      32 / 100
      Some Transit
      51 / 100
      Bikeable

      Nearby schools

      GreatSchools rating

      Similar homes

      Skip to the end of the carouselSkip to the beginning of the carousel