SELECT ACRES, BATHS_FULL, BATHS_HALF, BATHS_THREEQ, BATHS_TOTAL, BEDROOMS, BIDX_VIDEO_URL, BUILDING_SQUARE_FOOTAGE, CITY, COMMUNITY_NAME, COUNTY, FIREPLACE_NUMBER, FORECLOSURE, GEO_LAT, GEO_LON, LEGAL, MLS_ADULT,MLS_AGENT_ID, MLS_AGENT2_ID, MLS_AREA_NAME, MLS_AREA, MLS_BOARD_IMG, MLS_BOARD_NAME, MLS_CONDO, MLS_COUNTYID, MLS_DISPLAY_TYPE, MLS_FEED, MLS_GREEN, MLS_LAST_PRICE_TIMESTAMP, MLS_LAST_PRICE, MLS_LIST_NUM, MLS_LISTDATE, MLS_OFFICE_ID, MLS_OFFICE_NAME, MLS_AGENT_NAME, MLS_PARKING_SPACES, MLS_PHOTODATE, MLS_PRICE, MLS_PROP_TYPE, MLS_REMARKS, MLS_RENT_MONTH, MLS_SPA, MLS_TABLE, MLS_TRANSDATE, MLS_VIDEO_URL, MLS_WATERACCESS, MLS_ZONING, PHOTO_QUANTITY, PHOTO_URL, POOL, PROPERTY_STYLE, SCHOOL_DISTRICT, SCHOOL_ELEMENTARY, SCHOOL_HIGH, SCHOOL_JUNIOR_HIGH, SCHOOL_MIDDLE, SHORTSALE, SHOW_ADDRESS, STATE, STREET_DIRECTION, STREET_NAME, STREET_NUMBER, STREET_TYPE, SUBDIVISION, sysid, UNIT_NUMBER, VIRTUAL_TOUR_URL, VIRTUALTOUR, WATERFRONT_TYPE, WATERFRONT, YEAR_BUILT, ZIP_CODE from far_properties_rental WHERE (((MLS_FEED = 'HERN') or (MLS_FEED = 'MFRMLS')) OR (MLS_FEED = 'FSBO')) AND ((MLS_COUNTYID = '12017') or (MLS_COUNTYID = '12053') or (MLS_COUNTYID = '12057') or (MLS_COUNTYID = '12081') or (MLS_COUNTYID = '12083') or (MLS_COUNTYID = '12097') or (MLS_COUNTYID = '12101') or (MLS_COUNTYID = '12103') or (MLS_COUNTYID = '12115') or (MLS_COUNTYID = '12117'))ORDER BY MLS_PRICE DESC LIMIT 0,10 Rental Search Results
Robin Winchester-Heugel Real estate serving Spring Hill FL
  1. Heugel Properties of Floridas Gulf Coast
  2. Tropic Shores Realty
  3. Cell: 920.737.9148
  4. heugels@yahoo.com
136 Osprey Point Dr
136 Osprey Point Dr
Rental
  1. Price: $50,000.00
  2. Days On Market: 882
  3. Bedrooms: 7
  4. Baths: 9
  5. Garage / Parking Spaces: 4
  6. Acreage: 0.67 acres
  7. Pool: Yes
  8. Spa/HotTub: Yes
  9. Waterfront: Yes
  10. Wateraccess: Yes
  11. Year Built: 2005
MLS#: A4156986
  1. County: SARASOTA
  2. City: SARASOTA
  3. Zipcode: 34229
  4. Elementary School: Laurel Nokomis Elementary
  5. High School: Venice Senior High
  6. Provided by: Jennette Properties Inc
