Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3294 +post_id: "35488" +post_author: 1 +"ListingKey": "417060883512011056" +"ListingId": "T3407188" +"PropertyType": "Residential" +"PropertySubType": "House (Detached)" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-01-24T09:20:45Z" +"RFModificationTimestamp": "2024-01-24T09:20:45.813396+00:00" +"ListPrice": 175000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0.23 +"LivingArea": 1212.0 +"BuildingAreaTotal": 0 +"City": "APOLLO BEACH" +"PostalCode": "33572" +"UnparsedAddress": "DEMO/TEST 554 ESTUARY SHORE LN" +"Coordinates": array:2 [ 0 => -82.404335 1 => 27.777886 ] +"Latitude": 27.777886 +"Longitude": -82.404335 +"YearBuilt": 1939 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Aaron Schmidt" +"ListOfficeName": "SCHMIDT REAL ESTATE, INC." +"ListAgentMlsId": "261521722" +"ListOfficeMlsId": "772608" +"OriginatingSystemName": "Demo" +"PublicRemarks": "**This listings is for DEMO/TEST purpose only** Enjoy all that Smallwood and Bethel have to offer in this spacious log sided cottage. A high ceiling in the large living room makes this home feel super inviting. Bask in the sunlight from your oversized custom windows in the living room and kitchen. The deck is perfect for entertaining or just enjo ** To get a real data, please visit https://dashboard.realtyfeed.com" +"Appliances": "Built-In Oven,Cooktop,Dishwasher,Electric Water Heater,Exhaust Fan,Range Hood" +"ArchitecturalStyle": "Custom" +"AssociationAmenities": array:1 [ 0 => "Gated" ] +"AssociationFee": "1000" +"AssociationFeeFrequency": "Annually" +"AssociationName": "Brad Standridge" +"AssociationName2": "Veneto Shores" +"AssociationPhone": "813-471-7357" +"AssociationYN": true +"AttachedGarageYN": true +"BathroomsFull": 2 +"BuildingAreaSource": "Builder" +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "2.5%-$350" +"CommunityFeatures": "Deed Restrictions,Waterfront" +"ConstructionMaterials": array:3 [ 0 => "Block" 1 => "Stucco" 2 => "Wood Frame" ] +"Cooling": "Central Air" +"Country": "US" +"CountyOrParish": "Hillsborough" +"CreationDate": "2024-01-24T09:20:45.813396+00:00" +"CumulativeDaysOnMarket": 364 +"DaysOnMarket": 851 +"DirectionFaces": "North" +"Directions": "HEAD SOUTH ON S. TAMIAMI TRAIL. R AT BIG BEND ROAD. RIGHT ONTO ESTUARY SHORE LANE. LOT IS ON LEFT" +"Disclosures": array:1 [ 0 => "HOA/PUD/Condo Disclosure" ] +"ElementarySchool": "Apollo Beach-HB" +"ExteriorFeatures": "Hurricane Shutters,Irrigation System,Sliding Doors" +"Flooring": "Vinyl" +"FoundationDetails": array:1 [ 0 => "Stem Wall" ] +"GarageSpaces": "2" +"GarageYN": true +"Heating": "Central,Electric,Heat Pump" +"HighSchool": "Lennard-HB" +"InteriorFeatures": "Ceiling Fans(s),Eat-in Kitchen,Living Room/Dining Room Combo,Open Floorplan,Stone Counters,Thermostat,Tray Ceiling(s),Walk-In Closet(s)" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "Tampa" +"ListAgentAOR": "Tampa" +"ListAgentDirectPhone": "813-843-7474" +"ListAgentEmail": "andrew@schmidtluxuryhomes.com" +"ListAgentFax": "877-645-1317" +"ListAgentKey": "1100194" +"ListAgentPager": "813-843-7474" +"ListAgentURL": "http://www.schmidtluxuryhomes.com" +"ListOfficeFax": "877-645-1317" +"ListOfficeKey": "1055771" +"ListOfficePhone": "813-645-0500" +"ListOfficeURL": "http://www.schmidtluxuryhomes.com" +"ListingAgreement": "Exclusive Agency" +"ListingContractDate": "2022-10-10" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Builder" +"LotFeatures": array:1 [ 0 => "Street Dead-End" ] +"LotSizeAcres": 0.13 +"LotSizeDimensions": "42x135" +"LotSizeSquareFeet": 5670 +"MLSAreaMajor": "33572 - Apollo Beach / Ruskin" +"MiddleOrJuniorSchool": "Eisenhower-HB" +"MlsStatus": "Expired" +"NewConstructionYN": true +"OccupantType": "Vacant" +"OffMarketDate": "2023-10-10" +"OnMarketDate": "2022-10-11" +"OriginalEntryTimestamp": "2022-10-11T13:59:49Z" +"OriginalListPrice": 1195000 +"OriginatingSystemKey": "595044217" +"Ownership": "Fee Simple" +"ParcelNumber": "U-21-31-19-9AU-000000-00014.0" +"ParkingFeatures": "Driveway,Garage Door Opener" +"PatioAndPorchFeatures": array:2 [ 0 => "Front Porch" 1 => "Rear Porch" ] +"PetsAllowed": array:1 [ 0 => "Yes" ] +"PhotosChangeTimestamp": "2022-12-23T18:26:08Z" +"PhotosCount": 8 +"PropertyCondition": array:1 [ 0 => "Pre-Construction" ] +"PublicSurveyRange": "19" +"PublicSurveySection": "21" +"RoadResponsibility": array:1 [ 0 => "Public Maintained Road" ] +"RoadSurfaceType": array:1 [ 0 => "Paved" ] +"Roof": "Concrete,Tile" +"SecurityFeatures": array:3 [ 0 => "Gated Community" 1 => "Security System" 2 => "Smoke Detector(s)" ] +"Sewer": "Public Sewer" +"ShowingRequirements": array:3 [ 0 => "Call Before Showing" 1 => "Call Owner" 2 => "Locked Gate" ] +"SpecialListingConditions": array:1 [ 0 => "None" ] +"StateOrProvince": "FL" +"StatusChangeTimestamp": "2023-10-11T04:11:35Z" +"StoriesTotal": "2" +"StreetName": "ESTUARY SHORE" +"StreetNumber": "554" +"StreetSuffix": "LANE" +"SubdivisionName": "VENETO SHORES" +"TaxAnnualAmount": "1312.77" +"TaxBlock": "1" +"TaxBookNumber": "112-296" +"TaxLegalDescription": "VENETO SHORES LOT 14 TOGETHER WITH A PARCEL OF SUBMERGED LAND BEING THE EASTERLY 546 FT LESS THE EASTERLY 504 FT THEREOF OF THE FOLLOWING DESC PARCEL: A PARCEL OF SUBMERGED LAND BEING THAT PART OF LOT 20 RUSKIN TOMATO FARMS PLAT BK 27 PG 110 LYING NORTH OF TREVISO PLAT BK 96 PG 72 ALSO LYING NORTH OF THE EASTERLY EXTENSION OF THE NORTH BOUNDARY OF SD TREVISO LESS THE NORTH 210 FT AND LESS THE EAST 540 FT THEREOF" +"TaxLot": "14" +"TaxYear": "2021" +"Township": "31" +"TransactionBrokerCompensation": "2.5%-$350" +"UniversalPropertyId": "US-12057-N-2131199000000000140-R-N" +"Utilities": "Cable Available,Electricity Connected,Sewer Connected,Underground Utilities,Water Connected" +"Vegetation": array:1 [ 0 => "Trees/Landscaped" ] +"View": array:1 [ 0 => "Water" ] +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/T3407188" +"WaterBodyName": "APOLLO BEACH CANAL" +"WaterSource": array:1 [ 0 => "Public" ] +"WaterfrontFeatures": "Canal - Saltwater" +"WaterfrontYN": true +"WindowFeatures": array:2 [ 0 => "Double Pane Windows" 1 => "Impact Glass/Storm Windows" ] +"Zoning": "PD" +"HorseYN_C": "0" +"MlsName_C": "NYStateMLS" +"HamletID_C": "0" +"class_name": "LISTINGS" +"AtticType_C": "0" +"NearBusYN_C": "0" +"StaffBeds_C": "0" +"GarageType_C": "0" +"NoFeeSplit_C": "0" +"SaleOrRent_C": "S" +"StaffBaths_C": "0" +"BrokerWebYN_C": "0" +"KitchenType_C": "Open" +"NearTrainYN_C": "0" +"ShowPriceYN_C": "1" +"UtilitiesYN_C": "0" +"HavePermitYN_C": "0" +"InteriorAmps_C": "0" +"IsSeasonalYN_C": "0" +"LandFrontage_C": "0" +"NearSchoolYN_C": "0" +"AtticAccessYN_C": "0" +"BasesmentSqFt_C": "0" +"HiddenDraftYN_C": "0" +"LastPriceTime_C": "2022-09-15T11:39:46" +"RoomForPoolYN_C": "0" +"CommercialType_C": "0" +"LastStatusTime_C": "2022-11-04T13:36:08" +"RenovationYear_C": "0" +"SchoolDistrict_C": "MONTICELLO CENTRAL SCHOOL DISTRICT" +"CoListAgent2Key_C": "0" +"LastStatusValue_C": "620" +"RoomForGarageYN_C": "0" +"RoomForTennisYN_C": "0" +"BasementBedrooms_C": "0" +"FirstFloorBathYN_C": "1" +"PreWarBuildingYN_C": "0" +"ResidentialStyle_C": "Cottage" +"SouthOfHighwayYN_C": "0" +"BasementBathrooms_C": "0" +"PostWarBuildingYN_C": "0" +"TempOffMarketDate_C": "2022-11-04T04:00:00" +"HandicapFeaturesYN_C": "0" +"KitchenCounterType_C": "0" +"UndisclosedAddressYN_C": "0" +"PercentOfTaxDeductable_C": "0" +"PhotoModificationTimestamp_C": "2022-09-22T01:40:24" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('417060883512011056')" +"provider_name": "Stellar" +"Media": array:8 [ 0 => array:9 [ "Order" => 0 "MediaKey" => "635fe3eb9ab33b4bbe4357c2" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/635fe3eb9ab33b4bbe4357c2.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/thumbnail-635fe3eb9ab33b4bbe4357c2.jpg" "ImageWidth" => 576 "ImageHeight" => 768 "ImageSizeDescription" => "576x768" "MediaModificationTimestamp" => "2022-10-31T15:04:11.866Z" ] 1 => array:9 [ "Order" => 1 "MediaKey" => "63a5f286a5c9b32b4d1b62cb" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/63a5f286a5c9b32b4d1b62cb.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/thumbnail-63a5f286a5c9b32b4d1b62cb.jpg" "ImageWidth" => 576 "ImageHeight" => 768 "ImageSizeDescription" => "576x768" "MediaModificationTimestamp" => "2022-12-23T18:25:10.806Z" ] 2 => array:9 [ "Order" => 2 "MediaKey" => "63a5f286a5c9b32b4d1b62cc" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/63a5f286a5c9b32b4d1b62cc.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/thumbnail-63a5f286a5c9b32b4d1b62cc.jpg" "ImageWidth" => 507 "ImageHeight" => 641 "ImageSizeDescription" => "507x641" "MediaModificationTimestamp" => "2022-12-23T18:25:10.831Z" ] 3 => array:9 [ "Order" => 3 "MediaKey" => "63a5f249324c6d0f23db2904" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/63a5f249324c6d0f23db2904.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/thumbnail-63a5f249324c6d0f23db2904.jpg" "ImageWidth" => 507 "ImageHeight" => 641 "ImageSizeDescription" => "507x641" "MediaModificationTimestamp" => "2022-12-23T18:24:09.210Z" ] 4 => array:9 [ "Order" => 4 "MediaKey" => "63a5f286a5c9b32b4d1b62cd" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/63a5f286a5c9b32b4d1b62cd.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/thumbnail-63a5f286a5c9b32b4d1b62cd.jpg" "ImageWidth" => 597 "ImageHeight" => 768 "ImageSizeDescription" => "597x768" "MediaModificationTimestamp" => "2022-12-23T18:25:10.810Z" ] 5 => array:9 [ "Order" => 5 "MediaKey" => "635fe3eb9ab33b4bbe4357c7" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/635fe3eb9ab33b4bbe4357c7.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/thumbnail-635fe3eb9ab33b4bbe4357c7.jpg" "ImageWidth" => 971 "ImageHeight" => 687 "ImageSizeDescription" => "971x687" "MediaModificationTimestamp" => "2022-10-31T15:04:11.851Z" ] 6 => array:9 [ "Order" => 6 "MediaKey" => "63a5f249324c6d0f23db2906" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/63a5f249324c6d0f23db2906.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/thumbnail-63a5f249324c6d0f23db2906.jpg" "ImageWidth" => 781 "ImageHeight" => 384 "ImageSizeDescription" => "781x384" "MediaModificationTimestamp" => "2022-12-23T18:24:09.236Z" ] 7 => array:9 [ "Order" => 7 "MediaKey" => "635fe3eb9ab33b4bbe4357c9" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/635fe3eb9ab33b4bbe4357c9.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR595044217/thumbnail-635fe3eb9ab33b4bbe4357c9.jpg" "ImageWidth" => 1024 "ImageHeight" => 636 "ImageSizeDescription" => "1024x636" "MediaModificationTimestamp" => "2022-10-31T15:04:11.839Z" ] ] +"ID": "35488" }
554 ESTUARY SHORE LANE, APOLLO BEACH, FL 33572
Active
Pre-Construction
554 ESTUARY SHORE LANE, APOLLO BEACH, FL 33572
554 ESTUARY SHORE LANE, APOLLO BEACH, FL 33572
Overview
Property ID: T3407188
- House (Detached), Residential
- 2
- 1
- 2
- 1939
Description
**This listings is for DEMO/TEST purpose only** Enjoy all that Smallwood and Bethel have to offer in this spacious log sided cottage. A high ceiling in the large living room makes this home feel super inviting. Bask in the sunlight from your oversized custom windows in the living room and kitchen. The deck is perfect for entertaining or just enjo ** To get a real data, please visit https://dashboard.realtyfeed.com
Address
Open on Google Maps- Address 554 ESTUARY SHORE LANE
- City APOLLO BEACH
- State/county FL
- Zip/Postal Code 33572
- Country US
Details
Updated on January 24, 2024 at 9:20 am- Property ID: T3407188
- Price: $175,000
- Land Area: 0.13 Acres
- Bedrooms: 2
- Bathroom: 1
- Garages: 2
- Garage Size: x x
- Year Built: 1939
- Property Type: House (Detached), Residential
- Property Status: Active
Additional details
- Listing Terms: Cash,Conventional
- Association Fee: 1000
- Roof: Concrete,Tile
- Utilities: Cable Available,Electricity Connected,Sewer Connected,Underground Utilities,Water Connected
- Sewer: Public Sewer
- Cooling: Central Air
- Heating: Central,Electric,Heat Pump
- Flooring: Vinyl
- County: Hillsborough
- Property Type: Residential
- Parking: Driveway,Garage Door Opener
- Elementary School: Apollo Beach-HB
- Middle School: Eisenhower-HB
- High School: Lennard-HB
- Community Features: Deed Restrictions,Waterfront
- Waterfront: Canal - Saltwater
- Architectural Style: Custom
360° Virtual Tour
Mortgage Calculator
Monthly
- Down Payment
- Loan Amount
- Monthly Mortgage Payment
- Property Tax
- Home Insurance
- PMI
- Monthly HOA Fees