Please stand by.
USDAProperties.com is preparing the eligibility details...

 

 

 

$3,199,900   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
504 Riverside Dr
Tarpon Springs, FL 34689
8 bed 8 bath 7,886 SqFt ($405/SqFt)
2.25 acre lot. Built 1999
Listed 2024-06-11, Taxes $31,899
Ⓧ USDA Ineligible
due to price & location

near Tarpon Springs

Explore a hidden treasure nestled within a secure gated estate

Featuring two distinct single-family homes situated on a vast 2+ acre lot. Perched atop a hill, this dual residence offers stunning views of Kraemer Bayou, with direct access to the Gulf of Mexico minutes away by boat. Dual driveways and three 2-car garages provide ample parking and privacy for residents and guests alike. The main house, the larger of the two residences, boasts 4 bedrooms, 3 full baths and a half bath. Each room is meticulously designed to exude comfort and elegance, with a den, library and formal dining room adding layers of functionality and sophistication. The grand room, a focal point of the home, offers breathtaking water views and a spacious, inviting atmosphere. Recent upgrades, such as a new hot water tank (2024) and fresh paint, ensure the home remains contemporary yet timeless. The guest house is equally impressive, featurng 4 bedrooms and 3.5 baths.

The commercial-style kitchen is perfect for entertaining, while the grand room offers serene bayou views. The first level has new laminate flooring and paint, refreshing the space. A stylish wet bar enhances the entertainment potential, making it an ideal retreat for guests or extended family. Outdoor amenities include a newly built dock with updated boat plumbing and electrical (2024), as well as a covered jet ski boat lift capable of holding up to 10, 000 lbs. A newly constructed gazebo near the infinity pool provides panoramic views of Kraemer Bayou. Lifetime warranty outdoor lighting adds peace of mind to the luxury experience. Enjoy a game of volleyball on the sand court or take a swim in the indoor swim spa with a walk-in shower. Additional luxuries include a whole house generator that powers the entire estate, 50, 000 KV Kohler brand, ensuring uninterrupted comfort and security. This estate offers more than a place to live - it represents a lifestyle choice, providing a harmonious combination of privacy, luxury and natural beauty. Ideal for families seeking a home that can accommodate multiple generations or those desiring a vast living environment with top-of-the-line amenities. Take the opportunity to discover this immaculate estate and imagine a life without limitations.


Presented by Tanner Tillung at
EXP Realty, LLC.
Listing Agent Photo

Property MLS #U8246208 from StellarMLS

Total Rooms: 14
Living Room: 22 x 41
Living Room Level: First
Dining Room: 8 x 15
Dining Room Level: First
Primary Bedroom: 14 x 19
Primary Bedroom Level: Second
Bedroom 1: 13 x 13
Bedroom 1 Level: Second
Bedroom 2: 9 x 17
Bedroom 2 Level: Second
Basement Features: Crawl Space, Finished, Full
Family Room Dimensions: 17 x 13
Living Room Dimensions: 25 x 14
Office/Study Room Dimensions: 14 x 12
Family Room Level: First
Living Room Level: First
Office/Study Room Level: First
Extra Room-1 Description: Attic, Den/Library/Office, Formal Dining Room Separate, Formal Living Room Separate, Inside Utility, Storage Rooms

Bar Fridge
Built-In Oven
Convection Oven
Cooktop
Dishwasher
Dryer
Electric Water Heater
Exhaust Fan
Freezer
Gas Water Heater
Ice Maker
Microwave
Range
Range Hood
Refrigerator
Washer
Water Filtration System
Water Purifier
Water Softener
Whole House R.O. System
Wine Refrigerator
Laundry Features: Inside, Laundry Room

Bedrooms: 8
Primary Bedroom Dimensions: 25 x 16
Bedroom 1 Dimensions: 16 x 13
Bedroom 2 Dimensions: 15 x 15
Bedroom 3 Dimensions: 16 x 12
Primary Bedroom Level: Second
Bedroom 1 Level: First
Bedroom 2 Level: Second
Bedroom 3 Level: Second

