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-09-07T21:02:25.640' ,`MLSNumber` = '72418021' ,`ListAgentFullName` = 'Kristina Santana' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.352438' ,`Longitude` = '-95.080853' ,`PhotoCount` = '25' ,`PostalCode` = '77327' ,`RoomCount` = '2' ,`ListPrice` = '119000.00' ,`Status` = 'Active' ,`StreetName` = 'Church' ,`StreetNumber` = '1217' ,`StreetSuffix` = 'Avenue' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming updated 2 bedroom 1 bath home. 1 year old appliances, new flooring, new paint. Kitchen has brand new Granite counter tops, beautiful white cabinets and white tile back splash. New stack-able washer and dryer. Updated restroom. Large backyard.' ,`Acres` = '0.1607' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SMITH-CLEV, BLOCK A, LOT 5, ACRES .1607' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Smith-Clev' ,`TaxAmount` = '1648' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707970' WHERE `Matrix_Unique_ID` = '203243019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T21:02:02.707' ,`MLSNumber` = '47592719' ,`ListAgentFullName` = 'Kristina Santana' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.382461' ,`Longitude` = '-94.986623' ,`PhotoCount` = '32' ,`PostalCode` = '77591' ,`RoomCount` = '3' ,`ListPrice` = '140000.00' ,`Status` = 'Active' ,`StreetName` = 'Cobb' ,`StreetNumber` = '108' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled one bedroom home located in La Marque. Enjoy the oversized yard with plenty of room. This renovated home features a gourmet kitchen with brandnew stainless steel appliances, quartz countertops, and the fridge is included. Conveniently located near restaurants and major highways while offering an updated bathroom plus plenty of room, this home is a must see.' ,`Acres` = '0.1213' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 638 J LEAGUE SUR LOT 91 THELMA D ARMSTRONG SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5283' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '34 - La Marque' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Armstrong T D' ,`TaxAmount` = '1741' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707971' WHERE `Matrix_Unique_ID` = '203448080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:57:44.483' ,`MLSNumber` = '12850091' ,`ListAgentFullName` = 'Kristina Santana' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.503714' ,`Longitude` = '-95.088895' ,`PhotoCount` = '32' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '179500.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Creek' ,`StreetNumber` = '713' ,`StreetSuffix` = 'Avenue' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PARTIALLY RENOVATED CHARMING HOME, SPACIOUS FLOOR PLAN, 3 BEDS, 2 BATHS, LARGE MARTER BATHROOM WITH BATHROOM, TWO ADDITIONAL NICE SIZE BEDROOMS. WASHER&DRYER CONNECTIONS HOUSE IS CONVENIENTLY LOCATED CLOSE TO FWY, SHOPPING CENTERS AND RESTAURANTS.' ,`Acres` = '0.172' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 3 S F AUSTIN SUR PT OF LOT 3 (3-1) BLK G CLEAR CREEK SU' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LEAGUE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Creek Blk G' ,`TaxAmount` = '2252' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707971' WHERE `Matrix_Unique_ID` = '204222275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:59:39.267' ,`MLSNumber` = '15161642' ,`ListAgentFullName` = 'Kristina Santana' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844864' ,`Longitude` = '-95.280628' ,`PhotoCount` = '29' ,`PostalCode` = '77028' ,`RoomCount` = '4' ,`ListPrice` = '193500.00' ,`Status` = 'Active' ,`StreetName` = 'Lynette' ,`StreetNumber` = '8038' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming bungalow fully renovated. Appliances included: refrigerator, gas stove, washer and dryer. Beautiful laminate wood style floor throughout the home. Fresh painted white cabinetry and white subway tile back splash. New grey granite countertops along the kitchen. Great big back yard, fully fenced, ready for family BBQ\'s and/or events. Carport attached to home to keep your vehicle in the shade and out of the HOT Texas sun.' ,`Acres` = '0.182' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 543 BLK 27 CLAIRMONT PLACE SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clairmont Place Sec' ,`TaxAmount` = '1736' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707971' WHERE `Matrix_Unique_ID` = '205079617' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T21:02:44.217' ,`MLSNumber` = '31806654' ,`ListAgentFullName` = 'Kristina Santana' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.386948' ,`Longitude` = '-94.980329' ,`PhotoCount` = '20' ,`PostalCode` = '77591' ,`RoomCount` = '4' ,`ListPrice` = '109000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodrow' ,`StreetNumber` = '6113' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING HOME! FULLY RENOVATED, WOOD FLOOR THROUGH THE WHOLE HOUSE, 2 BEDS 1 BATH, SPACIOUS MASTER BEDROOM, FULL BATH , LARGE LIVING ROOM FOR FAMILY ENTERTAINING, NICE KITCHEN WITH STAIN-LESS STEEL APPLIANCES, WAHER &DRYER ARE INCLUDED. LARGE PATIO FOR CHILDREN ACTIVITIES AND SUMMER PARTIES. THIS HOME IS CONVENIENT LOCATED CLOSE TO FWY, SHOPPING CENTERS AND RESTAURANTS. CALL/TEXT' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 197 M AUSTIN SUR LOT 43 WRIGHT CUNEY SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wright Cuney' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707971' WHERE `Matrix_Unique_ID` = '205081300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:32:10.223' ,`MLSNumber` = '2620155' ,`ListAgentFullName` = 'Fabiola Oropeza' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504637' ,`Longitude` = '-95.093673' ,`PhotoCount` = '14' ,`PostalCode` = '77573' ,`RoomCount` = '2' ,`ListPrice` = '189000.00' ,`Status` = 'Active' ,`StreetName` = 'Saunders' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 bed 1 bath in quiet neighborhood. Great schools! Close to Space Center, Kemah, Galveston, dining, and shopping. Schedule your showing today!' ,`Acres` = '0.3293' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 3 S F AUSTIN SUR LOT 34 PATTON SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '14345' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Patton 1' ,`TaxAmount` = '2444' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707971' WHERE `Matrix_Unique_ID` = '205500307' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T21:32:52.627' ,`MLSNumber` = '52160740' ,`ListAgentFullName` = 'Norma Ramos' ,`ListOfficeName` = 'DLR Properties, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808408' ,`Longitude` = '-94.896393' ,`PhotoCount` = '46' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Fall' ,`StreetNumber` = '7919' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move-in fully renovated home in 2022 conveniently located near Chambers Town Center only 30 minutes from downtown Houston and easy access to I-10 and SH 146. This beautiful four-bedroom house features an upgraded kitchen with quartz countertops, stove, microwave, and dishwasher. Experience an established neighborhood in a home with HVAC system installed 2022, updated restrooms, lighting, doorknobs and interior/exterior paint. The dining and living area include a cozy fireplace with access to the rear porch with an extended patio and storage shed. The primary bedroom features a spacious walk-in closet and private double sink bathroom. 3 secondary bedrooms with walk-in closets, and spacious game room with tile and carpet on the second floor. Must see to appreciate so call now to set up a private tour!' ,`Acres` = '0.155' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 HUNTERS CHASE SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6752' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Chase Sec 02' ,`TaxAmount` = '6917' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707971' WHERE `Matrix_Unique_ID` = '207456471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:39:34.593' ,`MLSNumber` = '16356918' ,`ListAgentFullName` = 'Becky Wied' ,`ListOfficeName` = 'Wied Realty' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '28.830095' ,`Longitude` = '-96.404138' ,`PhotoCount` = '42' ,`PostalCode` = '77465' ,`RoomCount` = '7' ,`ListPrice` = '248500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'CR 453 aka Francitas RD' ,`StreetNumber` = '3009' ,`StreetSuffix` = '' ,`City` = 'Palacios' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***UPDATE *** Flood insurance is available for this property \r\n\r\nFisherman\'s paradise. Steps away from the water and your own private boathouse and dock. Views of West Carancahua Creek from the kitchen and living rooms. From Carancahua Bay go under the HWY 35 bridge outside of Cape Carancahua and head up river, when it splits stay left into West Carancahua Creek. Property is on the left as you approach, and up to, the CR 453 bridge. Aerobic septic system and private water well. Home constructed with the possibility of flooding in mind. Built with cement blocks and stucco on lower level. Inside there are only 3 walls that are sheetrock. Cabinets and counter-tops are made of brick and granite. Seller has not had water in the house since she had FEMA flood barriers installed at the 2 exterior entries. Legacy flood barrier system on entry doors. Flood insurance IS available on this property.' ,`Acres` = '1.63' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A5017 DENTON, JOHN, ACRES 1.63' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '71003' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '273 - Industrial' ,`SchoolElementary` = 'INDUSTRIAL EAST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'INDUSTRIAL HIGH SCHOOL' ,`SchoolMiddle` = 'INDUSTRIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Survey Abstract#17' ,`TaxAmount` = '3207' ,`TaxRate` = '1.947' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707971' WHERE `Matrix_Unique_ID` = '207839867' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:59:24.727' ,`MLSNumber` = '86061667' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Arlene Hinsley' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.683774' ,`Longitude` = '-95.835712' ,`PhotoCount` = '40' ,`PostalCode` = '77406' ,`RoomCount` = '15' ,`ListPrice` = '589632.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Alina Brook' ,`StreetNumber` = '10727' ,`StreetSuffix` = 'Trace' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Ellicott, Elevation B) CURRENTLY BEING BUILT. Two story. 4 bedrooms, 3.5 baths. Primary suite with large walk-in closet. Second bedroom on first floor with private bath. Grand foyer with winding staircase & rotunda ceiling. First floor study and informal dining adjacent to the island kitchen. Upstairs additional 2 bedrooms, bathroom, game room and media room. Covered patio and attached 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '0.1561' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6798' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707971' WHERE `Matrix_Unique_ID` = '208360681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:54:43.777' ,`MLSNumber` = '37765623' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Tasmina Lakhani' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '29.571606' ,`Longitude` = '-95.738433' ,`PhotoCount` = '32' ,`PostalCode` = '77469' ,`RoomCount` = '18' ,`ListPrice` = '689857.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Colonel Fields' ,`StreetNumber` = '2223' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VII, Elevation B) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Family room, formal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Extended covered rear patio and attached 3-car garage. Spanning nearly 600 acres of beautiful homes, lush landscaping, trails, and exciting amenities, Veranda embodies the legacy of historic Richmond with all the comforts of a luxurious master-planned community. Minutes to the newly expanded I-69 and the Grand Parkway, you are near exceptional shopping, dining and recreation. Stop by the Westin Homes model home today to find out more about Veranda!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12017' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707972' WHERE `Matrix_Unique_ID` = '208881408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:03:01.320' ,`MLSNumber` = '12267771' ,`ListAgentFullName` = 'Siriporn Vann' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800443' ,`Longitude` = '-95.475480' ,`PhotoCount` = '15' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Antoine' ,`StreetNumber` = '1634' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story layout that needs TLC, home has a great floor plan and on spacious lot. One apartment with full bath is leased out with monthly income. Large driveway for extra parking space. Home can be zone to commercial or residential. Investors please take a look at this great lot, with other homes being remodeled into million dollar property. Must see.' ,`Acres` = '0.1983' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 4 PINE TERRACE SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '8640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Pine Terrace Sec 03' ,`TaxAmount` = '5895' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663707972' WHERE `Matrix_Unique_ID` = '209033447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:58:30.173' ,`MLSNumber` = '47913672' ,`ListAgentFullName` = 'Kristina Santana' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851971' ,`Longitude` = '-95.284784' ,`PhotoCount` = '18' ,`PostalCode` = '77078' ,`RoomCount` = '2' ,`ListPrice` = '124900.00' ,`Status` = 'Active' ,`StreetName` = 'Hamlet' ,`StreetNumber` = '7870' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0579' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 PARK NORTH SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2524' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Park North Sec 01' ,`TaxAmount` = '798' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707972' WHERE `Matrix_Unique_ID` = '209324114' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:10:41.170' ,`MLSNumber` = '25233818' ,`ListAgentFullName` = 'Gina Fisher' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072395' ,`Longitude` = '-95.158150' ,`PhotoCount` = '37' ,`PostalCode` = '77345' ,`RoomCount` = '11' ,`ListPrice` = '770000.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Maples' ,`StreetNumber` = '2106' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3941' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You can be on vacation every day with this waterfront home! Beautifully renovated home with expansive lake waterfront, multiple docks with electric boat lifts and unlimited water entertainment! 2 boat slips and jet ski lift, and paddle boats included. Elevated entertaining deck with amazing views and access to Lake Houston. Beautiful 4 bedroom home with primary suite downstairs and 3 bedrooms upstairs with media/game room that could be a 5th bedroom. Elegant kitchen remodeled with quartz counters and 6 burner gas range with griddle and double ovens. Complete with high end stainless steel refrigerator and washer and dryer. The home offers a butler\'s pantry, a laundry room with custom mudroom builtins, and 2 climate controlled storage rooms. The primary suite offers a wall of windows with view of the lake and a freestanding soaking tub in the luxurious en-suite bathroom with separate vanities and frameless glass shower. Lake front living at it\'s finest!' ,`Acres` = '0.6273' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 50 BLK 1 RIVERCHASE SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '27325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '706' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverchase Sec 05' ,`TaxAmount` = '11250' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707972' WHERE `Matrix_Unique_ID` = '209491228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:36:45.567' ,`MLSNumber` = '5310960' ,`ListAgentFullName` = 'Pamela Brooks' ,`ListOfficeName` = 'Paula Mutina Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.115322' ,`Longitude` = '-95.340236' ,`PhotoCount` = '50' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Port' ,`StreetNumber` = '428' ,`StreetSuffix` = 'Road' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FISH AND FARM!! THIS 3-2 BARDOMINIUM SITS ON 7.75 ACRES!! THIS BEAUTIFUL PROPERTY HAS MATURE TREES AND A VERY LARGE FISHING POND, CLOSE TO A PUBLIC BOAT RAMP, 2300 SQ. FT. POLE BARN OPEN AIR PERFECT FOR STORING BOATS OR TRAILERS, 3220 TOTAL AREA PREFAB ALL STEEL BUILDING AND 1570 LIVING SPACE BUILT IN 2016, CUSTOM KITCHEN WITH GRANITE AND GAS STOVE, BREAKFAST BAR, COZY LIVING WITH LARGE GAS FIREPLACE, INDOOR UTILITY, LARGE PRIMARY BATH WITH WALK IN CUSTOM TILE SHOWER, SECONDARY BATH HAS LARGE GARDEN TUB AND SHOWER COMBO, MODERN UPDATES, 1680 SQ. FT. COVERED PATIO FOR LARGE GATHERINGS, REMAINING SPACE FOR STORAGE AND POTENTIAL HORSE STALLS, BONUS ROOM WITH BAR FOR ENTERTAINING INSIDE GARAGE AREA WITH ADDITIONAL HALF BATH, ROAD FRONTAGE ON TWO SIDES OF THE PROPERTY FOR EASY ACCESS TO HORSES AND CATTLE. LIVE YOUR OUTDOOR DREAM HERE ON THIS UNRESTRICTED PROPERTY.' ,`Acres` = '7.75' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PORT AU PRINCE (BLK A & BLK B) (A0332 J M MUSQUEZ) BLK A LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '337590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'Port Au Prince Blk A & Blk B' ,`TaxAmount` = '2848' ,`TaxRate` = '2.0696' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707972' WHERE `Matrix_Unique_ID` = '209535649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:24:53.530' ,`MLSNumber` = '24535100' ,`ListAgentFullName` = 'Betsy Scofield' ,`ListOfficeName` = 'Jim Assad & Assoc., Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.013110' ,`Longitude` = '-95.734631' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '14' ,`ListPrice` = '1050000.00' ,`Status` = 'Active' ,`StreetName` = 'Baston Creek' ,`StreetNumber` = '16406' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '5051' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect home for large or multi-generational living! The private 2nd bedroom on the first floor has it\'s own full bath and each bedroom upstairs has it\'s own bath. The 1 bedrm /1 bath quarters, which allows space for guest or live-in opportunities, has a private entrance to the front courtyard, or can be accessed through the attached garage. 20\'ceilings in main living areas. 13\'ceilings in the rest of the downstairs. The gameroom and media room are both on the first floor. Private office/study opens to the master bedroom. The master bath has a magnificent double walk-in shower. The master closet has out-of-season hanging racks as well as many built-in shelves. Upstairs is a 13\' homework or technology area w two built-in desk spaces plus cabinets and book shelves. The fantastic kitchen is open to the family room and breakfast room. The whole main living area has tall windows overlooking the 31\' covered back patio. This home in the Estate section sits on a 120\' cul-de-sac lot.' ,`Acres` = '0.4339' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 10 FALLS AT DRY CREEK SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '18901' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KEITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls/Dry Crk Sec 1' ,`TaxAmount` = '19965' ,`TaxRate` = '3.5317' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707972' WHERE `Matrix_Unique_ID` = '209938526' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T21:03:31.860' ,`MLSNumber` = '18329337' ,`ListAgentFullName` = 'Emely Rodriguez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850418' ,`Longitude` = '-95.608306' ,`PhotoCount` = '21' ,`PostalCode` = '77041' ,`RoomCount` = '10' ,`ListPrice` = '639900.00' ,`Status` = 'Active' ,`StreetName` = 'Honor' ,`StreetNumber` = '5543' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding 2-story brick home on oversized lot near the Energy Corridor in Twin Lakes. Homes features both formals, large kitchen, landscape lighting front & back, plantation shutters. Updates include Roof\'09, Furnace\'08, Water heaters\'12, Kitchen\'07, Master Bath\'11, Bath\'11, upstairs gameroom new wood floor\'14, etc. See Addendum Property Description for more information.' ,`Acres` = '0.3194' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 3 TWIN LAKES SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1725' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Lakes Sec 04' ,`TaxAmount` = '10140' ,`TaxRate` = '2.347' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707972' WHERE `Matrix_Unique_ID` = '210856638' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:50:32.920' ,`MLSNumber` = '10265098' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Vincent Oyubu' ,`SellingOfficeName` = 'Delta Realty Company' ,`Latitude` = '29.877169' ,`Longitude` = '-95.793043' ,`PhotoCount` = '30' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '448537.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Winterberry Glen' ,`StreetNumber` = '7114' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Retreat, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 2.5 baths. Spacious island kitchen open to Family room and dining room. Primary suite with large walk-in closet. Covered patio and attached 2 car garage. Just minutes from the Grand Parkway, Elyson is located in the Heart of Katy! The Elyson Café is the center of this community and offers a full food and drinks menu plus a coffee bar. Community amenities also include a pool, fitness center, game room, event lawn, tennis courts, parks and trails, and so much more. Stop by the Westin Homes model to learn more about Elyson!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707973' WHERE `Matrix_Unique_ID` = '211526423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T21:03:32.263' ,`MLSNumber` = '51579109' ,`ListAgentFullName` = 'Jennifer Dang' ,`ListOfficeName` = 'VNA Realty & Mortgage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.948905' ,`Longitude` = '-95.458030' ,`PhotoCount` = '15' ,`PostalCode` = '77067' ,`RoomCount` = '3' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Lacewing' ,`StreetNumber` = '2314' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Owner/Agent.\r\n3-2-2 Ready to move in. Updated kitchen, tile floor, Bath rooms. Great location. On the corner lot. Spacious living toom,. \r\nConvenience , easy to access to belt 8, Hwy 249, I 45/\r\nEstinate Measurements. Please verify. \r\nHurry. It won\'t last long.' ,`Acres` = '0.1567' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 12 LINCOLN GREEN EAST SEC 1' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CONLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'PLUMMER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lincoln Green East Sec 01' ,`TaxAmount` = '4037' ,`TaxRate` = '2.8128' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707973' WHERE `Matrix_Unique_ID` = '211611578' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T20:56:20.120' ,`MLSNumber` = '97647347' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Pitor Naomi' ,`SellingOfficeName` = 'Wolex Properties' ,`Latitude` = '29.906192' ,`Longitude` = '-95.734439' ,`PhotoCount` = '26' ,`PostalCode` = '77433' ,`RoomCount` = '15' ,`ListPrice` = '609648.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Marina Alto' ,`StreetNumber` = '8722' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction. (Lexington, Elevation A.) CURRENTLY BEING BUILT. Two story cul-de-sac lot. 4 bedrooms. 3.5 baths. Family room, informal dining room, and study. Spacious island kitchen open to Family room. Primary suite with large double walk-in closets. Second bedroom downstairs with private bath. Spacious game room and media room on second floor. Covered patio and 2-car garage. Marvida is a pocket of paradise for adventurous people who want it all, including innovative home designs, premium amenities, and unparalleled value. It\'s stellar location speeds you to Katy, the Energy Corridor and Downtown Houston via the Grand Parkway and Highway 290. Gold-standard Cypress-Fairbanks ISD challenges students to excel. Stop by the Westin Homes model home to learn more about Marvida!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9567' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707973' WHERE `Matrix_Unique_ID` = '211739910' --> 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','212179191','1663707973','212179191','2022-09-07T21:25:15.257','26314656','Sucel Villegas','J.D. Realty','','','29.699838','-95.772896','43','77407','4','375000.00','Active','Fairport Harbor','23706','Lane','Richmond','2','1','4','2515','Single-Family','','0.1571','37','','','','','Sellers Disclosure','','','2','Fort Bend County North/Richmond','Central Gas','1','PARKWAY LAKES SEC 3, BLOCK 1, LOT 37','Other','6845','Appraisal District','','950','0','','2','','0','','','','','Composition','33 - Lamar Consolidated','HUBENAK ELEMENTARY SCHOOL','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Parkway Lakes Sec 3','2953','2.7615','Other Water/Sewer','2006','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','212192572','1663707973','212192572','2022-09-07T20:13:12.970','37651104','Wendy Baty','Provenzano Properties','','','29.049249','-95.425162','47','77566','11','418800.00','Active','Southern Oaks','313','','Lake Jackson','2','0','4','2659','Single-Family','You won\'t have to go far to find your fishing spot! What a Beauty! This large, Lake Jackson home sits on over half an acre on Oyster Creek. Almost everything has been updated with pleasing colors & a Modern Farmhouse look. Vinyl plank flooring on the main floor in 2022, shiplap walls in living & dining rooms, fresh paint, kitchen is enormous with recent backsplash, Quartz counter tops, farmhouse sink & new appliances in 2019/2020. Stainless refrigerator stays. The kitchen has a very spacious breakfast island with an updated cooktop. Garbage disposal replaced 2022. Downstairs bath updated in 2019, including plumbing & exhaust vent in 2022. Second floor windows replaced with double insulated vinyl windows. Roof replaced 2022. Siding, insulation & Hardy Plank 2021. New AC 2019. 12 x 16 building wired for electricity, covered patio, boat storage carport, fish pond complete with fish & a small relaxing waterfall. Too many updates to list! Make this gorgeous home Yours today!','0.5482','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Lake Jackson','Central Gas','0','Southern Oaks (Lake Jackson) Block 1, Lot 7','Waterfront','23880','Appraisal District','','','0','','2','Convection Oven','0','','','Electric Cooktop','','Composition','7 - Brazosport','BRANNEN ELEMENTARY SCHOOL','BRAZOSWOOD HIGH SCHOOL','LAKE JACKSON INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment','Appraisal','2','Traditional','Southern Oaks','6817','2.33','Public Sewer,Public Water','1961','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','212192923','1663707973','212192923','2022-09-07T21:54:35.697','84969348','Jeremy Peterson','Fathom Realty','','','29.942191','-95.272119','11','77396','4','194990.00','Active','Audubon Forest','7711','Drive','Humble','2','0','4','1677','Single-Family','Come see this home with amazing potential and envy worthy yard. Double wide driveway and 2 car garage. Formal entry with formal living and dining room which offers great flexible space to meet your needs. Create another bedroom, office, or craft room. Open floor plan makes entertaining a breeze. Laundry room inside home just off the main hallway. The primary bedroom features its own bathroom making this room a proper suite. The yard is one of the most spacious lots in the neighborhood. The location couldn\'t be any better. Quiet neighborhood but walking distance to major retailers and food establishments. This house won\'t last long so come see it quick.','0.2879','1','','','Electric Dryer Connections,Washer Connections','','Estate,Mud','','Wood Burning Fireplace','1','Humble Area East','Central Electric','1','LT 28 BLK 8 AUDUBON PARK SEC 1','Subdivision Lot','12540','Appraisal District','','353','0','','2','Electric Oven','0','','','Freestanding Range','','Composition','29 - Humble','NORTH BELT ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Audubon Park Sec 01','3530','2.7373','Water District','1978','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','212214410','1663707973','212214410','2022-09-07T21:16:04.973','54339785','Krystyna Fennelly','Bay Area Elite Properties','','','29.499711','-94.935033','30','77539','0','485000.00','Active','Port','131','Street','San Leon','3','0','3','2635','Single-Family','Grab your coffee and head out on your deck to catch the morning sunrise! This stunning Mediterranean style waterfront home sits in San Leon\'s gated community of Mariner\'s Cove. You’re welcomed by a lovely spiral staircase with New carpet and Fresh paint. Entry splits two garages and features window to one garage where you can showcase your favorite vehicle. Bottom floor features game room with kitchenette, laundry and full bathroom. Second level offers kitchen with double oven, built-in cooktop and custom cabinetry overlooking the large family room with vaulted ceiling and wood-burning fireplace, and adjoining dining room. Stunning views from all rooms on rear of home and balconies from every bedroom, front balconies also offer bay views. Spend your evening fishing off your bulkhead in the backyard, nothing like the taste of a fresh catch! Community offers clubhouse, pool and pier and hosts gatherings throughout the year.','0.17','33','','','','','Estate','1','Wood Burning Fireplace','1','Bacliff/San Leon','Central Gas','1','ABST 10 PAGE 2 MARINER\'S COVE SEC 1 (98), LOT 14, ACRES 0.17','Cul-De-Sac,Water View,Waterfront','7405','Appraisal District','','2280','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','17 - Dickinson','SAN LEON ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal','2','Traditional','Mariners Cove Sec 1 98','7945','2.521','Public Sewer,Public Water','1991','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','212278272','1663707973','212278272','2022-09-07T20:04:25.637','55998825','Tina Murphy','JLA Realty','','','30.213895','-95.590530','34','77354','5','389900.00','Active','Cimarron Canyon','10088','Lane','Magnolia','2','0','3','2487','Single-Family','STOP THE CAR! You will be glad you did. Lovely 1 story KB home will not disappoint.With a Split floor plan you will enjoy your Primary retreat in the back of the home while the front of the home has separate hall with 2 bedrooms and bathroom. You will be greeted with high ceilings in foyer and wide hall leading to back of home.Easy to maintain LVP flooring in main areas.Granite countertops in kitchen with large eat at bar for 6 and 42\" black cabinets, SS appliances. You\'ll love the lighting from Fredricksburg,TX. Primary bath boast dual granite vanities, toilet closet, separate shower/tub.Primary closet has plenty of Space and custom shelving.Formal dinning is large enough to seat 12!(drumset not included) Office delights with double doors for privacy,cat 5 cable.Could be 4th bdrm with armoire.250sqft covered back porch has cat 5 cable and gas connection for grill.Close to The Woodlands shops,medical & entertainment.Fishing pond has bass, trails & community has nice pool. WELCOME HOME','0.1683','15','KB HOMES','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Magnolia/1488 East','Central Gas','1','S341103 - CIMARRON CREEK 03, BLOCK 2, LOT 10','Subdivision Lot','7330','Appraisal District','','965','0','','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Cimarron Creek 03','8144','3.1887','Public Sewer,Public Water','2016','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','212278539','1663707973','212278539','2022-09-07T21:27:12.690','70628307','Edgar Trejo','Metro Plus Realty PLLC','','','29.879461','-95.394880','20','77037','5','280000.00','Active','Deepgrove','310','Drive','Houston','2','1','4','1927','Single-Family','This Home 4 bedrooms 2 .5 bath home is located just minutes away from shopping centers and entertainment. Please schedule your appointment 1 hr. before. Property Occupied, No HOA, No Restrictions, Conveniently located near I-45, Hardy toll road, 610 loop & Beltway 8. Access provided only with advance notice. All information deemed reliable but not guaranteed - Buyer/Agent to verify. Don\'t miss out! Schedule a showing today!','0.1366','34','','','','','Sellers Disclosure','','','','Northwest Houston','Central Gas','0','LT 63 BLK 4 BELLMAR ADDN','Subdivision Lot','5949','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','JOE E MORENO ELEMENTARY SCHOOL','SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER','FONVILLE MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Right Side','Appraisal District','1','Traditional','Bellmar Add','2509','1.9716','Public Sewer,Public Water','1963','Appraisal District'); --> New record created successfully