Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T22:56:11.657' ,`MLSNumber` = '44447556' ,`ListAgentFullName` = 'Willie Moore Jr.' ,`ListOfficeName` = 'United Realty' ,`SellingAgentFullName` = 'Lonnie Smith' ,`SellingOfficeName` = 'RE/MAX Premier' ,`Latitude` = '29.386243' ,`Longitude` = '-94.982867' ,`PhotoCount` = '21' ,`PostalCode` = '77591' ,`RoomCount` = '6' ,`ListPrice` = '164990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Anderson' ,`StreetNumber` = '6317' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1738' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare 5 Bedroom 2 Bathroom in La Marque under 170k... Don\'t let this deal pass you by. If your looking for an affordable 5 bedroom with a motivated seller.. this is your stop. Home needs a little attention but for the price its a steal. All Carpet has been removed so that the owner has install hand scrapped laminate flooring in the bedrooms. View today don\'t delay' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 197 T TOBY SUR LOT 13 HUBBARD SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hubbard' ,`TaxAmount` = '1833' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705351' WHERE `Matrix_Unique_ID` = '205875467' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T23:15:26.367' ,`MLSNumber` = '69144108' ,`ListAgentFullName` = 'Shantanu Patil' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.566228' ,`Longitude` = '-95.569758' ,`PhotoCount` = '8' ,`PostalCode` = '77459' ,`RoomCount` = '7' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Stonebrook' ,`StreetNumber` = '4306' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WE WILL START ACCEPTING OFFERS FROM 4/7. INTERIOR SELECTION CHOICES AVAILABLE TILL 5/15\r\nDONT MISS OUT ON THIS LAST OPPORTUNITY TO BUILD YOUR DREAM HOME FROM GROUND UP IN THIS EXCLUSIVE GATED NEIGHBORHOOD OF MANORS AT RIVERSTONE! NO BACK NEIGHBORS, FULL STUCCO HOME WITH 5 MASSIVE BEDROOMS, ALL FEATURING ENSUITE BATHROOMS AND WALK IN CLOSETS. STATE OF THE ART KITCHEN WITH PREMIUM SELECTIONS OF COUNTERTOPS, CABINETS AND HIGH END STAINLESS STEEL APPLIANCES, ISLAND WITH BAR STOOL SEATING. YOU HAVE THE OPPORTUNITY TO CUSTOMIZE THIS HOME TO A CERTAIN EXTENT, CHOOSE YOUR OWN FLOORING (TILE, WOOD, CARPET), WALL COLOR, CABINET COLOR/FINISH, ETC FROM THE AVAILAIBLE PREMIUM SELECTIONS. LOCATED MINUTES AWAY FROM HW6, SHOPPING, DINING, PARKS AND WALKING TRAILS! CALL US FOR MORE DETAILS !' ,`Acres` = '0.1117' ,`Area` = '29' ,`BuilderName` = 'Shree Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MANORS AT RIVERSTONE SEC 1, BLOCK 3, LOT 4, REPLAT' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '4865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Manors At Riverstone' ,`TaxAmount` = '1052' ,`TaxRate` = '2.74' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705351' WHERE `Matrix_Unique_ID` = '206560277' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T23:15:06.727' ,`MLSNumber` = '89565633' ,`ListAgentFullName` = 'Shantanu Patil' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.566612' ,`Longitude` = '-95.571181' ,`PhotoCount` = '11' ,`PostalCode` = '77459' ,`RoomCount` = '6' ,`ListPrice` = '758000.00' ,`Status` = 'Active' ,`StreetName` = 'Serenade Terrace' ,`StreetNumber` = '4314' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WE WILL START ACCEPTING OFFERS FROM 4/7. INTERIOR SELECTION CHOICES AVAILABLE TILL 5/15\r\nTHERE ARE 3 MORE LOTS THAT WE WILL BE CONSTRUCTING NEWER PLANS WITH BIGGER FOOTPRINT (2 LOTS ON STONEBROOK AND 2 MORE LOTS ON SERENADE DR)\r\nDONT MISS OUT ON THIS LAST OPPORTUNITY TO BUILD YOUR DREAM HOME FROM GROUND UP IN THIS EXCLUSIVE GATED NEIGHBORHOOD OF MANORS AT RIVERSTONE! NO BACK NEIGHBORS, STUCCO AND STONE HOME WITH 4 MASSIVE BEDROOMS WITH WALK IN CLOSETS ADDITIONAL MEDIA/FLEX ROOM. STATE OF THE ART KITCHEN WITH PREMIUM SELECTIONS OF COUNTERTOPS, CABINETS AND HIGH END STAINLESS STEEL APPLIANCES, ISLAND WITH BAR STOOL SEATING. \r\nCHECK OUT THE PLAN ATTACHED ON THIS LISTING FOR LAYOUT AND DIMENSIONS OF THE ROOMS .\r\n\r\nLOCATED MINUTES AWAY FROM HW6, SHOPPING, DINING, PARKS AND WALKING TRAILS! CALL PATIL REAL ESTATE GROUP FOR MORE DETAILS !' ,`Acres` = '0.1105' ,`Area` = '29' ,`BuilderName` = 'Shree Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MANORS AT RIVERSTONE SEC 1, BLOCK 4, LOT 4, REPLAT' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Manors At Riverstone Sec 1' ,`TaxAmount` = '1076' ,`TaxRate` = '2.8017' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705352' WHERE `Matrix_Unique_ID` = '206561523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T23:26:20.627' ,`MLSNumber` = '53100515' ,`ListAgentFullName` = 'Rita Dehmer' ,`ListOfficeName` = 'Rita Dehmer,Realtor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.620713' ,`Longitude` = '-95.612104' ,`PhotoCount` = '23' ,`PostalCode` = '77478' ,`RoomCount` = '10' ,`ListPrice` = '2100000.00' ,`Status` = 'Active' ,`StreetName` = 'ALKIRE LAKE' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TRUE MID-CENTURY MODERN CUSTOM RANCH MANSION ON THE WATER. 4 BDRM, 2/1 BATH, OVERSIZED 3 CAR GARAGE, GUEST QUARTERS WITH SHOWER BATH & KITCHENETTE, LARGE DUCK POND (POOL).COMPLETE REMODEL IN 2017 WITH GRANITE, MARBLE, TILE, CARPET, HARDWOOD, TERRAZZO FLOORS. MAHAGONI PANELLING & DOORS. HUGE WALK-IN CLOSETS (ONE IS CEDAR LINED), BUILT-IN CABINETS, & STORAGE GALORE. 4X6 WALK IN BAR, BUILT IN DESK & GUN CASE. LARGE CLASS C FIRE RATED SAFE IN GARAGE. THE WATER VIEWS ARE MAGNIFICENT THRU GLASS DOORS & LARGE WINDOWS. HOME SITS ON AN EXTREMELY QUIET 2 ACRES WITH OLD OAKS. --OR-- BUILD YOUR FOREVER HOME AMONG OTHER AMAZING, CUSTOM FOREVER HOMES BEING BUILT IN THIS LITTLE SLICE OF HEAVEN. AND YES, YOU COULD BRING YOUR HORSE!!\r\nCONVENIENT LOCATION WITH QUICK 20 MIN. TO GALLERIA, OR QUICKER TO NEAR BY FIRST COLONY MALL.' ,`Acres` = '2' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ALKIRE LAKE S/D SEC 2, BLOCK 1, LOT 12' ,`LotDesciption` = 'Cul-De-Sac,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Alkire Lake Sub Sec 2' ,`TaxAmount` = '19906' ,`TaxRate` = '2.062' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705352' WHERE `Matrix_Unique_ID` = '209220123' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T23:03:26.790' ,`MLSNumber` = '66803700' ,`ListAgentFullName` = 'Linda Beltran' ,`ListOfficeName` = 'Premier One Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.918047' ,`Longitude` = '-95.162069' ,`PhotoCount` = '16' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '347900.00' ,`Status` = 'Active' ,`StreetName` = 'Parkers Cove' ,`StreetNumber` = '13711' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Summerwood subdivision home with 4 bedrooms/2 baths. Great kitchen that opens toward the family/living area, with granite countertops, kitchen island, plenty of counter space & cabinets, stainless steel appliances, breakfast area & formal dining room. High ceilings, hardwood & tile flooring. Relaxing outdoors covered patio with outdoors fireplace. Wonderful Home for your family in a great Community with many amenities for plenty of fun activities & less than 5 minutes from nearby popular lakes & parks.' ,`Acres` = '0.1536' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 4 SUMMERWOOD SEC 24 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6691' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood Sec 24' ,`TaxAmount` = '7158' ,`TaxRate` = '2.8532' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705352' WHERE `Matrix_Unique_ID` = '210164714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T23:53:53.240' ,`MLSNumber` = '45357119' ,`ListAgentFullName` = 'Susan Palomino' ,`ListOfficeName` = 'RE/MAX Suburbia' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.394188' ,`Longitude` = '-98.012559' ,`PhotoCount` = '39' ,`PostalCode` = '78669' ,`RoomCount` = '18' ,`ListPrice` = '4100000.00' ,`Status` = 'Active' ,`StreetName` = 'Angel Light' ,`StreetNumber` = '709' ,`StreetSuffix` = 'Drive' ,`City` = 'Spicewood' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '5615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find in La Isla at Angel Bay! A Touch of Tuscany under The Texas Sun…With soaring cathedral ceilings and a heavenly view from every angle in this Texas Tuscan Custom build, there\'s nowhere else to find this palatial, secluded gem than La Isla at Angel Bay. Double covered decks overlook sweeping panoramic views of Lake Travis and the hill country, rivaled only by the luxury found inside the home. Wake up in an Italian villa right here in Texas with rustic architectural details, including rich wood beams, stone arches, and earth-toned tile and granite — all complemented by designer finishes and first-class Viking Appliances. From the gourmet kitchen to spa bathrooms and private access to Lake Travis, this estate home is nothing short of a full-time vacation. You\'ll enjoy the private amenities such as a boat launch and a club house in the gated community of Angel Bay. Not a fan of the Tuscan Style? Let the Decorating begin, ask how!' ,`Acres` = '2.23' ,`Area` = '83' ,`BuilderName` = 'Hausman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 12 LA ISLA AT ANGEL BAY' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront,Wooded' ,`LotSize` = '97139' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '115 - Lake Travis' ,`SchoolElementary` = 'WEST CYPRESS HILLS' ,`SchoolHigh` = 'LAKE TRAVIS HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE TRAVIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Spanish' ,`Subdivision` = 'La Isla At Angel Bay' ,`TaxAmount` = '67910' ,`TaxRate` = '1.8843' ,`WaterSewer` = 'Aerobic,Septic Tank,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705352' WHERE `Matrix_Unique_ID` = '211132890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T22:33:32.033' ,`MLSNumber` = '17221218' ,`ListAgentFullName` = 'Christopher Almaraz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162321' ,`Longitude` = '-95.092287' ,`PhotoCount` = '14' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'ROAD 5102' ,`StreetNumber` = '1484' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful house/floorplan is call \"LA PONDEROSA\" by Casas-Houston LLC. This gorgeous home sits on 0.36 Acre. The Taxes and HOA fees are very low. This is an open floor plan that has 9-foot ceilings, Formations Luxury Resilient Flooring, Rounded Sheetrock Corners, Ceiling fans in the family room and master bedroom, recessed lights, energy efficiencies include Clay brick, American Standard 16 SEER HVAC system, White Vinyl Double Pane, Low-E Windows, Programable Thermostat, Granite Countertops and backsplash, appliances package, Walk-In Showers in Master Bath, Formations luxury resilient flooring. The builder offer a 2/20 Warranty.' ,`Acres` = '0.6' ,`Area` = '52' ,`BuilderName` = 'Casas Houston LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 3, BLOCK 49, LOT 4825, ACRES 0.30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '26136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '918' ,`TaxRate` = '2.154' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705352' WHERE `Matrix_Unique_ID` = '211250517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T22:07:04.373' ,`MLSNumber` = '59846403' ,`ListAgentFullName` = 'Richard Fenyes' ,`ListOfficeName` = 'Rocket, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.674125' ,`Longitude` = '-95.358464' ,`PhotoCount` = '20' ,`PostalCode` = '77051' ,`RoomCount` = '8' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Redbud' ,`StreetNumber` = '4537' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super clean spacious 2022 construction,four bedroom with many upgrades and features.This fantastic home has elevated 10\' foot ceilings with LED recessed lighting package and modern ceiling fans w/lighting throughout.The island kitchen is a beautiful centerpiece with luxurious high-level quartz counters with linear wood cabinetry surrounds,the 10\'quartz kitchen island with 10\"50/50 sink w/bar stool area & pendent lighting is welcoming and functional.The large family room and formal dining area form a modern open floor plan while still providing subtle separation all coming together harmoniously offering optimum living.This spacious home keeps giving with a formal living that can double as a nursery or flex room while the upstairs game room is perfect for lounging or entertainment.The Primary Bedroom offers a privacy balcony perfect to unwind & think.The Primary bath is it\'s own oasis,all baths offer modern LED embedded mirrors,SUPER COOL!The backyard\'s covered patio is AMAZING@31 FEET' ,`Acres` = '0.1205' ,`Area` = '3' ,`BuilderName` = 'TEAM HBC, INC.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 14 EAST SUNNYSIDE COURT SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'East Sunnyside Court Sec 01' ,`TaxAmount` = '857' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705352' WHERE `Matrix_Unique_ID` = '211647697' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211951014','1663705352','211951014','2022-08-31T23:12:40.730','18680200','Sonali Mansukhani','Keller Williams Signature','','','30.045598','-95.463720','24','77388','4','489000.00','Active','Lena Trail','18631','Drive','Spring','3','1','4','3186','Single-Family','Nestled in the quiet community of Mirror Lake, this pristine, meticulously cared for home awaits! Impressive built consists of 4 bedrooms/3 full baths. Inviting entry with high ceilings and tile floors throughout the main areas. Open concept family room w/wall of windows, stone gas log fireplace flows into kitchen & morning area. Island Kitchen w/bar height counter seating, upgraded s/s appliances, walk-in pantry, and granite counters. Spacious owner suite w/garden tub, separate shower, dual sinks, huge closet. Secondary bedrooms have walk in closets and ceiling fans. Two additional full baths offer furniture style cabinets with granite counter tops. Over sized covered back patio. Did not lose power or have any burst pipes during the big freeze! Never Flooded! Highly rated KISD!! Schedule your showing today!','0.1445','13','','','','','Sellers Disclosure','1','Gas Connections','2','Spring/Klein','Central Gas','1','LT 52 BLK 1 CAMP MIRROR LAKE SEC 1 R/P & EXTN','Cul-De-Sac,Subdivision Lot','6293','Appraisal District','','500','0','','2','Convection Oven','0','','','Gas Range','','Composition','32 - Klein','HAUDE ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','STRACK INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Camp Mirror Lake Sub Sec 1 Rep 1','8689','2.569','Public Water,Water District','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212039479','1663705352','212039479','2022-08-31T22:21:22.800','42112969','David Swope','StarCrest Realty, LLC','','','29.795251','-95.841359','16','77493','9','724900.00','Active','Champion','6915','Trail','Katy','3','0','4','3205','Single-Family','Located in the planned community of CANE ISLAND, the City of Katy and KATY ISD, this home has been updated to include new exterior paint, interior paint, new bathroom faucets; refinished wood floors, new carpet in the bedrooms and the game room, new ceiling fans on the covered patio and the garage floors have been power washed and are newly painted as well! The floor plan features a formal entry area, coat and shoe area off the 2 car garage, utility room in the house, an ISLAND KITCHEN, study/library, 4 bedrooms and 3 full bathrooms. There is a 2 car garage PLUS a separate 1 car garage. The back of the home features a COVERED PATIO with an OUTDOOR KITCHEN. The home is on a corner home site that is OVER 1/4 of an ACRE! Schedule your personal tour today!','0.3877','25','','','Electric Dryer Connections,Washer Connections','','Real Estate Owned','1','Gas Connections','1','Katy - Old Towne','Central Gas','1','S422366 CANE ISLAND SECTION 6 BLK 4 LOT 10','Subdivision Lot','16888','Appraisal District','','1200','0','','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','No Appointment Required','Appraisal District','1','Ranch','Cane Island Sec 6','17002','3.4077','Public Sewer,Public Water','2017','Appraisal District'); --> New record created successfully