Total Bathrooms: 8
Full Bathrooms: 6
1/2 Bathrooms: 2

Crown Molding
Dry Bar
Dumbwaiter
Open Floorplan
Sauna
Stone Counters
Thermostat
Walk-In Closet(s)
Wet Bar
Window Treatments
Furnished Description: Unfurnished
Flooring: Carpet, Ceramic Tile, Laminate, Wood
Window Features: Shades, Shutters

Cooling Features: Central Air, Mini-Split Unit(s), Zoned
Fireplace Features: Circulating, Gas, Masonry
Heating Features: Central, Electric, Zoned

Dining Room Dimensions: 15 x 15
Dining Room Level: First
Kitchen Dimensions: 21 x 19
Kitchen Level: First

Water Body Name: KRAMMERS BAYOU
Water Features: Bayou, Gulf/Ocean
Bayou
Waterfront Feet: 321

Courtyard
French Doors
Garden
Hurricane Shutters
Irrigation System
Lighting
Outdoor Shower
Private Mailbox
Rain Gutters
Sidewalk
Sprinkler Metered
Storage
Fencing: Fenced, Masonry
Other Structures: Additional Single Family Home, Gazebo, Guest House, Storage
Patio And Porch Features: Covered, Deck, Front Porch, Porch, Rear Porch
Road Responsibility: Public Maintained Road
Road Surface Type: Paved

Pool Features: Deck, Gunite, Heated, In Ground, Outside Bath Access, Salt Water
Pool Private: Yes
Spa Features: Heated, Swim Spa
Spa: Yes

Attached Garage: Yes
Garage Spaces: 6
Parking Features: Boat, Curb Parking, Driveway, Garage Door Opener, Ground Level, Guest, Off Street, Open, Oversized, Parking Pad

Lot Description: Corner Lot, City Limits, Landscaped, Near Golf Course, Near Marina, Near Public Transit, Oversized Lot, Sidewalk, Paved
Lot Size Acres: 2.25
Lot Size Dimensions: 124x237
Vegetation: Fruit Trees, Mature Landscaping, Oak Trees, Trees/Landscaped
Lot Size Square Feet: 98219

View: Water
Other Equipment: Generator
Security Features: Security Fencing/Lighting/Alarms, Security Gate, Security System, Smoke Detector(s)

Elementary School: Sunset Hills Elementary-PN
High School: Tarpon Springs High-PN
Middle School: Tarpon Springs Middle-PN

Sunset Hills Elementary School is a public elementary school located approximately 0.4 miles away.
directions icon Map directions

Tarpon Springs High School is a public high school located approximately 0.6 miles away.
directions icon Map directions

Tarpon Springs Middle School is a public middle school located approximately 0.7 miles away.
directions icon Map directions

St. Nicholas Greek Orthodox Parochial School is a private elementary school located approximately 0.8 miles away.
directions icon Map directions

Calculated Total Monthly Association Fees: 0
Pets Allowed: Yes
Pet Description: Pet Restrictions: Please contact Pinellas county for Pet Restrictions.

Lease Term: Minimum Lease: No Minimum

Community Features: Restaurant

