Headshot for Associate Michael Apt
  1. Michael Apt, REALTOR ®
  2. Tropic Shores Realty
  3. Mobile: 352.942.8247
  4. michaelapt@hotmail.com
Contact Michael Apt
Contacting Michael Apt
  • All fields are required.
Schedule A Showing
Schedule a Showing.
  • All fields are required.
Check this box to Register with us:
Request more information
Property Photos
804 Fremont Avenue804 Fremont Avenue Listing photo id 0 for 804 Fremont Avenue Listing photo id 1 for 804 Fremont Avenue Listing photo id 2 for 804 Fremont Avenue Listing photo id 3 for 804 Fremont Avenue Listing photo id 4 for 804 Fremont Avenue Listing photo id 5 for 804 Fremont Avenue Listing photo id 6 for 804 Fremont Avenue Listing photo id 7 for 804 Fremont Avenue Listing photo id 8 for 804 Fremont Avenue Listing photo id 9 for 804 Fremont Avenue Listing photo id 10 for 804 Fremont Avenue Listing photo id 11 for 804 Fremont Avenue Listing photo id 12 for 804 Fremont Avenue Listing photo id 13 for 804 Fremont Avenue Listing photo id 14 for 804 Fremont Avenue Listing photo id 15 for 804 Fremont Avenue Listing photo id 16 for 804 Fremont Avenue Listing photo id 17 for 804 Fremont Avenue Listing photo id 18 for 804 Fremont Avenue Listing photo id 19 for 804 Fremont Avenue Listing photo id 20 for 804 Fremont Avenue Listing photo id 21 for 804 Fremont Avenue Listing photo id 22 for 804 Fremont Avenue Listing photo id 23 for 804 Fremont Avenue Listing photo id 24 for 804 Fremont Avenue Listing photo id 25 for 804 Fremont Avenue Listing photo id 26 for 804 Fremont Avenue Listing photo id 27 for 804 Fremont Avenue Listing photo id 28 for 804 Fremont Avenue Listing photo id 29 for 804 Fremont Avenue Listing photo id 30 for 804 Fremont Avenue Listing photo id 31 for 804 Fremont Avenue Listing photo id 32 for 804 Fremont Avenue Listing photo id 33 for 804 Fremont Avenue Listing photo id 34 for 804 Fremont Avenue Listing photo id 35 for 804 Fremont Avenue Listing photo id 36 for 804 Fremont Avenue Listing photo id 37 for 804 Fremont Avenue Listing photo id 38 for 804 Fremont Avenue Listing photo id 39 for 804 Fremont Avenue Listing photo id 40 for 804 Fremont Avenue Listing photo id 41 for 804 Fremont Avenue Listing photo id 42 for 804 Fremont Avenue Listing photo id 43 for 804 Fremont Avenue Listing photo id 44 for 804 Fremont Avenue Listing photo id 45 for 804 Fremont Avenue Listing photo id 46 for 804 Fremont Avenue Listing photo id 47 for 804 Fremont Avenue Listing photo id 48 for 804 Fremont Avenue Listing photo id 49 for 804 Fremont Avenue Listing photo id 50 for 804 Fremont Avenue Listing photo id 51 for 804 Fremont Avenue Listing photo id 52 for 804 Fremont Avenue Listing photo id 53 for 804 Fremont Avenue Listing photo id 54 for 804 Fremont Avenue Listing photo id 55 for 804 Fremont Avenue Listing photo id 56 for 804 Fremont Avenue Listing photo id 57 for 804 Fremont Avenue Listing photo id 58 for 804 Fremont Avenue Listing photo id 59 for 804 Fremont Avenue Listing photo id 60 for 804 Fremont Avenue Listing photo id 61 for 804 Fremont Avenue Listing photo id 62 for 804 Fremont Avenue Listing photo id 63 for 804 Fremont Avenue Listing photo id 64 for 804 Fremont Avenue Listing photo id 65 for 804 Fremont Avenue Listing photo id 66 for 804 Fremont Avenue Listing photo id 67 for 804 Fremont Avenue Listing photo id 68 for 804 Fremont Avenue Listing photo id 69 for 804 Fremont Avenue Listing photo id 70 for 804 Fremont Avenue Listing photo id 71 for 804 Fremont Avenue Listing photo id 72 for 804 Fremont Avenue Listing photo id 73 for 804 Fremont Avenue
  • MLS#: W7869350 ( Residential )
  • Street Address: 804 Fremont Avenue
  • Viewed: 12
  • Price: $2,499,000
  • Price sqft: $508
  • Waterfront: No
  • Year Built: 2008
  • Bldg sqft: 4921
  • Bedrooms: 5
  • Total Baths: 5
  • Full Baths: 4
  • 1/2 Baths: 1
  • Garage / Parking Spaces: 2
  • Days On Market: 45
  • Additional Information
  • Geolocation: 27.9358 / -82.4787
  • County: HILLSBOROUGH
  • City: TAMPA
  • Zipcode: 33606
  • Subdivision: Lingerlong West Hyde Park Vil
  • Elementary School: Mitchell HB
  • Middle School: Wilson HB
  • High School: Plant HB
  • Provided by: RE/MAX CHAMPIONS
  • Contact: Ashley Aviolla
  • 727-807-7887
  • mfrmls
  • DMCA Notice
  • Description
    804 S Fremont Ave is a rare find in Historic West Hyde Park. Built in 2008 by Sample Properties, this house mirrors the celebrated historic architecture of Hyde Park, while incorporating all the modern standards of today. Built on an elevated slab foundation, this house has sat high and dry since it was built. The front of the home features mature landscaping and a welcoming front porch. Upon entering, notice the 10 foot ceilings, hardwood floors, and over sized crown molding throughout the 1st floor. To the right is an office with floor to ceiling built in bookshelves. To the left is the dining room, leading through a pocket door to the open floor plan, with a kitchen, family room, and bar area, all perfect for quiet evenings with the family or entertaining. The gourmet kitchen has space for a dining set for 6, features dual ovens, a six burner gas cooktop, pot filler, large island, and gorgeous granite countertops. The family room boasts a gas and wood burning fireplace, recessed TV, and a wet bar with sink, wine fridge, small fridge with ice maker, dishwasher, and kegerator. The backyard is visible from the family rooms over sized windows. Off the family room is the primary bedroom suite, which offers 240 square feet of bedroom space with private access to the backyard and an ensuite complete with a jetted soaking tub, large shower, separate toilet room, and walk in closet. Adjoining the ensuite is a spacious laundry room with a sink, cabinets, and easy access to the primary closet. Under the staircase, near the charming powder room, is a cozy nook, perfect for an upright piano. Heading upstairs is a second family room, which is ideal as a man cave, kids or movie space. Upstairs also features three bedrooms, all with walk in closets, one with an ensuite bathroom, and two that share a second bathroom, which also services the family room. Two finished storage rooms and a media closet complete the second floor. The fully fenced outside space, which is accessible through the kitchen, family room, or primary bedroom, has a large brick deck, with space for both sitting and eating areas, with a gas hook up. Beyond the deck is a large yard, covered in low maintenance turf. The garage, also in the rear of the house, has fully covered access to the house. A Carriage House over the garage, with a private entrance beyond the brick deck, is equipped with a fridge, sink, dishwasher, clothes washer/dryer, separate AC, closet, full bathroom, living room, and bedroomgreat for guests, an in law suite, rental income, or a nanny. This house is also equipped with an Electric Vehicle (EV) charger in the garage with Vehicle to Home charging capabilities to power the Carriage House in the event the house loses electricity. In one direction, the home is walkable to Hyde Park Village, with casual and upscale dining and shopping, movie theater, playground, and outdoor markets. In a second direction, the home is walkable to So Ho, with a supermarket, more stores and restaurants. Walkable in a third direction is the famous Bayshore Boulevard with its wide sidewalk along beautiful Tampa Bay. Also noteworthy is that the home is in the Plant High school district and minutes from nationally ranked Tampa General Hospital. Additional home features include 2 tankless gas water heaters, a new roof in 10/24, new front yard irrigation in 10/24, new main house ACs in 12/20, new Carriage House AC in 5/24, new outside trim paint in 5/23, and fresh inside paint in 9/24.
