SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user 'brickellwepim'@'10.123.40.1' for table 'MLS2', query was: INSERT INTO MLS2 (StreetDirPrefix,LivingAreaUnits,YearEstablished,LaundryFeatures,Flooring,PhotosCount,WaterfrontFeatures,RoomBedroomFeatures,SeniorCommunityYN,Cooling,ExteriorFeatures,StatusChangeTimestamp,BuyerAgentFullName,MIAMIRE_TypeofAssociation,TaxExemptions,AssociationFeeFrequency,HeatingYN,CoBuyerAgentStateLicense,RoomDiningRoomFeatures,ListingKeyNumeric,Appliances,MLSAreaMajor,TaxAnnualAmount,MIAMIRE_BuyerCountryofResidence,MIAMIRE_RATIO_CurrentPrice_By_SQFT,CurrentUse,OriginatingSystemKey,CountyOrParish,PropertyType,BathroomsTotalDecimal,OriginatingSystemName,AssociationYN,MlsStatus,StreetNumber,LeaseTerm,ListingKey,CommonWalls,ElementarySchool,StreetDirSuffix,Directions,AttachedGarageYN,StandardStatus,Roof,PoolPrivateYN,BuyerAgentStateLicense,PropertySubType,WaterfrontYN,BathroomsFull,LotSizeAcres,SubdivisionName,Fencing,InternetAddressDisplayYN,MIAMIRE_GuestHouseDescription,WaterSource,DoorFeatures,StoriesTotal,YearBuilt,PetsAllowed,DaysOnMarket,MIAMIRE_MaintenanceIncludes,OtherStructures,AssociationAmenities,ClosePrice,VirtualTourURLZillow,StreetNumberNumeric,LivingArea,CoListAgentStateLicense,ParkingFeatures,PostalCodePlus4,Supplements,PoolFeatures,Heating,StructureType,CoListAgentMlsId,ListingId,CommunityFeatures,BathroomsTotalInteger,RoomsTotal,City,InternetEntireListingDisplayYN,InternetAutomatedValuationDisplayYN,DirectionFaces,PossibleUse,ConstructionMaterials,MIAMIRE_SubdivisionInformation,InternetConsumerCommentYN,BuildingAreaTotal,BedroomsTotal,CoolingYN,ListAgentKey,CarportSpaces,LotSizeUnits,ListAgentEmail,ContractStatusChangeDate,GarageYN,Longitude,Skirt,CarportYN,PublicRemarks,CoListOfficeName,RoadSurfaceType,PriceChangeTimestamp,ListingContractDate,Zoning,ListOfficeName,CoBuyerOfficeName,BusinessType,Latitude,PhotosChangeTimestamp,ListPrice,RoadFrontageType,GreenEnergyGeneration,DOH1,CoListOfficeMlsId,StateOrProvince,CoveredSpaces,MiddleOrJuniorSchool,VirtualTourURLUnbranded,Gas,MIAMIRE_TypeofGoverningBodies,ListOfficeKey,FireplaceYN,BridgeModificationTimestamp,ListAgentFullName,Stories,ParcelNumber,View,HighSchool,LeaseConsideredYN,Levels,MIAMIRE_BuyState,IDXParticipationYN,InteriorFeatures,MIAMIRE_PetsAllowedYN,CloseDate,StreetSuffix,ApprovalStatus,ListAgentMlsId,LotSizeDimensions,ModificationTimestamp,PropertyAttachedYN,Coordinates,CoBuyerOfficeMlsId,Country,UnitNumber,OpenParkingYN,ListOfficeMlsId,ListAgentDirectPhone,CoListAgentFullName,SpaYN,SpaFeatures,BathroomsHalf,RoomLivingRoomFeatures,Sewer,Model,ListAgentStateLicense,StreetName,PatioAndPorchFeatures,Utilities,FireplaceFeatures,WindowFeatures,SpecialListingConditions,NewConstructionYN,NumberOfBuildings,GarageSpaces,GreenEnergyEfficient,RentIncludes,AccessibilityFeatures,SourceSystemKey,BuildingFeatures,Ownership,LotFeatures,PostalCode,MIAMIRE_Style,NumberOfUnitsTotal,BuyerOfficeName,AssociationFee,LotSizeSquareFeet,CoBuyerAgentFullName,Electric,ArchitecturalStyle,RoomMasterBathroomFeatures,UnparsedAddress,id) VALUES ('E','Square Feet','','','Tile',37,'Intracoastal Front','','','Central Air','Barbeque,Open Balcony,Tennis Court(s)','2019-05-02T13:56:10.140Z','','','','','1','','Dining/Living Room',322342057,'Dishwasher,Disposal,Dryer,Ice Maker,Microwave,Electric Range,Refrigerator,Washer','The Yacht Club At Aventur','','',3.56,'','miamire','Miami-Dade County','Residential Lease',2,'Miami Association of REALTORS®','','Active','19701','','d9b66e039e9e3ffeddbbf620ebdec468','','','','','','Active','','','','Condominium','1',2,'','THE YACHT CLUB AT AVENTUR,The Yacht Club','','1','','','High Impact Doors','',1994,'No',2592,'','','Clubhouse,Community Pool,Exercise Room,Guard At Gate,Spa/Hot Tub','','',19701,1180,'','2 Spaces,Detached','4806','','In Ground','Electric','Condo/Co-Op/Seasonal,Condo','','A10664418','',2,'','Aventura','1','1','Northeast','','','','1',1180,2,'1','30f80a2d979b3e151b109637eeb18ba8','','Square Feet','judiberner@aol.com','2019-05-01','',-80.129601,'','','Beautifully renovated Aventura Vacation Rental, large primary bedrooms both with private bathrooms, Relax on the balcony with pool & Marina views. Tastefully furnished , large screen tvs, king size bed & 2 fullsize in guest room, Fully equipped kitchen, washer/dryer, linens, towels included, All the comforts. Includes Electricity, cable, internet Community Amenities : Heated Pool, Jacuzzi, Clubhouse, barbecue, tennis, basketball, newly renovated fitness center, 3 mile path around Turnberry Hotel & golf course, Centrally located to shopping, restaurants, Publix, and the beaches. Available AUGUST 2025 THRU JANUARY 12TH 2026','','','2026-06-03T18:28:49.200Z','2019-05-01','6400','Beachfront Realty Inc','','',25.957465,'2025-08-13T18:22:33.425Z',4200,'','','','','FL',0,'','https://www.propertypanorama.com/instaview/mia/A10664418','','','240a0e4f4f15d333cb30e9a1c344006c','','2026-06-06T02:51:14.611Z','Judi Berner','','28-12-35-071-2270','Bay,Intracoastal View,Pool','','','','','1','Built-in Features,Walk-In Closet(s)','','','','','0412044','','2026-06-03T18:28:49.200Z','','-80.129601,25.957465','','','5606','','ROBR01','786-587-2447','','1','',0,'','','','0412044','Country Club Dr','Open Balcony','','','Clear Impact Glass,Blinds','','','',0,'','','','322342057','','','','33180','Condo/Co-Op/Seasonal','','','',0,'','','Garden Apartment','','19701 E Country Club Dr # 5606, Aventura FL 33180','https://api.bridgedataoutput.com/api/v2/OData/miamire/Property(\'d9b66e039e9e3ffeddbbf620ebdec468\')')