EXQUISITELY STUNNING "GEORGIAN ESTATE HOME" nestled on a BAY FRONT lot in one of Sarasota's premier gated communities. Sweeping double stairway entry opens to a breathtaking two story grand salon. Met [Read More]
144 Willadel Drive
144 Willadel Drive
Rental
  1. Price: $49,999.00
  2. Days On Market: 348
  3. Bedrooms: 5
  4. Baths: 8
  5. Garage / Parking Spaces: 3
  6. Acreage: 4.01 acres
  7. Pool: Yes
  8. Spa/HotTub: Yes
  9. Waterfront: Yes
  10. Wateraccess: Yes
  11. Year Built: 2001
MLS#: T2913923
  1. County: PINELLAS
  2. City: BELLEAIR
  3. Zipcode: 33756
  4. Subdivision: Willadel Rev
  5. Provided by: THE TONI EVERETT COMPANY
This beautiful estate is walled in with fabulous cascading grounds. The first gate entry opens into lushly landscaped grounds with a soothing water feature of a pond. As you walk to the front entry on [Read More]
9550 W Gulf Boulevard
9550 W Gulf Boulevard
Rental
  1. Price: $45,000.00
  2. Days On Market: 408
  3. Bedrooms: 5
  4. Baths: 6
  5. Garage / Parking Spaces: 4
  6. Acreage: 0.14 acres
  7. Pool: Yes
  8. Spa/HotTub: Yes
  9. Waterfront: Yes
  10. Wateraccess: Yes
  11. Year Built: 2007
MLS#: U7833822
  1. County: PINELLAS
  2. City: TREASURE ISLAND
  3. Zipcode: 33706
  4. Subdivision: Sawyer & Harrells 2nd Add
  5. Provided by: BHHS FLORIDA PROPERTIES GROUP
Sunset Beach Palace: Five (5) night minimum stay. Nightly rates are $1500 per night from December to March and $1200 per night from April to November. Holiday rates are $1650 per night for the rent [Read More]
1605 Renaissance Way
1605 Renaissance Way
Rental
  1. Price: $35,000.00
  2. Days On Market: 151
  3. Bedrooms: 5
  4. Baths: 5
  5. Garage / Parking Spaces: 3
  6. Acreage: 0.37 acres
  7. Pool: Yes
  8. Waterfront: Yes
  9. Wateraccess: Yes
  10. Year Built: 2006
MLS#: T3111782
  1. County: HILLSBOROUGH
  2. City: TAMPA
  3. Zipcode: 33602
  4. Subdivision: Pointe At Harbour Island
  5. Elementary School: Gorrie HB
  6. High School: Plant HB
  7. Provided by: CHARLES RUTENBERG REALTY INC
Beautiful waterfront estate located minutes away from Convention Center, Downtown Tampa, Bayshore boulevard, and the Channelside district. The exclusive neighborhood The Pointe is located inside the s [Read More]
6855 Gulf Of Mexico Drive
6855 Gulf Of Mexico Drive
Rental
  1. Price: $30,000.00
  2. Days On Market: 475
  3. Bedrooms: 4
  4. Baths: 6
  5. Garage / Parking Spaces: 4
  6. Acreage: 0.67 acres
  7. Pool: Yes
  8. Spa/HotTub: Yes
  9. Waterfront: Yes
  10. Wateraccess: Yes
  11. Year Built: 2017
MLS#: A4192698
  1. County: MANATEE
  2. City: LONGBOAT KEY
  3. Zipcode: 34228
  4. Subdivision: Tramonto Estates Sub
  5. Provided by: Michael Saunders & Company
Seasonal: Fabulous New Construction on Longboat Key, sleek, modern luxury at its finest. This seasonal rental is located directly on the Gulf of Mexico. A luxurious four bedroom, five and a half bath [Read More]
8490 Gulf Boulevard
8490 Gulf Boulevard
Rental
  1. Price: $30,000.00
  2. Days On Market: 558
  3. Bedrooms: 4
  4. Baths: 6
  5. Garage / Parking Spaces: 2
  6. Acreage: 0.28 acres
  7. Pool: Yes
  8. Spa/HotTub: Yes
  9. Waterfront: Yes
  10. Wateraccess: Yes
  11. Year Built: 2015
