Title Page Background
HFQUERY 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 = 375 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 375 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 375 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

143 Melody Lane
Tarpon Springs, FL 34689

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $173,900
Beds: 3
Baths: 2
Status: Pending
SqFt: 1150
Agency: Select Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1972
Notes: Under contract-accepting backup offers. Move-in Ready 3 Bedroom/2 Bath Home Located in The Very Popular Tarpon Shores 55+ Community where ***YOU OWN YOUR OWN LAND!!!*** THE SHARE PRICE OF $40K IS INCLUDED IN THE LIST PRICE AND CAN BE FINANCED THROUGH THE HOA** This Beautiful Home has been COMPLETELY Updated and All of the Furniture is Included. (furnishings optional). Spacious 1,150 HEATED SQUARE FEET WITH MANY UPDATES. There is a Large Living Room and Florida Room. Great for Entertaining. All Three of the Bedrooms are Good Sized Bedrooms Allowing for Plenty of Room for All of Your Furniture and Electronics. The Primary Bedroom has an EnSuite Bath with a Private Water Closet and Step-in Shower. The Guest Bathroom also has a Step-In Shower. There Are Ceiling Fans in the Living Room and Kitchen. Kitchen Comes with All Appliances. Easy Care High Quality Laminate and Tile Throughout and the Floors are Solid! The Washer and Dryer are located in the Shed. New Metal Roof with 2” of Insulation Under the Roof (2009), NEW PACKAGE UNIT HVAC SYSTEM (5/2024), Vapor Barrier New (2010), Double-Pane Insulated Windows (2012), Freshly Painted Carport Driveway and the Driveway has Been Widened. Tarpon Shores Offers a Variety of Fun Organized Social Activities and Lots of Amenities Including a Terrific Clubhouse with Kitchen, Library, Billiards, Card Room, Covered Shuffleboard Courts, A Heated Pool, Bocce Ball Court, Horseshoe Pits, Monthly Newsletters, Numerous Organized Activities, And Golf & Bowling Leagues. LOW MONTHLY FEE IS $290 And Includes Lawn Mowing, Lawn Spraying (Fertilizer, Insecticide and Weed Control), Water, Sewer, Trash Pickup, Cable TV with Park Information Channel, And Internet. Great Location! Do You Enjoy Golfing, Walking, Bicycling, Fishing, Swimming, Boating, Shopping, Fine Dining, Or Just Watching Breathtaking Sunsets? It is All at Your Doorstep at Tarpon Shores! LOW HOA, LOW TAXES AND NOT IN A FLOOD HAZARD ZONE. **The List Price Includes the Land Share Value Of $40,000. **The Land Share Can Be Financed Through Tarpon Shores MHP** No Pets Allowed Except For Service or Emotional Support Animals with Proper Documentation and Will Have to Be Approved By The HOA. This is a Great Find! Do not wait! Schedule your showing today!
MlsNumber: U8238621


Listing Provided By: Select Properties, original listing
Name: Select Properties
Phone: (727) 934-4099
Office Name: SELECT PROPERTIES INC
Office Phone: (727) 934-4099
Agent Name: Connie Dichtas
Disclaimer: Copyright © 2024 Stellar 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 Real Estate Expert

HFQUERY 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 = 375 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Brian Cooper
Brian Cooper
ASCIIRealty Experts
Call Today!: (727) 351-2728

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App