Request More Information
  • All fields are required.
Features
Appliances
  1. Bar Fridge
  2. Built-In Oven
  3. Convection Oven
  4. Cooktop
  5. Dishwasher
  6. Disposal
  7. Dryer
  8. Exhaust Fan
  9. Ice Maker
  10. Microwave
  11. Range
  12. Refrigerator
  13. Tankless Water Heater
  14. Washer
  15. Water Filtration System
  16. Water Purifier
  17. Wine Refrigerator
Home Owners Association Fee
  1. 0.00
Builder Name
  1. John Sample
Carport Spaces
  1. 0.00
Close Date
  1. 0000-00-00
Cooling
  1. Central Air
  2. Zoned
Country
  1. US
Covered Spaces
  1. 0.00
Exterior Features
  1. French Doors
  2. Irrigation System
  3. Lighting
  4. Private Mailbox
  5. Rain Gutters
  6. Sidewalk
  7. Storage
Fencing
  1. Fenced
  2. Wood
Flooring
  1. Carpet
  2. Ceramic Tile
  3. Wood
Furnished
  1. Unfurnished
Garage Spaces
  1. 2.00
Heating
  1. Central
  2. Electric
  3. Zoned
High School
  1. Plant-HB
Interior Features
  1. Ceiling Fans(s)
  2. Chair Rail
  3. Crown Molding
  4. Eat-in Kitchen
  5. High Ceilings
  6. In Wall Pest System
  7. Kitchen/Family Room Combo
  8. Living Room/Dining Room Combo
  9. Open Floorplan
  10. Pest Guard System
  11. Primary Bedroom Main Floor
  12. Solid Surface Counters
  13. Solid Wood Cabinets
  14. Split Bedroom
  15. Stone Counters
  16. Thermostat
  17. Walk-In Closet(s)
  18. Wet Bar
  19. Window Treatments