MLS#: U7817642
  1. County: PINELLAS
  2. City: TREASURE ISLAND
  3. Zipcode: 33706
  4. Subdivision: Sunset Beach
  5. Elementary School: Gulf Beaches Elementary PN
  6. High School: Boca Ciega High PN
  7. Provided by: Seasalt Properties LLC
Weekly Rate: $13,995; Monthly lease can be worked out but with at least 9 months notice. Sunset Wave is a luxury beachfront property on beautiful Sunset Beach in Treasure Island, Florida, United State [Read More]
401 Point Road
Rental
  1. Price: $25,000.00
  2. Days On Market: 12
  3. Bedrooms: 3
  4. Baths: 3
  5. Garage / Parking Spaces: 1
  6. Acreage: 0.00 acres
  7. Pool: No
  8. Spa/HotTub: Yes
  9. Waterfront: No
  10. Year Built: 2003
MLS#: A4417695
  1. County: SARASOTA
  2. City: OSPREY
  3. Zipcode: 34229
  4. Subdivision: Meridian At The Oaks Preserve
  5. Elementary School: Laurel Nokomis Elementary
  6. High School: Venice Senior High
  7. Provided by: RE/MAX ALLIANCE GROUP
7295 Manasota Key Road
7295 Manasota Key Road
Rental
  1. Price: $22,500.00
  2. Days On Market: 435
  3. Bedrooms: 5
  4. Baths: 6
  5. Garage / Parking Spaces: 5
  6. Acreage: 1.13 acres
  7. Pool: Yes
  8. Spa/HotTub: Yes
  9. Waterfront: No
  10. Year Built: 1989
MLS#: D5920136
  1. County: SARASOTA
  2. City: ENGLEWOOD
  3. Zipcode: 34223
  4. Provided by: Paradise Exclusive Inc
Luxurious Bayfront Pool Home on Manasota Key Mana House Experience one of a kind, tropical living in this magnificent custom built, bay side estate home on Manasota Key. Private Beach Access just d [Read More]
1300 Benjamin Franklin Drive
1300 Benjamin Franklin Drive
Rental
  1. Price: $22,000.00
  2. Days On Market: 96
  3. Bedrooms: 3
  4. Baths: 3
  5. Garage / Parking Spaces: 2
  6. Acreage: 0.00 acres
  7. Pool: No
  8. Waterfront: Yes
  9. Wateraccess: Yes
  10. Year Built: 2005
MLS#: A4410654
  1. County: SARASOTA
  2. City: SARASOTA
  3. Zipcode: 34236
  4. Subdivision: The Beach Residences
  5. Building: The Beach Residences
  6. Provided by: MICHAEL SAUNDERS & COMPANY
Seasonal rental in The Beach Residences with expansive Gulf, Bay and City views! Located directly on the Gulf of Mexico, no detail was overlooked in this 3 bedroom, 3 bathrooms plus den paradise. Exqu [Read More]
100 Davis Boulevard
100 Davis Boulevard
Rental
  1. Price: $20,000.00
  2. Days On Market: 1525
  3. Bedrooms: 5
  4. Baths: 5
  5. Acreage: 0.49 acres
  6. Pool: Yes
  7. Spa/HotTub: Yes
  8. Waterfront: No
  9. Year Built: 1925
MLS#: T2716329
  1. County: HILLSBOROUGH
  2. City: TAMPA
  3. Zipcode: 33606
  4. Subdivision: Davis Islands
  5. Elementary School: Gorrie HB
  6. High School: Plant HB
  7. Provided by: Charles Rutenberg Realty Inc
Beautiful Mediterranean estate built on prestigious Davis Islands! 4 lots.. Available furnished for short or long term rentals. Enjoy living in complete relaxed elegance on this 5 Bed, 4.5 bath proper [Read More]