Annual Tax Amount: 38050.48
Source Listing Status: Active
County: Pinellas
Directions: US-19 ALT; turn west onto W. Orange St; keep straight onto N. Spring Blvd.; road name will change to Riverside Dr.
Tax Year: 2023
Ownership: Fee Simple
Source Property Type: Residential
Area: 34689 - Tarpon Springs
Source Neighborhood: SUNSET HILLS
Parcel Number: 11-27-15-87786-001-0060
Postal Code Plus 4: 2431
Subdivision: SUNSET HILLS
Township: 27
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$1,132,452 + $557,419
$1,689,871
$31,899
2021$970,739 + $591,958
$1,562,697
$30,842
2020$967,922 + $662,130
$1,630,052
$32,603
2019$1,056,930 + $603,344
$1,660,274
$33,491
2018$1,054,532 + $679,340
$1,733,872
$35,337
2017$1,016,427 + $712,672
$1,729,099
$34,537
2016$unknown + $unknown
$1,490,770
$31,285
2015$unknown + $unknown
$1,479,900
$31,553
2014$unknown + $unknown
$1,331,097
$28,691
2013$unknown + $unknown
$1,351,846
$29,445
2012$unknown + $unknown
$1,417,738
$30,870
2011$unknown + $unknown
$1,545,126
$33,252
2010$unknown + $unknown
$1,488,092
$31,607
2009$unknown + $unknown
$788,626
$15,578
2008$unknown + $unknown
$787,838
$15,100
2007$unknown + $unknown
$764,891
$14,468

Price Changed 2024-07-06
$3,199,900
StellarMLS
Price Changed 2024-06-17
$3,600,000
StellarMLS
Listed 2024-06-11
$3,995,000
StellarMLS
Listing removed 2024-06-10
$3,995,000
StellarMLS
Price Changed 2024-06-06
$3,995,000
StellarMLS
Price Changed 2024-05-21
$4,275,000
StellarMLS
Price Changed 2024-05-10
$4,500,000
StellarMLS
Listed 2024-04-26
$4,995,000
StellarMLS
Listing removed 2023-01-19
$2,500
StellarMLS
Sold 2022-08-02
$2,700,000
StellarMLS
Listed 2021-07-29
$2,995,000
StellarMLS
Listing removed 2016-09-30
$2,876,500
StellarMLS
Price Changed 2016-04-07
$2,876,500
StellarMLS
Listed 2015-11-06
$2,900,000
StellarMLS
Listing removed 2014-06-25
$2,500
StellarMLS
Listed for rent 2014-06-20
$2,500
StellarMLS
Listing removed 2014-06-18
$2,500
StellarMLS
Listed for rent 2014-06-12
$2,500
StellarMLS
Listing removed 2014-05-09
$2,500
StellarMLS
Listed for rent 2014-05-08
$2,500
StellarMLS
Listing removed 2014-03-20
$1,400,000
StellarMLS
Sold 2013-02-25
$1,400,000
StellarMLS
Listed 2013-02-14
$1,999,000
StellarMLS
Sold 1998-05-01
$525,000
Public Record

Total Square Feet Living: 7886
Year Built: 1999
Building Area Source: Public Records
Building Area Total: 11279
Construction Materials: Block, Brick, Wood Frame
Direction Faces: Northeast
Foundation Details: Basement, Block, Concrete Perimeter, Crawlspace, Pillar/Post/Pier
Levels: Three Or More
Property Age: 25
Property Attached: Yes
Property Condition: Completed
Roof: Shingle
Levels or Stories: 3
Building Total Stories: 3
Architectural Style: Traditional

Sewer: Public Sewer
Cable Connected
Electricity Connected
Fire Hydrant
Phone Available
Propane
Public
Sewer Connected
Sprinkler Meter
Street Lights
Water Connected
Water Source: Public
Click Thumbnail Images To View Full Size
unknownroad_viewroad_viewunknownunknown
unknownhouse_viewhouse_viewporchunknown
living_roomliving_roomdining_roomdining_roomkitchen
kitchenkitchenliving_roomliving_roombedroom
bathroomliving_roombathroomunknownunknown
bedroombedroombathroombathroomlaundry_room
bedroombathroomunknownhouse_viewhouse_view
garagehouse_viewliving_roomliving_roomliving_room
unknownliving_roomkitchenkitchenbathroom
kitchenkitchenbathroomkitchenunknown
bedroombathroombedroombedroomhouse_view
unknownporchhouse_viewporchhouse_view
road_viewporchpoolpoolporch
porchwater_frontwater_frontunknownunknown
unknownunknown

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.