Legal Description
  1. LINGERLONG LOT 13 BLOCK 5
Levels
  1. Two
Living Area
  1. 3587.00
Lot Features
  1. Cleared
  2. Historic District
  3. City Limits
  4. In County
  5. Landscaped
  6. Sidewalk
  7. Street Dead-End
  8. Paved
Middle School
  1. Wilson-HB
Area Major
  1. 33606 - Tampa / Davis Island/University of Tampa
Net Operating Income
  1. 0.00
Occupant Type
  1. Vacant
Other Structures
  1. Guest House
Parcel Number
  1. A-26-29-18-4U2-000005-00013.0
Parking Features
  1. Alley Access
  2. Electric Vehicle Charging Station(s)
  3. Garage Door Opener
  4. Garage Faces Rear
  5. On Street
Pets Allowed
  1. Yes
Property Condition
  1. Completed
Property Type
  1. Residential
Roof
  1. Shingle
School Elementary
  1. Mitchell-HB
Sewer
  1. Public Sewer
Style
  1. Bungalow
Tax Year
  1. 2023
Township
  1. 29
Utilities
  1. Cable Available
  2. Electricity Connected
  3. Natural Gas Connected
  4. Sprinkler Meter
  5. Street Lights
  6. Water Connected
Views
  1. 12
Virtual Tour Url
  1. https://www.804southfremont.com/mls/163875231
Water Source
  1. Public
Year Built
  1. 2008
Zoning Code
  1. RS-50