Buy
  • Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (748)
    Mexico Listings (330)
    Central America Listings (624)
    Caribbean Islands Listings (44)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BeachHouse.com logo
Share
BeachHouse.com logo
Ad #7824851
MLS #TB8494324
Listing photo

This is a tear-down value only in the land which is located in

404 N FREMONT Ave, Tampa, Florida, 33606
$420,000
3Beds
2Baths
1,322Sqft
0.110Acres

About this property

This is a tear-down value only in the land which is located in one of the hotest areas of Tampa-North Hyde Park. The property has excellent location to all of south and downtown Tampa has to offer.

Property Features

3 Beds
2 Baths
1,322 Sqft
Built in 1917
0.110 Acres
1 Story
Siding: Frame, Wood Siding
Shingle Roof
$6,104 / yr property tax
Hillsborough County
CORRONELLA Community

Contact Information

Jorge Morejon

Keller Williams Tampa Properties

813-264-7754

Location

Map
Listing Agent: Jorge Morejon 813-264-7754
Broker: Keller Williams Tampa Properties 813-264-7754 Listing Site
Copyright © 2026 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.
BeachHouse.com
Printed Jul 22, 2026

Photo Gallery

This is a tear-down value only in the land which is located in - photo 1

$420,000

3
Beds
2
Baths
1,322
Sqft

404 N FREMONT Ave, Tampa, Florida, 33606

By contacting this agent you agree to these Terms and Conditions.
Home Florida Tampa
This is a tear-down value only in the land which is located in - photo 1
MLS# TB8494324
Home For Sale

This is a tear-down value only in the land which is located in

$420,000

404 N FREMONT Ave, Tampa, Florida, 33606

3
Beds
2
Baths
1,322
Sqft
0.110
Acres
$420,000
404 N FREMONT Ave, Tampa, Florida, 33606
3 Beds
2 Baths
1,322 Sqft
0.110 Acres
This is a tear-down value only in the land which is located in one of the hotest areas of Tampa-North Hyde Park. The property has excellent location to all of south and downtown Tampa has to offer.
39 days
on BeachHouse.com
28
views
0
saves

Property Details

HOME DETAILS

3 Beds
2 Baths
1,322 Sqft
Built in 1917
0.110 Acres
1 Story

EXTERIOR

Siding: Frame, Wood Siding
Shingle Roof

FINANCIAL & COMMUNITY

$6,104 / yr property tax
Hillsborough County
CORRONELLA Community
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7824851
Viewed
28 times
Listing Status
Active
Added
Jun 12, 2026
Last Refresh
Jul 21, 2026 08:02:26 PM

Listing Information

Data Source
Stellar MLS
Source Property ID
TB8494324
Listing Agent: Jorge Morejon 813-264-7754
Broker: Keller Williams Tampa Properties 813-264-7754 Listing Site
Copyright © 2026 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.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
Beautifully maintained home in the highly sought-after - photo 1
Beautifully maintained home in the highly sought-after - photo 2
Beautifully maintained home in the highly sought-after - photo 3
Beautifully maintained home in the highly sought-after - photo 4
Beautifully maintained home in the highly sought-after - photo 5
Beautifully maintained home in the highly sought-after - photo 6
Beautifully maintained home in the highly sought-after - photo 7
Beautifully maintained home in the highly sought-after - photo 8
Beautifully maintained home in the highly sought-after - photo 9
Beautifully maintained home in the highly sought-after - photo 10
Beautifully maintained home in the highly sought-after - photo 11
Beautifully maintained home in the highly sought-after - photo 12
Beautifully maintained home in the highly sought-after - photo 13
Beautifully maintained home in the highly sought-after - photo 14
Beautifully maintained home in the highly sought-after - photo 15
Beautifully maintained home in the highly sought-after - photo 16
Beautifully maintained home in the highly sought-after - photo 17
Beautifully maintained home in the highly sought-after - photo 18
Beautifully maintained home in the highly sought-after - photo 19
Beautifully maintained home in the highly sought-after - photo 20
Beautifully maintained home in the highly sought-after - photo 21
Beautifully maintained home in the highly sought-after - photo 22
Beautifully maintained home in the highly sought-after - photo 23
Beautifully maintained home in the highly sought-after - photo 24
Beautifully maintained home in the highly sought-after - photo 25
Beautifully maintained home in the highly sought-after - photo 26
Beautifully maintained home in the highly sought-after - photo 27
Beautifully maintained home in the highly sought-after - photo 28

$500,000

4 Beds | 3.0 Baths | 2,282 Sqft

8601 FLOWING BROOK Ct, Tampa, FL, 33635

Beautifully maintained home in the highly sought-after

