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-12-28T09:40:27.977' ,`MLSNumber` = '8867010' ,`ListAgentFullName` = 'Kelley Austin' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755018' ,`Longitude` = '-95.503066' ,`PhotoCount` = '26' ,`PostalCode` = '77063' ,`RoomCount` = '10' ,`ListPrice` = '1379000.00' ,`Status` = 'Active' ,`StreetName` = 'River Bend' ,`StreetNumber` = '1109' ,`StreetSuffix` = 'Drive' ,`City` = 'Hunters Creek Village' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! Sprawling Ranch home in the heart of sought after Riverbend Subdivision! This 4 bedroom and 4 bath home goes on forever! Home features: huge living room/dining room with flagstone floors and cathedral ceiling overlooking backyard, kitchen with large butlers pantry and bar, reclaimed Country French wood beams, spacious library off of the flagstone entry, 2 primary bedrooms one with adjacent study and the other private suite with living room and kitchen, large backyard with lush landscape and oversized patio. Freestanding guest quarters in the back of the property with living space, bedroom, and bathroom. Perfect for elderly parents or returning college graduate! Walking distance to Second Baptist, 3 grocery stores, and several restaurants and shops! Home has never flooded per seller.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 52 BLK 2 RIVERBEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17767' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'RIVERBEND' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096519' WHERE `Matrix_Unique_ID` = '193968760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T09:51:15.123' ,`MLSNumber` = '50242439' ,`ListAgentFullName` = 'Cari Goeke' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.835956' ,`Longitude` = '-95.668647' ,`PhotoCount` = '30' ,`PostalCode` = '77414' ,`RoomCount` = '2' ,`ListPrice` = '139500.00' ,`Status` = 'Active' ,`StreetName` = 'Sir Gawain Dr' ,`StreetNumber` = '157' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Camelot Forest! This quaint and cozy home is nestled back on 3 lots in this desirable neighborhood along Caney Creek. Amazing mature pecan trees, fully perimeter fenced yard, large deck, and many more upgrades that make this home a must see! A perfect home for weekend getaways or great for investment and short-term rentals. Home comes fully furnished. Call today for your private viewing, this one will not last long!' ,`Acres` = '' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAMELOT FOREST SEC 3, BLOCK 32, LOT 10-12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '10' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Camelot Forest Sec 3' ,`TaxAmount` = '1265' ,`TaxRate` = '1.9671' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096519' WHERE `Matrix_Unique_ID` = '202972323' --> 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','204134704','1675096520','204134704','2022-12-28T10:49:08.007','28904587','Vinod Ramani','Urban Living','','','29.850348','-95.430597','16','77091','12','329990.00','Active','Burt','5810','Street','Houston','3','1','3','1771','Single-Family','Just north of 610 in Houston\'s growing neighborhood of Acres Homes lies North Moderno. These 2 story free standing homes have a 2 car private driveway. Each home features 3 bedrooms and 3 1/2 baths. The 1st floor reveals an open concept kitchen and living room. Each unit has designer finishes throughout that give the home the WOW factor you\'ve always wanted. The spacious backyard can be used year round. The master bath posses a spa like tub and separate shower perfect after a long day. Schedule a time today to see your dream home.','','9','Joes Construction','','','','No Disclosures','1','','','Northwest Houston','Central Electric,Central Gas','0','Lot 7 Block 4 North Moderno','Other','','','','','1','To Be Built/Under Construction','2','','0','','','','','Composition','1 - Aldine','ANDERSON ACADEMY','CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS','DREW ACADEMY','Appointment Required','Builder','2','Contemporary/Modern','North Moderno','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T10:22:30.067' ,`MLSNumber` = '88057831' ,`ListAgentFullName` = 'Bruce Ham' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.346880' ,`Longitude` = '-95.476942' ,`PhotoCount` = '49' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Wrangler' ,`StreetNumber` = '16511' ,`StreetSuffix` = 'Road' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '6000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning custom home that sets a new standard in luxurious living. Set on a 4 Acre Tract in the City of Rosharon with over 150 trees planted, massive garden, pond and pergola for a private backyard oasis. An impressive 4 BD, 3.5 BA 4,990 sqft home with ALL Bedrooms Down. Features include a sumptuous owner’s suite and 1,400 sqft guest house w/ 2bd, 2ba, laundry and a 672 sqft maintenance garage. Main home offers an opulent ensuite w/ his and hers closets, sinks with a huge soaking tub, 12foot ceiling, oversized family room, sunken living room, game room, media room, gourmet kitchen with huge island for the home chef onlooking the expansive custom built pool with outdoor kitchen and covered patio perfect for the avid entertainer. Skylights and large windows ensure an abundance of natural light while high-end finishes add a touch of elegance. Property has never flooded! There is no better place to call home other than in Suncreek Ranch. Schedule your private today!' ,`Acres` = '4' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNCREEK RANCH SEC 1 (A0125 A ROBINSON) BLK 2 LOT 15' ,`LotDesciption` = 'Other' ,`LotSize` = '174240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Suncreek Ranch Sec 1-2-3-4' ,`TaxAmount` = '15019' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096520' WHERE `Matrix_Unique_ID` = '205290905' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T10:35:55.207' ,`MLSNumber` = '73946450' ,`ListAgentFullName` = 'Carrie Schwager' ,`ListOfficeName` = 'The Property Source' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.122235' ,`Longitude` = '-95.683524' ,`PhotoCount` = '29' ,`PostalCode` = '77355' ,`RoomCount` = '11' ,`ListPrice` = '719900.00' ,`Status` = 'Active' ,`StreetName` = 'Lori' ,`StreetNumber` = '24710' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3105' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful!!- Custom Home boast open floor plan-3105 square ft- 3 bedroom-2.1 bath- office with closet, swimming pool, hot tub on a 47,175 Sq ft lot. Some of the homes amenities-Cooks kitchen with a viking gas range with double ovens, decor SS refrigerator, gas fireplace, two cover sitting areas at the pool, outdoor kitchen, whole house generator, three butane tanks. The fabulous workshop garage w/loft, extra room, apartment (1000 sq ft) w/handicap accessible bathroom, kitchen and many more features! Perfect location close to 99 and FM 249, shopping, restaurants and hospitals. Tomball ISD. Allenwood has NO HOA and a very low tax rate. Don\'t wait to make this your forever home!!!' ,`Acres` = '0.9518' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Butane,Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ALLENWOOD 01, LOT 45' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot' ,`LotSize` = '47175' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Allenwood 01' ,`TaxAmount` = '9513' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675096520' WHERE `Matrix_Unique_ID` = '209186187' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T10:16:53.973' ,`MLSNumber` = '43712732' ,`ListAgentFullName` = 'Norma Smalley' ,`ListOfficeName` = 'Cobb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.445672' ,`Longitude` = '-94.664009' ,`PhotoCount` = '50' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Waterview' ,`StreetNumber` = '1140' ,`StreetSuffix` = 'Lane' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly constructed home with its complete wrap around deck, is located in the beautiful, exclusive gated Waterways subdivision! Situated on a large lot with and with a great view of the canal from the front deck. Upon entering this gorgeous new home you will fall in love with the grand open floor plan. The kitchen boasts a large island with granite countertops, plenty of cabinets, storage, pantry, wine rack, stainless steel appliances and more. The adjacent dining and living room are perfect for entertaining family and friends with a great view of the canal. The large master bedroom has a walk in closet and the amazing ensuite bath with a double vanity, and a comfortablly sized shower. The secondary bedrooms do not disappoint, great size with building drawers and a counter in each room. The laundry room is equipped with a sink. So much to appreciate in this home. Please verify all room dimensions, and HOA information.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Elite Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Waterways Sec 2 2 ABST 179, Lot, Acres 0.360' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Waterways' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096520' WHERE `Matrix_Unique_ID` = '212520485' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T10:53:59.437' ,`MLSNumber` = '47563167' ,`ListAgentFullName` = 'Faron Daigle' ,`ListOfficeName` = 'Faron Daigle Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834889' ,`Longitude` = '-95.796207' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Rocky Plains' ,`StreetNumber` = '4203' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2764' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4203 Rocky Plains Ln. is a gently lived in 4 bedroom, 3.5 bath 2-story home in Katy Pointe on a corner lot. Features include: vinyl plank wood-look floors in entry, formal dining, kitchen, breakfast room & family room, ceramic tile in bath rooms & laundry room, carpet in all bedrooms, gameroom, media room and stairs. Primary B/R is down & features high ceiling and windows overlooking the backyard. The en-suite primary bath features double undermount sinks, separate shower, \"garden\" tub & large W/I closet. Island kitchen features quartz counter tops, upgraded undermount sink, reverse osmosis, tile backsplash, corner W/I pantry, 5 burner gas range w/ convection oven, 42\" cabinets, B/I microwave & opens to breakfast and family room. Computer niche w/ curved wall between kitchen and dining room. Bedrooms 2-4, game room & separate media room are up. Full Jack-n-Jill bath 3 serves bedrooms 3 & 4. Covered patio in spacious backyard. Location is just minutes to the Grand Parkway and I-10.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 KATY POINTE SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6212' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096520' WHERE `Matrix_Unique_ID` = '212833250' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T09:08:37.313' ,`MLSNumber` = '34299306' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724479' ,`Longitude` = '-95.939340' ,`PhotoCount` = '37' ,`PostalCode` = '77423' ,`RoomCount` = '11' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Franklin Brooks' ,`StreetNumber` = '32946' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to your beautiful Chester Floor Plan with 4 Bedrooms, 3 1/2 Baths, with a 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room w/direct vent Gas Log Fireplace, Kitchen, Breakfast Room, Dining Room, Study, and the Primary Bedroom downstairs. You will love the Kitchen with lots of cabinets and Quartz countertops with under the cabinet lighting, Stainless Steel appliances, and even a USB outlet. Oak handrails with rod iron spindles lead you upstairs where you will find a Game Room, a SECOND Primary, and 2 Bedrooms with a full Bath. Tile,Carpet & blinds throughout. Fenced backyard & Cover Patio. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning.' ,`Acres` = '0.1667' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 2, BLOCK 1, LOT 94' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '2082' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096521' WHERE `Matrix_Unique_ID` = '213812982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T09:03:38.550' ,`MLSNumber` = '65079276' ,`ListAgentFullName` = 'Lucy West' ,`ListOfficeName` = 'Pam\'s Home Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040039' ,`Longitude` = '-95.396655' ,`PhotoCount` = '19' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Whispering Willow' ,`StreetNumber` = '22818' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect timing! updated 1 story in Spring, near major commuting roads, The Woodlands amenities, Downtown Houston is just a short drive. This home is in a great location! Has never flooded! NEW marble around tub and vanities in both bathrooms. Den can be used as a extra bedroom or study. NO CARPET. Updated kitchen and primary bathroom! Please verify room measurements. Home has tenants.' ,`Acres` = '0.1956' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 30 TIMBER LANE SEC 5' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane' ,`TaxAmount` = '4530' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096521' WHERE `Matrix_Unique_ID` = '214253839' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T10:48:40.177' ,`MLSNumber` = '29448074' ,`ListAgentFullName` = 'Priscilla Williams' ,`ListOfficeName` = 'Texcom Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096550' ,`Longitude` = '-95.291207' ,`PhotoCount` = '6' ,`PostalCode` = '77365' ,`RoomCount` = '6' ,`ListPrice` = '153982.00' ,`Status` = 'Active' ,`StreetName` = 'Wisp Willow' ,`StreetNumber` = '18436' ,`StreetSuffix` = 'Way' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Bedroom 2 Bathroom. Enter your home from the Large covered front porch to the open living dining and Island kitchen. The living room has built-ins, and window coverings stay—large primary bedroom with a primary bath, Garden tub, double vanity, and separate shower. The home is a split floor plan with two bedrooms on the other side of the living room. Big backyard with storage shed. Won\'t last long super clean!!' ,`Acres` = '0.4019' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S906301 - SUMMER HILLS 01, LOT 468, SERIAL SCH01015354, TITL' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '17505' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Summer Hills 01' ,`TaxAmount` = '1825' ,`TaxRate` = '2.1' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096521' WHERE `Matrix_Unique_ID` = '214537393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T09:30:10.157' ,`MLSNumber` = '13204963' ,`ListAgentFullName` = 'Shanni Lo' ,`ListOfficeName` = 'Shanni Lo' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740856' ,`Longitude` = '-95.370282' ,`PhotoCount` = '39' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Crawford' ,`StreetNumber` = '2814' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a free standing home with NO HOA, private driveway, and an OVERSIZED backyard in Midtown? This is the home for you!3 story, 3 bedrooms, 3.5 baths, and a balcony is the prefect home for you, and family/friends. Located in the heart of the city, this home offers walls of windows with a spectacular kitchen including a large island, pantry, and tons of cabinet/counter space. Hardwood flooring in living space and 3rd floor bedroom suits with high ceiling are some features of the home. Primary suite offers cathedral ceiling, spa-like bath tub with separate shower, and a enormous walk in closet. First floor suite can be used as a home office, guest room, or home gym. Backyard inside the loop is hard to find, but you will find an enormous yard here. If you like to entertain, you guests can park in the extra wide driveway without any worries. Easy commute to the MedCenter, Downtown, Galleria, and walking distance to restaurants, bars, and cafes, this is city living to the finest.' ,`Acres` = '0.0574' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 1 CRAWFORD MANOR' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GREGORY-LINCOLN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Mediterranean,Split Level' ,`Subdivision` = 'Crawford Manor' ,`TaxAmount` = '9845' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096521' WHERE `Matrix_Unique_ID` = '214555921' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T10:58:44.380' ,`MLSNumber` = '10266224' ,`ListAgentFullName` = 'Raphael Ogbongbemiga' ,`ListOfficeName` = 'Discovered Homes Inv. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845912' ,`Longitude` = '-95.705451' ,`PhotoCount` = '50' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadwind' ,`StreetNumber` = '19210' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This single-family home is located at 19210 Broadwind Ln, Katy, TX. 19210 Broadwind Ln is in Katy, TX and in ZIP code 77449. This property has 3 bedrooms, 2.5 bathrooms and approximately 2,448 sqft of floor space. This property has a lot size of 4965 sqft and was built in 2001.' ,`Acres` = '0.1136' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 WINDSTONE COLONY SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SHERIDAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Windstone Colony Sec 01' ,`TaxAmount` = '5621' ,`TaxRate` = '2.781' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096522' WHERE `Matrix_Unique_ID` = '214766041' --> 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','215839074','1675096522','215839074','2022-12-28T09:24:09.527','4645264','Feras Rachid','Opendoor Brokerage, LLC','','','29.931630','-95.625149','24','77065','5','313000.00','Active','Ryanwood','13519','Drive','Houston','2','1','5','2577','Single-Family','Welcome home! This home has updated flooring in some rooms and fresh interior paint. Discover a bright and open interior with plenty of natural light and a neutral color palette, complimented by a fireplace. Meal prep is a breeze in the kitchen, complete with a spacious center island. You won’t want to leave the serene primary suite, the perfect space to relax. Other bedrooms provide nice flexible living space. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Hurry, this won’t last long! This home has been virtually staged to illustrate its potential.','0.1608','10','','','','','Sellers Disclosure','1','','1','1960/Cypress','Central Gas','1','LT 18 BLK 4 WHITE OAK LANDING SEC 4','Subdivision Lot','7004','Appraisal District','','565','0','','2','','0','','','','','Other','13 - Cypress-Fairbanks','MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','White Oak Landing Sec 04','5416','2.381','Other Water/Sewer','1991','Seller'); --> 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','215845303','1675096522','215845303','2022-12-28T10:21:58.600','85346853','Helen Van Slyke','Van Slyke Real Estate, LLC','','','29.578435','-95.798072','18','77471','8','135000.00','Active','Faustino Garcia','911','Road','Rosenberg','2','0','4','1803','Single-Family','Country living close to the city on 1 acre of land! Large den, dining room with built-in bookcase, spacious kitchen , large primary bedroom, 3 additional bedroom and 2 bathrooms. This is a nice lot for your chidren to play and enjoy the outdoors! Home is close to new schools on FM 723 and just a short drive over the bridge to Rosenberg. Home has a couple of storage sheds and a carport. Make your appointment today!','1','30','','','','','No Disclosures','','','','Fort Bend County North/Richmond','Central Electric','0','0035 S ISSACS, ACRES 1.00','Cleared','43560','Appraisal District','','','0','','0','','0','','','','','Composition','33 - Lamar Consolidated','JACKSON ELEMENTARY SCHOOL (LAMAR)','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','S Issacs','2430','1.6948','Septic Tank,Well','1975','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','215884372','1675096522','215884372','2022-12-28T10:26:07.493','40455849','Luis Garza','The Horizon Team','','','29.727638','-95.316692','34','77023','8','435000.00','Active','Jocelyn','1114','Street','Houston','2','0','3','1956','Single-Family','Location! Location! This home is located in one of the fastest growing areas of Houston, East End Revitalized. This charming home has gone under recent renovations. Stunningly custom cabinets w/ soft close and an abundance of counter space and storage, counters & back splash quartz all matching, new tile flooring throughout, new windows, roof was replaced 4 yrs ago. Pluming was replaced copper tubing. All bedrooms are very spacious, master has a custom walk in closet, another bedroom has a side room that can be use as study or nursery rm. Just three miles from Downtown Houston, less than a mile to I-45, with quick and easy access to every major freeway, your new home is surrounded by popular restaurants, parks, bars, music venues, and a rapidly growing arts community.','0.1446','4','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','East End Revitalized','Central Gas','0','LT 7 BLK 1 LAWN TERRACE','Subdivision Lot','6300','Appraisal District','','','0','','0','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','CARRILLO ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','NAVARRO MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Traditional','Lawn Terrace','4506','2.3307','Public Sewer,Public Water','1948','Appraisal District'); --> New record created successfully