Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T00:58:15.057' ,`MLSNumber` = '36091302' ,`ListAgentFullName` = 'Katie Gaffigan' ,`ListOfficeName` = 'Segue Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080187' ,`Longitude` = '-95.712629' ,`PhotoCount` = '30' ,`PostalCode` = '77377' ,`RoomCount` = '3' ,`ListPrice` = '819900.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2920' ,`StreetNumber` = '18702' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom built home with details throughout. Crown molding, coffered ceilings, custom cabinetry, bright sunroom, water softner, finised garage, mosquito misting system, this home has it all. The property is setup for wheelchair access including, wide doorways, ramps, and a wheelchair friendly shower. Excellent location with great visibility & 111 feet of frontage on FM 2920 in high density residential & commercial populated area in rapidly expanding Tomball, TX. Property includes a 3,462 SF custom home/office with gourmet kitchen, high-end finishes & immense attention to detail. Tract are less than 2 miles from the Grand Parkway (99) & only 5 miles from SH-249. Adjoining 1 & 1.02 acres with 1,539 SF & 1,036 SF offices also available for sale with +/- 340 combined feet of frontage along FM 2920 for all 3 tracts' ,`Acres` = '1' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 23D-1 ABST 7 S BROWN' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'unrestricted' ,`TaxAmount` = '10888' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641447' WHERE `Matrix_Unique_ID` = '203578573'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T00:13:23.527' ,`MLSNumber` = '33362634' ,`ListAgentFullName` = 'Elise May' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.859860' ,`Longitude` = '-95.317596' ,`PhotoCount` = '6' ,`PostalCode` = '77016' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Piedmont' ,`StreetNumber` = '5203' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing 3 bed 2.5 bath, Single family home (DUPLEX!) NOW ACCEPTING OFFERS! \r\n****The price is for Unit A ONLY****\r\nGreat starter home. \r\nCompletion date 12/15/2022 \r\nThe buyer will be able to pick their interior design from a list of options provided by E-MAY BUILDING COMPANY. \r\nThis is new construction and will not last long! This home comes complete with a beautiful cedar fence and electric gate opener. Upon arriving you will see the 1 car garage and front balcony. The small front porch will lead you inside to much desired open floor plan. \r\n-Vinyl wood flooring throughout.\r\n-Brand new cedar plank fence.\r\n-Kitchen and bathroom boast tile floors, and bedrooms carpet.\r\n-Granite countertops.\r\n-Tall ceilings and exquisite light fixtures.\r\n-New stainless-steel appliances.\r\n-Manageable backyard.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'E-May Building Co' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 63 BLK 4 BENMAR PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '3550' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Benmar Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641447' WHERE `Matrix_Unique_ID` = '210909457'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T23:47:29.233' ,`MLSNumber` = '38734234' ,`ListAgentFullName` = 'Roger Elam' ,`ListOfficeName` = 'Elam Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.036678' ,`Longitude` = '-95.425271' ,`PhotoCount` = '10' ,`PostalCode` = '77566' ,`RoomCount` = '6' ,`ListPrice` = '184900.00' ,`Status` = 'Active' ,`StreetName` = 'Carnation' ,`StreetNumber` = '321' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1222' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect starter home, or final down-sizing destination at the end of a quiet cul-de-sac. Rental potential. Walking distance to Beutel Elementary and minutes from B-Wood High School, LJ Intermediate and Brazosport College.  Quick commute to CHI St.Luke\'s Hospital and local industry.  3 bedrooms with a bath and a half, ample closet and storage space, and carefree vinyl plank flooring throughout give this cozy house all that\'s needed to make it a home. A large fenced backyard, mature trees and a neighbor to only one side add up to make for a charming cul-de-sac retreat.' ,`Acres` = '0.1978' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PARKWOOD TERRACE (LAKE JACKSON) BLK 11 LOT 13' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood Terrace Lake Jackson' ,`TaxAmount` = '4089' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641447' WHERE `Matrix_Unique_ID` = '211382152'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T00:14:09.870' ,`MLSNumber` = '78012928' ,`ListAgentFullName` = 'Elise May' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.859860' ,`Longitude` = '-95.317596' ,`PhotoCount` = '6' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Piedmont' ,`StreetNumber` = '5203' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing 3 bed 2.5 bath, Single family home (DUPLEX!) NOW ACCEPTING OFFERS! \r\n****The price is for Unit B ONLY****\r\nGreat starter home. \r\nCompletion date 12/15/2022 \r\nThe buyer will be able to pick their interior design from a list of options provided by E-MAY BUILDING COMPANY. \r\nThis is new construction and will not last long! This home comes complete with a beautiful cedar fence and electric gate opener. Upon arriving you will see the 1 car garage and front balcony. The small front porch will lead you inside to much desired open floor plan. \r\n-Vinyl wood flooring throughout.\r\n-Brand new cedar plank fence.\r\n-Kitchen and bathroom boast tile floors, and bedrooms carpet.\r\n-Granite countertops.\r\n-Tall ceilings and exquisite light fixtures.\r\n-New stainless-steel appliances.\r\n-Manageable backyard.' ,`Acres` = '0.017' ,`Area` = '2' ,`BuilderName` = 'E-May Building Co' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 63 BLK 4 BENMAR PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '3550' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Benmark Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641447' WHERE `Matrix_Unique_ID` = '212733038'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T23:10:18.250' ,`MLSNumber` = '45734509' ,`ListAgentFullName` = 'Darius Franklin' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.046633' ,`Longitude` = '-95.423248' ,`PhotoCount` = '15' ,`PostalCode` = '77373' ,`RoomCount` = '10' ,`ListPrice` = '279779.00' ,`Status` = 'Active' ,`StreetName` = 'Dickson Park' ,`StreetNumber` = '19302' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single story 4-bedroom floor plan in the conveniently located gated community of Spring Park Village. High ceilings, wide hallways and larger rooms as well as the flooring upgrades will catch your eye on this one. Brand new A/C condenser and evap coil (w/ 10-year warranty upon registration to the buyer), brand-new stainless-steel range and OTR microwave, brand new carpet in the 2 bedrooms that have it. Equipped with fully serviced sprinkler system, garage opener with walk in access keypad and brand-new smoke detectors. Take a look at the pictures... Small furniture & décor also for sale but separately, not included in the list price.' ,`Acres` = '0.1611' ,`Area` = '12' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 3 SPRING PARK VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GINGER MCNABB ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Park Village' ,`TaxAmount` = '6070' ,`TaxRate` = '2.4967' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641448' WHERE `Matrix_Unique_ID` = '214030489'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T23:55:28.373' ,`MLSNumber` = '88352499' ,`ListAgentFullName` = 'Vanessa Claudio' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741061' ,`Longitude` = '-95.562942' ,`PhotoCount` = '26' ,`PostalCode` = '77042' ,`RoomCount` = '3' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Willow' ,`StreetNumber` = '2307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRIME LOCATION in the heart of ENERGY CORRIDOR! Perfectly situated in the sought-after Walnut Bend. This spacious home features a beautifully restored and renovated interior with impressive refinements that combine luxury and casual living. Gorgeous kitchen is appointed with stainless steel appliances. The kitchen offers quartz countertops and plenty of cabinet and counter space. Home offers 3-4 bedrooms, office space, formal dining, breakfast room, living room and almost half an acre. Bonus room can be 4th bedroom or an extra-large space to use at your desire. NEW roof, NEW a/c, NEW underground plumbing, NEW energy efficient windows, NEW quartz countertops, NEW luxury laminate flooring, NEW carpet, NEW interior and exterior paint. The list goes on!' ,`Acres` = '0.432' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 & TR 3 BLK 5 WALNUT BEND SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '958' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Walnut Bend Sec 02' ,`TaxAmount` = '8099' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641448' WHERE `Matrix_Unique_ID` = '214269862'  --> Updated record success<br />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','215019839','1669641448','215019839','2022-11-22T23:27:52.450','55222792','Andrea Huerta','Keller Williams HoustonCentral','','','29.704322','-95.168254','22','77503','3','200000.00','Active','Bennington','3111','Drive','Pasadena','1','0','3','1006','Single-Family','Welcome home to Bennington Drive! This super adorable 3 bedroom, 1 bath home is packed with upgrades. Brand new HVAC system, upgraded kitchen to include granite counter tops, brand new kitchen appliances, updated plumbing with new fixtures. New electrical breaker box, all new recess lighting and interior fixtures. Fresh paint, and all new flooring. Large backyard. Never flooded. Low taxes, no HOA!','0.168','6','','','','','Sellers Disclosure','','','','Pasadena','Central Electric,Central Gas','0','LT 85 BERKSHIRE VILLAGE SEC 1','Subdivision Lot','7316','Appraisal District','','','0','','0','','0','','','','','Composition','16 - Deer Park','DEEPWATER ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','DEEPWATER JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Berkshire Village','2843','2.6198','Public Sewer,Public Water','1952','Appraisal District');  --> New record created successfully<br />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','215044795','1669641448','215044795','2022-11-23T00:07:05.500','85443393','Marlene Foad','RE/MAX Universal','','','29.919180','-95.700016','40','77433','9','700000.00','Active','San Solomon Springs','19206','Court','Cypress','3','1','3','3347','Single-Family','Gorgeous 1 1/2 story located in the gated custom home section of the 55+community. Greenbelt behind this home provides privacy. The floor plan smoothly transitions from one area to the next with entertaining in mind. Welcoming Iron Front Door leads into a high ceiling foyer. Wood-look easy maintenance tile floor continues throughout. Soaring vaulted ceilings with wooden beams grace the spacious family room. Formal Dining Room. Study has built in shelves and desk. Island kitchen features stainless steel appliances, gas stovetop, double convection ovens, extensive granite counters.  Romantic Primary Bedroom easily accommodates a king sized suite. Spa-like Primary Bath features his and hers vanities, a large soaking tub and a oversized separate shower with shower seat. Large primary closet has a built in island for storage. Secondary bedrooms have ensuite baths. Game room upstairs. Water softener, Backyard retreat includes Built-in Outdoor Kitchen, mosquito system, sprinkler system','0.2522','25','Jaeger Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress South','Central Gas','1','LT 2 BLK 2 TOWNE LAKE SEC 13','Cul-De-Sac,Greenbelt','10985','Appraisal District','','240','0','','3','Convection Oven,Double Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','RENNELL ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Towne Lake Sec 05','16468','3.091','Water District','2013','Appraisal District');  --> New record created successfully<br />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','215045373','1669641448','215045373','2022-11-22T23:54:16.680','43848432','Michael Nassif','NRE Realty','','','29.569995','-95.136802','0','77062','9','330000.00','Active','Lanswick','15414','Drive','Houston','2','1','4','2304','Single-Family','Come to see this beautiful fully remodeled home with a new roof, new paint inside/outside, Granite countertops and backsplash, tile throughout the first floor, including bathrooms, new carpet in all the bedrooms, bathrooms have been updated, new faucets, foundation repaired, new appliances, new toilets etc.  This lovely home is on a quiet Cul-de-sac with quick access to the freeway, the Baybrook mall and super center stores!','0.1814','7','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Clear Lake Area','Central Gas','1','LT 72 BLK 4 MEADOWGREEN SEC 1','Cul-De-Sac,Subdivision Lot','7900','Appraisal District','','300','0','','2','Electric Oven','0','','','Electric Range','','Composition','9 - Clear Creek','CLEAR LAKE CITY ELEMENTARY SCHOOL','CLEAR LAKE HIGH SCHOOL','CLEARLAKE INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Meadowgreen Sec 01','6670','2.5769','Public Sewer,Public Water,Water District','1977','Appraisal District');  --> New record created successfully<br />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','215046480','1669641448','215046480','2022-11-22T23:14:43.130','30503065','Fernando Chavira','Sprout Realty','','','29.653755','-95.210378','25','77587','3','315000.00','Active','Avenue','1515','','South Houston','2','0','3','1646','Single-Family','','0.1722','6','','','','','Sellers Disclosure','','','1','South Houston','Central Electric','0','LT 4D SOUTH HOUSTON R/P','Other','7500','Appraisal District','','','0','','0','','0','','','','','Composition','41 - Pasadena','PEARL HALL ELEMENTARY SCHOOL','SOUTH HOUSTON HIGH SCHOOL','MILLER INTERMEDIATE SCHOOL','Lockbox Front','Appraisal District','1','Other Style','South Houston','7775','2.8255','Public Sewer,Public Water','2008','Appraisal District');  --> New record created successfully<br />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','215049237','1669641448','215049237','2022-11-23T00:49:13.830','12770785','Lawrence Lo','Lawson Tx Realty','','','29.584970','-95.690434','16','77479','11','429000.00','Active','Mason','4718','Court','Sugar Land','3','1','4','3013','Single-Family','Beautiful 4 bedroom 3 1/2 bath plantation home with master bedroom down, 3 bed and game room upstairs. New carpet & new interior paint. Granite counter tops in kitchen, Hardwood floorings, Large backyard and sprinkler system, All around brick, New Water Heater. Zoned to excellent Fort Bend ISD and located in quiet cul-de-sac close to community park/swimming pool. Community provides eight Tennis courts, clubhouse/gym and sports building.\r\nNice and clean, ready for move in.','','29','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Sugar Land West','Central Gas','1','NEW TERRITORY PARCEL SF-36A, BLOCK 2, LOT 25','Cul-De-Sac,Subdivision Lot','7924','Appraisal District','','1050','0','','2','Electric Oven','0','','','Gas Range','','Composition','19 - Fort Bend','BRAZOS BEND ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','SARTARTIA MIDDLE SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','New Territory Prcl Sf-36a','7110','2.43','Water District','2000','Appraisal District');  --> New record created successfully<br />