Added: 06/26/2026 • Updated: 06/26/2026
For Sale
Back on the market! Seller is motivated and even at this price - photo 1
Back on the market! Seller is motivated and even at this price - photo 2
Back on the market! Seller is motivated and even at this price - photo 3
Back on the market! Seller is motivated and even at this price - photo 4
Back on the market! Seller is motivated and even at this price - photo 5
Back on the market! Seller is motivated and even at this price - photo 6
Back on the market! Seller is motivated and even at this price - photo 7
Back on the market! Seller is motivated and even at this price - photo 8
Back on the market! Seller is motivated and even at this price - photo 9
Back on the market! Seller is motivated and even at this price - photo 10
Back on the market! Seller is motivated and even at this price - photo 11
Back on the market! Seller is motivated and even at this price - photo 12
Back on the market! Seller is motivated and even at this price - photo 13
Back on the market! Seller is motivated and even at this price - photo 14
Back on the market! Seller is motivated and even at this price - photo 15
Back on the market! Seller is motivated and even at this price - photo 16
Back on the market! Seller is motivated and even at this price - photo 17
Back on the market! Seller is motivated and even at this price - photo 18
Back on the market! Seller is motivated and even at this price - photo 19
Back on the market! Seller is motivated and even at this price - photo 20
Back on the market! Seller is motivated and even at this price - photo 21
Back on the market! Seller is motivated and even at this price - photo 22
Back on the market! Seller is motivated and even at this price - photo 23
Back on the market! Seller is motivated and even at this price - photo 24
Back on the market! Seller is motivated and even at this price - photo 25
Back on the market! Seller is motivated and even at this price - photo 26
Back on the market! Seller is motivated and even at this price - photo 27
Back on the market! Seller is motivated and even at this price - photo 28
Back on the market! Seller is motivated and even at this price - photo 29
Back on the market! Seller is motivated and even at this price - photo 30
Back on the market! Seller is motivated and even at this price - photo 31
Back on the market! Seller is motivated and even at this price - photo 32
Back on the market! Seller is motivated and even at this price - photo 33
Back on the market! Seller is motivated and even at this price - photo 34
Back on the market! Seller is motivated and even at this price - photo 35
Back on the market! Seller is motivated and even at this price - photo 36

$500,000

3 Beds | 2.0 Baths | 1,566 Sqft

2501 W GRAY St, Tampa, FL, 33609

Back on the market! Seller is motivated and even at this price

Added: 06/24/2026 • Updated: 06/24/2026
For Sale
Urban living at its finest! Sophisticated Channelside condo - photo 1
Urban living at its finest! Sophisticated Channelside condo - photo 2
Urban living at its finest! Sophisticated Channelside condo - photo 3
Urban living at its finest! Sophisticated Channelside condo - photo 4
Urban living at its finest! Sophisticated Channelside condo - photo 5
Urban living at its finest! Sophisticated Channelside condo - photo 6
Urban living at its finest! Sophisticated Channelside condo - photo 7
Urban living at its finest! Sophisticated Channelside condo - photo 8
Urban living at its finest! Sophisticated Channelside condo - photo 9
Urban living at its finest! Sophisticated Channelside condo - photo 10
Urban living at its finest! Sophisticated Channelside condo - photo 11
Urban living at its finest! Sophisticated Channelside condo - photo 12
Urban living at its finest! Sophisticated Channelside condo - photo 13
Urban living at its finest! Sophisticated Channelside condo - photo 14
Urban living at its finest! Sophisticated Channelside condo - photo 15
Urban living at its finest! Sophisticated Channelside condo - photo 16
Urban living at its finest! Sophisticated Channelside condo - photo 17
Urban living at its finest! Sophisticated Channelside condo - photo 18
Urban living at its finest! Sophisticated Channelside condo - photo 19
Urban living at its finest! Sophisticated Channelside condo - photo 20
Urban living at its finest! Sophisticated Channelside condo - photo 21
Urban living at its finest! Sophisticated Channelside condo - photo 22
Urban living at its finest! Sophisticated Channelside condo - photo 23
Urban living at its finest! Sophisticated Channelside condo - photo 24

$499,999

2 Beds | 2.0 Baths | 1,237 Sqft

111 N 12 St 1620, Tampa, FL, 33602

Urban living at its finest! Sophisticated Channelside condo

Added: 06/30/2026 • Updated: 06/30/2026
For Sale
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 1
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 2
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 3
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 4
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 5
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 6
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 7
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 8
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 9
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 10
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 11
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 12
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 13
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 14
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 15
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 16
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 17
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 18
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 19
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 20
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 21
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 22
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 23
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 24
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 25
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 26
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 27
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 28
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 29
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 30
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 31
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 32
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 33
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 34
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 35
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 36
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 37
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 38
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 39
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 40
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 41
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 42
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 43
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 44
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 45
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 46
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 47
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 48
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 49
Welcome to this fully renovated 4-bedroom, 3-bathroom home - photo 50

$499,999

4 Beds | 3.0 Baths | 2,274 Sqft

1102 E RIVER COVE St, Tampa, FL, 33604

Welcome to this fully renovated 4-bedroom, 3-bathroom home

Added: 06/23/2026 • Updated: 06/23/2026
View more View More
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.22
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Tampa

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Tampa Real Estate Agent Info

About Tampa

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.22
Terms & Policy