Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3304 +post_id: "14499" +post_author: 1 +"ListingKey": "417060885002667472" +"ListingId": "T3379167" +"PropertyType": "Residential" +"PropertySubType": "House (Detached)" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-01-24T09:20:45Z" +"RFModificationTimestamp": "2024-01-24T09:20:45.813396+00:00" +"ListPrice": 875000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1353.0 +"BuildingAreaTotal": 0 +"City": "TAMPA" +"PostalCode": "33609" +"UnparsedAddress": "DEMO/TEST 48 SANDPIPER RD" +"Coordinates": array:2 [ 0 => -82.536235 1 => 27.940368 ] +"Latitude": 27.940368 +"Longitude": -82.536235 +"YearBuilt": 1930 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jeff Shelton" +"ListOfficeName": "COMPASS FLORIDA, LLC" +"ListAgentMlsId": "261506235" +"ListOfficeMlsId": "781263" +"OriginatingSystemName": "Demo" +"PublicRemarks": "**This listings is for DEMO/TEST purpose only** Must see for anyone looking for property in Rockaway! Charming three bedroom, two bath classic bungalow on 40x100 set back behind a generous front lawn. This property boasts a private driveway, large secluded backyard, spacious master bedroom on the first floor and a wide open unfinished basement. V ** To get a real data, please visit https://dashboard.realtyfeed.com" +"Appliances": "Bar Fridge,Built-In Oven,Dishwasher,Disposal,Gas Water Heater,Ice Maker,Microwave,Range,Range Hood,Refrigerator,Tankless Water Heater,Wine Refrigerator" +"ArchitecturalStyle": "Contemporary" +"AttachedGarageYN": true +"BathroomsFull": 6 +"BuilderName": "Steven Anthony Luxury Homes" +"BuildingAreaSource": "Builder" +"BuildingAreaUnits": "Square Feet" +"BuyerAgencyCompensation": "2.0%-$350" +"CoListAgentDirectPhone": "813-205-6195" +"CoListAgentFullName": "Christine Mastrilli" +"CoListAgentKey": "32453825" +"CoListAgentMlsId": "261549034" +"CoListOfficeKey": "169647934" +"CoListOfficeMlsId": "781263" +"CoListOfficeName": "COMPASS FLORIDA, LLC" +"ConstructionMaterials": array:2 [ 0 => "Block" 1 => "Stucco" ] +"Cooling": "Central Air,Zoned" +"Country": "US" +"CountyOrParish": "Hillsborough" +"CreationDate": "2024-01-24T09:20:45.813396+00:00" +"CumulativeDaysOnMarket": 395 +"DaysOnMarket": 882 +"DirectionFaces": "North" +"Directions": "South on Westshore Blvd to west on Azeele St. to S. Hoover. Left on S. Hoover to Sandpiper Rd. Property is on the right." +"ElementarySchool": "Grady-HB" +"ExteriorFeatures": "French Doors,Irrigation System,Outdoor Kitchen" +"Fencing": array:2 [ 0 => "Fenced" 1 => "Vinyl" ] +"FireplaceFeatures": array:2 [ 0 => "Gas" 1 => "Family Room" ] +"FireplaceYN": true +"Flooring": "Tile,Wood" +"FoundationDetails": array:1 [ 0 => "Stem Wall" ] +"GarageSpaces": "3" +"GarageYN": true +"Heating": "Central,Zoned" +"HighSchool": "Hillsborough-HB" +"InteriorFeatures": "Built-in Features,High Ceilings,Kitchen/Family Room Combo,Master Bedroom Main Floor,Master Bedroom Upstairs,Open Floorplan,Smart Home,Split Bedroom,Stone Counters,Thermostat,Walk-In Closet(s),Wet Bar" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ 0 => "Inside" 1 => "Other" 2 => "Upper Level" ] +"Levels": array:1 [ 0 => "Three Or More" ] +"ListAOR": "Tampa" +"ListAgentAOR": "Tampa" +"ListAgentDirectPhone": "813-355-0744" +"ListAgentEmail": "sales@hughesshelton.com" +"ListAgentFax": "786-733-3644" +"ListAgentKey": "1098802" +"ListAgentOfficePhoneExt": "7812" +"ListAgentPager": "813-690-1688" +"ListAgentURL": "http://www.HughesShelton.com" +"ListOfficeFax": "786-733-3644" +"ListOfficeKey": "169647934" +"ListOfficePhone": "813-355-0744" +"ListOfficeURL": "http://www.HughesShelton.com" +"ListTeamKey": "TM98923440" +"ListTeamKeyNumeric": "574335208" +"ListTeamName": "Hughes Shelton Group" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2022-06-13" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Builder" +"LotFeatures": array:2 [ 0 => "City Limits" 1 => "Paved" ] +"LotSizeAcres": 0.24 +"LotSizeDimensions": "80x130" +"LotSizeSquareFeet": 10400 +"MLSAreaMajor": "33609 - Tampa / Palma Ceia" +"MiddleOrJuniorSchool": "Coleman-HB" +"MlsStatus": "Canceled" +"NewConstructionYN": true +"OccupantType": "Vacant" +"OffMarketDate": "2023-07-13" +"OnMarketDate": "2022-06-13" +"OriginalEntryTimestamp": "2022-06-13T11:56:43Z" +"OriginalListPrice": 6995000 +"OriginatingSystemKey": "580263566" +"OtherEquipment": array:1 [ 0 => "Generator" ] +"Ownership": "Fee Simple" +"ParcelNumber": "A-19-29-18-3LE-000000-00004.0" +"ParkingFeatures": "Driveway,Garage Door Opener,Ground Level,Oversized" +"PatioAndPorchFeatures": array:4 [ 0 => "Covered" 1 => "Front Porch" 2 => "Patio" 3 => "Rear Porch" ] +"PetsAllowed": array:1 [ 0 => "Yes" ] +"PhotosChangeTimestamp": "2022-11-06T01:56:08Z" +"PhotosCount": 13 +"PoolFeatures": "Gunite,Heated,In Ground,Lighting,Salt Water" +"PoolPrivateYN": true +"PostalCodePlus4": "3528" +"PrivateRemarks": "To be built- Builder reserves right to change designs, specs, products based upon approved architectural drawings. Customization can still be made." +"PropertyCondition": array:1 [ 0 => "Pre-Construction" ] +"PublicSurveyRange": "18" +"PublicSurveySection": "19" +"RoadSurfaceType": array:1 [ 0 => "Paved" ] +"Roof": "Tile" +"Sewer": "Public Sewer" +"ShowingRequirements": array:2 [ 0 => "Go Direct" 1 => "ShowingTime" ] +"SpaFeatures": array:2 [ 0 => "Heated" 1 => "In Ground" ] +"SpaYN": true +"SpecialListingConditions": array:1 [ 0 => "None" ] +"StateOrProvince": "FL" +"StatusChangeTimestamp": "2023-07-14T04:30:15Z" +"StoriesTotal": "3" +"StreetName": "SANDPIPER" +"StreetNumber": "48" +"StreetSuffix": "ROAD" +"SubdivisionName": "BAYSHORE ESTATES 4" +"TaxAnnualAmount": "13574.28" +"TaxBlock": "-" +"TaxBookNumber": "31-85" +"TaxLegalDescription": "BAYSHORE ESTATES NO 4 LOT 4" +"TaxLot": "4" +"TaxYear": "2021" +"Township": "29" +"TransactionBrokerCompensation": "2.0%-$350" +"UniversalPropertyId": "US-12057-N-1929183000000000040-R-N" +"Utilities": "Cable Available,Electricity Available,Natural Gas Connected,Public,Sewer Connected,Sprinkler Meter,Street Lights,Water Connected" +"Vegetation": array:1 [ 0 => "Trees/Landscaped" ] +"View": array:1 [ 0 => "Water" ] +"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/T3379167" +"WaterSource": array:1 [ 0 => "Public" ] +"WaterfrontFeatures": "Marina" +"WaterfrontYN": true +"WindowFeatures": array:2 [ 0 => "Low Emissivity Windows" 1 => "Thermal Windows" ] +"Zoning": "RS-75" +"HorseYN_C": "0" +"MlsName_C": "NYStateMLS" +"HamletID_C": "0" +"class_name": "LISTINGS" +"AtticType_C": "0" +"NearBusYN_C": "1" +"StaffBeds_C": "0" +"GarageType_C": "0" +"NoFeeSplit_C": "0" +"SaleOrRent_C": "S" +"StaffBaths_C": "0" +"BrokerWebYN_C": "0" +"KitchenType_C": "Galley" +"NearTrainYN_C": "0" +"ShowPriceYN_C": "1" +"UtilitiesYN_C": "0" +"HavePermitYN_C": "0" +"InteriorAmps_C": "0" +"IsSeasonalYN_C": "0" +"LandFrontage_C": "0" +"NearSchoolYN_C": "0" +"Neighborhood_C": "Neponsit" +"AtticAccessYN_C": "0" +"BasesmentSqFt_C": "0" +"HiddenDraftYN_C": "0" +"LastPriceTime_C": "2022-06-30T04:00:00" +"RoomForPoolYN_C": "1" +"CommercialType_C": "0" +"RenovationYear_C": "0" +"CoListAgent2Key_C": "0" +"LastStatusValue_C": "0" +"RoomForGarageYN_C": "0" +"RoomForTennisYN_C": "0" +"BasementBedrooms_C": "0" +"FirstFloorBathYN_C": "0" +"PreWarBuildingYN_C": "0" +"ResidentialStyle_C": "A-Frame" +"SouthOfHighwayYN_C": "0" +"BasementBathrooms_C": "0" +"PostWarBuildingYN_C": "0" +"HandicapFeaturesYN_C": "0" +"KitchenCounterType_C": "0" +"UndisclosedAddressYN_C": "0" +"PercentOfTaxDeductable_C": "0" +"PhotoModificationTimestamp_C": "2022-10-18T18:28:56" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('417060885002667472')" +"provider_name": "Stellar" +"Media": array:13 [ 0 => array:9 [ "Order" => 0 "MediaKey" => "62a726174c02664720901941" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/62a726174c02664720901941.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-62a726174c02664720901941.jpg" "ImageWidth" => 1024 "ImageHeight" => 575 "ImageSizeDescription" => "1024x575" "MediaModificationTimestamp" => "2022-06-13T11:57:11.627Z" ] 1 => array:9 [ "Order" => 1 "MediaKey" => "62a726174c02664720901942" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/62a726174c02664720901942.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-62a726174c02664720901942.jpg" "ImageWidth" => 1024 "ImageHeight" => 575 "ImageSizeDescription" => "1024x575" "MediaModificationTimestamp" => "2022-06-13T11:57:11.687Z" ] 2 => array:9 [ "Order" => 2 "MediaKey" => "62a726174c02664720901943" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/62a726174c02664720901943.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-62a726174c02664720901943.jpg" "ImageWidth" => 1024 "ImageHeight" => 768 "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2022-06-13T11:57:11.701Z" ] 3 => array:9 [ "Order" => 3 "MediaKey" => "62a726174c02664720901944" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/62a726174c02664720901944.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-62a726174c02664720901944.jpg" "ImageWidth" => 1024 "ImageHeight" => 768 "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2022-06-13T11:57:11.699Z" ] 4 => array:9 [ "Order" => 4 "MediaKey" => "62a726174c02664720901945" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/62a726174c02664720901945.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-62a726174c02664720901945.jpg" "ImageWidth" => 1024 "ImageHeight" => 768 "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2022-06-13T11:57:11.635Z" ] 5 => array:9 [ "Order" => 5 "MediaKey" => "62a726174c02664720901946" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/62a726174c02664720901946.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-62a726174c02664720901946.jpg" "ImageWidth" => 1024 "ImageHeight" => 681 "ImageSizeDescription" => "1024x681" "MediaModificationTimestamp" => "2022-06-13T11:57:11.652Z" ] 6 => array:9 [ "Order" => 6 "MediaKey" => "62a726174c02664720901947" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/62a726174c02664720901947.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-62a726174c02664720901947.jpg" "ImageWidth" => 1024 "ImageHeight" => 681 "ImageSizeDescription" => "1024x681" "MediaModificationTimestamp" => "2022-06-13T11:57:11.682Z" ] 7 => array:9 [ "Order" => 7 "MediaKey" => "62a726174c02664720901948" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/62a726174c02664720901948.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-62a726174c02664720901948.jpg" "ImageWidth" => 1024 "ImageHeight" => 682 "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2022-06-13T11:57:11.644Z" ] 8 => array:9 [ "Order" => 8 "MediaKey" => "62a726174c02664720901949" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/62a726174c02664720901949.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-62a726174c02664720901949.jpg" "ImageWidth" => 1024 "ImageHeight" => 682 "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2022-06-13T11:57:11.673Z" ] 9 => array:9 [ "Order" => 9 "MediaKey" => "636713fe2ddef218a9467ece" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/636713fe2ddef218a9467ece.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-636713fe2ddef218a9467ece.jpg" "ImageWidth" => 1024 "ImageHeight" => 575 "ImageSizeDescription" => "1024x575" "MediaModificationTimestamp" => "2022-11-06T01:55:10.960Z" ] 10 => array:9 [ "Order" => 10 "MediaKey" => "636713fe2ddef218a9467ecf" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/636713fe2ddef218a9467ecf.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-636713fe2ddef218a9467ecf.jpg" "ImageWidth" => 1024 "ImageHeight" => 575 "ImageSizeDescription" => "1024x575" "MediaModificationTimestamp" => "2022-11-06T01:55:10.952Z" ] 11 => array:9 [ "Order" => 11 "MediaKey" => "636713fe2ddef218a9467ed0" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/636713fe2ddef218a9467ed0.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-636713fe2ddef218a9467ed0.jpg" "ImageWidth" => 1024 "ImageHeight" => 575 "ImageSizeDescription" => "1024x575" "MediaModificationTimestamp" => "2022-11-06T01:55:10.964Z" ] 12 => array:9 [ "Order" => 12 "MediaKey" => "636713fe2ddef218a9467ed1" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/636713fe2ddef218a9467ed1.jpg" "MediaType" => "jpg" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR580263566/thumbnail-636713fe2ddef218a9467ed1.jpg" "ImageWidth" => 1024 "ImageHeight" => 575 "ImageSizeDescription" => "1024x575" "MediaModificationTimestamp" => "2022-11-06T01:55:10.970Z" ] ] +"ID": "14499" }
Active
Pre-Construction
48 SANDPIPER ROAD, TAMPA, FL 33609
48 SANDPIPER ROAD, TAMPA, FL 33609
Overview
Property ID: T3379167
- House (Detached), Residential
- 3
- 2
- 3
- 1930
Description
**This listings is for DEMO/TEST purpose only** Must see for anyone looking for property in Rockaway! Charming three bedroom, two bath classic bungalow on 40×100 set back behind a generous front lawn. This property boasts a private driveway, large secluded backyard, spacious master bedroom on the first floor and a wide open unfinished basement. V ** To get a real data, please visit https://dashboard.realtyfeed.com
Address
Open on Google Maps- Address 48 SANDPIPER ROAD
- City TAMPA
- State/county FL
- Zip/Postal Code 33609
- Country US
Details
Updated on January 24, 2024 at 9:20 am- Property ID: T3379167
- Price: $875,000
- Land Area: 0.24 Acres
- Bedrooms: 3
- Bathrooms: 2
- Garages: 3
- Garage Size: x x
- Year Built: 1930
- Property Type: House (Detached), Residential
- Property Status: Active
Additional details
- Listing Terms: Cash,Conventional
- Roof: Tile
- Utilities: Cable Available,Electricity Available,Natural Gas Connected,Public,Sewer Connected,Sprinkler Meter,Street Lights,Water Connected
- Sewer: Public Sewer
- Cooling: Central Air,Zoned
- Heating: Central,Zoned
- Flooring: Tile,Wood
- County: Hillsborough
- Property Type: Residential
- Pool: Gunite,Heated,In Ground,Lighting,Salt Water
- Parking: Driveway,Garage Door Opener,Ground Level,Oversized
- Elementary School: Grady-HB
- Middle School: Coleman-HB
- High School: Hillsborough-HB
- Waterfront: Marina
- Architectural Style: Contemporary
360° Virtual Tour
Mortgage Calculator
Monthly
- Down Payment
- Loan Amount
- Monthly Mortgage Payment
- Property Tax
- Home Insurance
- PMI
- Monthly HOA Fees