CONTACT
FAVORITE
SHARE
CLAIM

574 QUEEN PALM STREET LARGO FL 33778

$135,000
$138,900
USD CAD EUR GBP BTC
Reduced
574 QUEEN PALM STREET, LARGO, FL 33778 - MLS#MFRTB8347685 574 QUEEN PALM STREET, LARGO, FL 33778 - MLS#MFRTB8347685 574 QUEEN PALM STREET, LARGO, FL 33778 - MLS#MFRTB8347685 574 QUEEN PALM STREET, LARGO, FL 33778 - MLS#MFRTB8347685

Zev Freidus Broker / President
Zev Freidus
Broker / President
561-235-2161
Call Me
Text Me
Email Me
When clicking Request Info, you are registering to this website and agreeing that ZFC Real Estate, its affiliates or associated third parties may contact you, including with calls or texts by automated means. You also agree to our Terms of Use and Privacy Policy

Overview of 574 Queen Palm St

2 Bedrooms
2 Bathrooms
Car Garage
1,480 Square Feet
945SF Living Area
Pool:
No
Water: None
Year Built 1978
Listed For 261 Days

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.

This lovely property was built in 1978 and features 2 bedrooms, and 2 full bathrooms. This property for sale is 1,480 square feet, with 945 sq ft being air conditioned living space. The property has a does not have a private swimming pool, although there is a community pool in the complex for use by residents.

Directions to this property are as follows: From The Intersection Of Ulmerton Road And Seminole Blvd. Head North About Half A Mile And Turn Left Into Palm Hill Country Club (sign) Onto Sea Oats Dr And Turn Left Onto Fern Pam St To Queen Palm And Turn Right. Follow About 150 Feet To Property.

Please contact your ZFC agent for more information about MLS# MFRTB8347685 or any other properties for sale in Largo or elsewhere in the Pinellas County area.

Features & Amenities

Appliances

Dishwasher, Disposal, Dryer, Electric Water Heater, Exhaust Fan, Microwave, Range, Refrigerator, Washer

Other Equipment

Irrigation Equipment

Cooling

Central Air

Heating

Central

Flooring

Luxury Vinyl

Lot Size

7139837

View

view

Construction Materials

Metal Frame

Interior Features

Open Floorplan, Thermostat, Window Treatments

Furnished

Partially

Property Condition

Completed

Roof

Membrane, Metal, Roof Over

Utilities

B B/H S Internet Available, Cable Connected, Electricity Connected, Sewer Connected, Sprinkler Recycled, Water Connected

Laundry

Other

Year Built

1978

Pets Allowed

No

Annual Real Estate Taxes

$465 (2024)

Legal Description

Palm Hill Mobile Home Park (unrec) Blk 1, Lot 574 (aka Blk 001, Lot 5740 Per O.r. 9271/1384)

Property Type

Manufactured Home

HOA Fees

$554 /Monthly

Association Fee Includes

Cable T V, Pool, Escrow Reserves Fund, Internet, Maintenance Grounds, Management, Recreational Facilities, Sewer, Trash, Water

Association Amenities

Golf Course, Optional Additional Fees, Pool

Community Features

Clubhouse, Deed Restrictions, Golf Carts O K, Golf, Irrigation-Reclaimed Water, Tennis Court(s), Street Lights

Age Restricted

Yes

Direction Faces

South

MLS Number

MFRTB8347685

Universal Property Id

U S-12103-N-033015656840015740-R-N

Days On Market

261

Community Name

Palm Hill Mobile Home Park Unrec

574 Queen Palm St Price Calculator

Get Mortgage Quote For This Property

The payment calculator figures for 574 Queen Palm St should be used as an estimate only. Loan terms including interest rate, and required downpayment will vary with each lender and/or individual. RE taxes for this property for sale are estimated based on the actual property taxes for this property for the tax year 2024 which are $465 but will likely change when this property sells. These estimations are calculated from a list price of $135,000 and a 25% down payment and do not include homeowners insurance which will vary greatly depending on the property characteristics and location.

Recent Property Sales near 574 Queen Palm St

