574 QUEEN PALM STREET, Largo, FL, 33778 | $138,900

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.

Features

  • Amenities: Golf Course, Optional Additional Fees, Pool
  • Rooms: 7
  • Bedrooms: 2
  • Baths: 2 full
  • Laundry: Other
  • Year Built: 1978
  • Heating: Central
  • Cooling: Central Air
  • Approx Sq. Feet: 945
  • Acreage: 163.91
  • Est. Taxes: $465
  • HOA Fee: $677 Monthly
  • Adult Communities: Yes
  • Pet Policy: No
  • Appliances: Dishwasher, Disposal, Dryer, Electric Water Heater, Exhaust Fan, Microwave, Range, Refrigerator, Washer
  • MLS#: TB8347685
  • Days on Market: 79 days
  • Website: https://www.raveis.com
    /prop/TB8347685/574queenpalmstreet_largo_fl?source=qrflyer
This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this Site comes in part from the IDX Program of MFRMLS (My Florida Regional MLS DBA Stellar MLS). The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. (last updated 5/7/2025 1:10:09 AM)
Listing courtesy of CHARLES RUTENBERG REALTY INC   Phone: 727-538-9200

William Raveis Family of Services

Our family of companies partner in delivering quality services in a one-stop-shopping environment. Together, we integrate the most comprehensive real estate, mortgage and insurance services available to fulfill your specific real estate needs.

Customer Service

888.699.8876

Contact@raveis.com

Our family of companies offer our clients a new level of full-service real estate. We shall:

  • Market your home to realize a quick sale at the best possible price
  • Place up to 20+ photos of your home on our website, raveis.com, which receives over 1 billion hits per year
  • Provide frequent communication and tracking reports showing the Internet views your home received on raveis.com
  • Showcase your home on raveis.com with a larger and more prominent format
  • Give you the full resources and strength of William Raveis Real Estate, Mortgage & Insurance and our cutting-edge technology

To learn more about our credentials, visit raveis.com today.

Melissa CohnRVP, Mortgage Banker, William Raveis Mortgage, LLC

NMLS Mortgage Loan Originator ID 16953

917.838.7300

Melissa.Cohn@raveis.com

Our Executive Mortgage Banker:

  • Is available to meet with you in our office, your home or office, evenings or weekends
  • Offers you pre-approval in minutes!
  • Provides a guaranteed closing date that meets your needs
  • Has access to hundreds of loan programs, all at competitive rates
  • Is in constant contact with a full processing, underwriting, and closing staff to ensure an efficient transaction

Robert ReadeRegional SVP Insurance Sales, William Raveis Insurance

860.690.5052

Robert.Reade@raveis.com

Our Insurance Division:

  • Will Provide a home insurance quote within 24 hours
  • Offers full-service coverage such as Homeowner's, Auto, Life, Renter's, Flood and Valuable Items
  • Partners with major insurance companies including Chubb, Kemper Unitrin, The Hartford, Progressive,
    Encompass, Travelers, Fireman's Fund, Middleoak Mutual, One Beacon and American Reliable

574 QUEEN PALM STREET, Largo, FL, 33778

$138,900

Customer Service

William Raveis Real Estate

Phone: 888.699.8876

Contact@raveis.com

Melissa Cohn

RVP, Mortgage Banker

William Raveis Mortgage, LLC

Phone: 917.838.7300

Melissa.Cohn@raveis.com

NMLS Mortgage Loan Originator ID 16953

5/6 (30 Yr)
Adjustable Rate Conforming*
30 Year
Fixed-Rate Conforming
15 Year
Fixed-Rate Conforming
Loan Amount $111,120 $111,120 $111,120
Term 360 months 360 months 180 months
Initial Interest Rate** 6.375% 6.875% 5.875%
Interest Rate based on Index + Margin 8.125%
Annual Percentage Rate 7.007% 7.063% 6.132%
Monthly Tax Payment $39 $39 $39
H/O Insurance Payment $75 $75 $75
Initial Principal & Interest Pmt $693 $730 $930
Total Monthly Payment $807 $844 $1,044

* The Initial Interest Rate and Initial Principal & Interest Payment are fixed for the first and adjust every six months thereafter for the remainder of the loan term. The Interest Rate and annual percentage rate may increase after consummation. The Index for this product is the SOFR. The margin for this adjustable rate mortgage may vary with your unique credit history, and terms of your loan.

** Mortgage Rates are subject to change, loan amount and product restrictions and may not be available for your specific transaction at commitment or closing. Rates, and the margin for adjustable rate mortgages [if applicable], are subject to change without prior notice.

The rates and Annual Percentage Rate (APR) cited above may be only samples for the purpose of calculating payments and are based upon the following assumptions: minimum credit score of 740, 20% down payment (e.g. $20,000 down on a $100,000 purchase price), $1,950 in finance charges, and 30 days prepaid interest, 1 point, 30 day rate lock. The rates and APR will vary depending upon your unique credit history and the terms of your loan, e.g. the actual down payment percentages, points and fees for your transaction. Property taxes and homeowner's insurance are estimates and subject to change.  The Total Monthly Payment does not include the estimated HOA/Common Charge payment.