Address Sale Price Bed Bth Size Location Sale Date
624 QUEEN PALM ST $Log in to view 2 2/0 1,480SF Palm Hill Mobile Home Park Unrec 06/19/2025
567 QUEEN PALM ST $Log in to view 2 2/0 2,175SF Palm Hill Mobile Home Park Unrec 04/18/2025
711 SUGAR PALM ST $Log in to view 2 2/0 2,160SF Palm Hill Mobile Home Park Unrec 04/21/2025
63 ROYAL PALM CIR $Log in to view 2 2/0 2,140SF Palm Hill Mobile Home Park Unrec 04/11/2025
833 CANE PALM ST $Log in to view 2 2/0 2,032SF Palm Hill Mobile Home Park Unrec 03/27/2025
147 FERN PALM ST $Log in to view 2 2/0 1,996SF Palm Hill Mobile Home Park Unrec 08/27/2025
225 ROYAL PALM CIR $Log in to view 2 2/0 1,944SF Palm Hill Mobile Home Park Unrec 08/01/2025
135 ROYAL PALM CIR $Log in to view 2 2/0 1,800SF Palm Hill Mobile Home Park Unrec 04/23/2025
374 KING PALM ST $Log in to view 2 2/0 1,744SF Palm Hill Mobile Home Park Unrec 06/26/2025
30 ROYAL PALM CIR $Log in to view 2 2/0 1,658SF Palm Hill Mobile Home Park Unrec 12/20/2024
266 SAGO PALM ST $Log in to view 2 2/0 1,494SF Palm Hill Mobile Home Park Unrec 11/13/2024
573 QUEEN PALM ST $Log in to view 2 2/0 1,468SF Palm Hill Mobile Home Park Unrec 02/19/2025

MLS# MFRTB8347685 Listing History

02/08/2025 Listed for sale by CHARLES RUTENBERG REALTY INC with MLS# MFRTB8347685 with a list price of $138,900.

Pinellas County Schools

Elementary School

Middle School

High School

Public Transportation

Pinellas Suncoast Transit Authority:

Route 61 INDIAN ROCKS SHOPPING CTR/WESTFI

Pinellas Suncoast Transit Authority:

Route 61 INDIAN ROCKS SHOPPING CTR/WESTFI

Pinellas Suncoast Transit Authority:

Route 61 INDIAN ROCKS SHOPPING CTR/WESTFI

Pinellas Suncoast Transit Authority:

Route 61 INDIAN ROCKS SHOPPING CTR/WESTFI

Pinellas Suncoast Transit Authority:

Route 18 ST PETERSBURG/CLEARWATER

This listing of 574 Queen Palm St Largo FL 33778 was last updated on 2025-10-27 17:13:05. Listing courtesy of CHARLES RUTENBERG REALTY INC.
MLS

Map of 574 Queen Palm St Largo FL 33778

Similar Properties For Sale

25 Thatch Palm St W, LARGO
$269,000

MLS#MFRTB8428638

25 Thatch Palm St W
Largo, FL 33770

2

2

129 Royal Palm Cir, LARGO
Reduced
$159,000
$180,000

MLS#MFRTB8418462

129 Royal Palm Cir
Largo, FL 33778

2

2

48 Palm Forest Dr, LARGO
Under Contract
$125,000
$131,500

MLS#MFRTB8404184

48 Palm Forest Dr
Largo, FL 33770

2

2

778 Royal Palm Cir, LARGO
$174,000

MLS#MFRTB8363609

778 Royal Palm Cir
Largo, FL 33778

2

2

45 Royal Palm Cir, LARGO
Under Contract
$109,500
$119,500

MLS#MFRTB8397702

45 Royal Palm Cir
Largo, FL 33778

2

2

825 Coconut Palm St, LARGO
$195,000

MLS#MFRTB8374519

825 Coconut Palm St
Largo, FL 33778

2

2

Zev Freidus Broker / President
Zev Freidus
Broker / President
561-235-2161
Call Me
Text Me
Email Me
When clicking Submit Request, you are registering to this website and agreeing that ZFC Real Estate, its affiliates or associated third parties may contact you, including with calls or texts by automated means. You also agree to our Terms of Use and Privacy Policy

The data relating to homes for sale or lease or other real estate for sale or for rent on the ZFC website comes in part from a cooperative data exchange program of the MLS in which this Broker participates. The real estate displayed may not be all of the homes in the database, or all of the properties listed with Brokers participating in the cooperative data exchange program. Homes for sale that are listed by Brokers other than this Broker are marked with either the listing Broker's name or the MLS name or a logo provided by the MLS and the details page about such properties includes the name of the listing Brokers. Information provided is thought to be reliable but is not guaranteed to be accurate; you are advised to verify facts that are important to you. No warranties, expressed or implied, are provided for the data herein, or for their use or interpretation by the user. ZFC, the Florida Association of Realtors and its cooperating Multiple Listing Services do not create, control or review the property data displayed herein and take no responsibility for the content of such records. Federal law including the fair housing act prohibits discrimination on the basis of race, color, religion, sex, handicap, familial status or national origin in the sale, rental or financing of housing. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Currency