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-08T20:55:17.767' ,`MLSNumber` = '46328782' ,`ListAgentFullName` = 'Hester Bell' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.077028' ,`Longitude` = '-94.155016' ,`PhotoCount` = '33' ,`PostalCode` = '77707' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Caldwood' ,`StreetNumber` = '195' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4063' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sprawling estate in one of Beaumont\'s most beautiful neighborhoods! Surrounded by the warmth of the wood beams and trim detailsthroughout, this home is both an entertainer\'s dream, yet perfect for quiet evenings at home with your family. The heart of the of home isthe kitchen that flows into the game room/den. Sunroom overlooks the lush backyard complete with mature trees, fish pond and rockwater fall. This is a rare gem and wonderful opportunity.' ,`Acres` = '0.75' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 42 Tr 2 Lot 43 All Lot 44 Tr 1 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CALDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'ODOM MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Caldwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708349' WHERE `Matrix_Unique_ID` = '199494088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T21:17:43.783' ,`MLSNumber` = '3561328' ,`ListAgentFullName` = 'Alex Harper' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.714023' ,`Longitude` = '-95.063035' ,`PhotoCount` = '33' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '245900.00' ,`Status` = 'Active' ,`StreetName` = 'Village Cove' ,`StreetNumber` = '231' ,`StreetSuffix` = 'Loop' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lake living at its finest! What a beautiful community! This totally renovated 3/2 nearly 1700 SQFT contemporary home sits on nearly 1/4 acre. Home offers an open concept kitchen and living room. Nice bedrooms and indoor laundry area. You can also sip coffee and enjoy the spectacular surroundings in this precious home or in this precious home or under the floor level concrete patio area equipped with a half bath. Contemporary finishes in the kitchen feature a granite island new cabinetry, a stainless sink, and stainless steel appliances. Just minutes away-private subdivision boat launch; perfect for a weekend retreat or full time living home. Bring the family and friends to enjoy some fun on the second Largest lake in Texas in the Midst of the Big Thicket; LAKE LIVINGSTON! A hidden oasis of fishing, camping, boating, sailing and jet skiing. In town enjoy many restaurants, shopping, and visit Naskila Casino. Come check out this precious home today!' ,`Acres` = '0.1756' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE SECTION 12 LOT 52' ,`LotDesciption` = 'Other' ,`LotSize` = '7650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lake Livingston Village' ,`TaxAmount` = '2602' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708349' WHERE `Matrix_Unique_ID` = '205562191' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T21:38:29.803' ,`MLSNumber` = '70626484' ,`ListAgentFullName` = 'Jenny Ceballos' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701212' ,`Longitude` = '-95.383375' ,`PhotoCount` = '7' ,`PostalCode` = '77021' ,`RoomCount` = '6' ,`ListPrice` = '338000.00' ,`Status` = 'Active' ,`StreetName` = 'Burgess' ,`StreetNumber` = '6919' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property being sold AS-IS. Location! Come buy your next fixer-upper or demolish existing home and build your new home! There are many new constructed homes in the subdivision. Home has not flooded. Central City subdivision is prime real estate, located minutes from downtown, the medical center, mid-town, Reliant Stadium, the museum district, Toyota Center, and the GRB Convention Center. Property is in walking distance to the Veterans Hospital and other major medical facilities. Easy access to major freeways. Call for additional details and make an offer today!' ,`Acres` = '0.2059' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Medical Center Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 3 CENTRAL CITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Central City' ,`TaxAmount` = '5994' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708349' WHERE `Matrix_Unique_ID` = '205812984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T21:37:00.590' ,`MLSNumber` = '40795473' ,`ListAgentFullName` = 'Danielle Rex' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.282501' ,`Longitude` = '-94.830931' ,`PhotoCount` = '30' ,`PostalCode` = '77327' ,`RoomCount` = '2' ,`ListPrice` = '110000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Fern' ,`StreetNumber` = '184' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new charming 2 bedroom, 2 bathroom home nestled on 3 lots. This split floor plan features a bed and bath on each side with your living room and kitchen in the middle. This home did not flood during Harvey!\r\nCarport included. Numerous amenities such as playgrounds, pools/splash pads, fishing lakes, white sandy beaches on the Trinity River and more! Schedule your showing today!' ,`Acres` = '0.34' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CYPRESS LAKES, BLOCK 7 UNIT 11, LOT 233, 234, 235' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Lakes' ,`TaxAmount` = '54' ,`TaxRate` = '1.5309' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663708349' WHERE `Matrix_Unique_ID` = '206425507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T20:49:17.160' ,`MLSNumber` = '59627580' ,`ListAgentFullName` = 'Elizabeth Stallings' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666592' ,`Longitude` = '-94.999655' ,`PhotoCount` = '24' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayridge' ,`StreetNumber` = '823' ,`StreetSuffix` = 'Road' ,`City` = 'Morgan\'s Point' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2142' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity to own Galveston Bayfront property in Morgan\'s Point. The house is on about half an acre with 47\' of water frontage. Watch the sun rise from the south east facing backyard. Morgan\'s Point, located 30 miles east of Houston, is rich in Texas history. The city was established in 1822 and is the \"Home of the Yellow Rose of Texas\" and has many historic homes and sites. Some of the amenities nearby include a 3 mile paved trail for hiking and biking, parks with a playground and picnic areas, Colonel James Morgan New Washington Prairie which is 52 acres of land including a 5 acre pond with a pavilion overlooking the water. Nearby is the La Porte beach area and fishing pier. Investor special, the house needs work. Lots of potential with some TLC for this amazing place to call home.' ,`Acres` = '0.5109' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Probate,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'E 1/2 OF LT 10 & TR 10A BAY RIDGE PARK' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '22255' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Ridge Park' ,`TaxAmount` = '10879' ,`TaxRate` = '2.9614' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708349' WHERE `Matrix_Unique_ID` = '206937234' --> 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','207161227','1663708349','207161227','2022-09-08T20:22:06.747','49342378','Scarlett Brekel','RE/MAX One','','','29.974145','-94.007997','36','77627','3','377000.00','Active','23rd Street','1410','','Nederland','2','1','3','2556','Single-Family','Don\'t miss out on this beautiful custom home located in Christina Court, a sought after neighborhood in the heart of Bulldog territory. First let\'s escape to the tropical oasis in the backyard. Salt water pool, hot tub, cascading waterfall, pergola, plenty of palm trees, gas generator, gas fire pit & also a wood burning fire pit. Secondly, check out a chef\'s dream kitchen. Copper farmhouse sink w/apron front & embellished details, antiqued cabinets, granite counter tops, five burner gas cooktop, double ovens, work island, wood ceiling with recessed lights which leads to a breakfast area on one side & a formal dining room on the other. Next, the master suite is unique with a exceptional ceiling, french doors that open to a private sitting area that could be used as an office. The bathroom features a jacuzzi tub, double sink vanity, tile rain shower, & large walk in closet. Upstairs has two bedrooms, bathroom, storage, & walk in attic. It\'s a must see...so much more to explore!','','51','','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','Gas Connections','1','','Central Gas','0','Christina Court Sec 4 LT 8 BLK 8','Subdivision Lot','','','','','0','','2','Convection Oven,Double Oven','1','In Ground','','Gas Cooktop','','Composition','152 - Nederland','HELENA PARK ELEMENTARY SCHOOL','NEDERLAND HIGH SCHOOL','WILSON MIDDLE SCHOOL (NEDERLAND)','Vacant/Unoccupied','Appraisal District','2','Other Style','Christina Court','','','Public Sewer,Public Water','1988','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T20:14:41.807' ,`MLSNumber` = '10178084' ,`ListAgentFullName` = 'Evelyn Wuneburger' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.307620' ,`Longitude` = '-95.503399' ,`PhotoCount` = '48' ,`PostalCode` = '77304' ,`RoomCount` = '9' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Mist' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming subdivision home located in the heart of Conroe, a quiet neighborhood in the coveted area of FM 2854 & Loop 336. This is a brick 3/4 Bedroom, 2 bath home; there is a Study/Office with a closet that could be a 4th bedroom depending on your needs. With Matching black appliances, gas Range, Pantry, and island for extra space, this kitchen is well-equipped, and ready for it\'s own people. The Utility room is inside the home, coming in from the garage. Backyard is fenced, with a Pergola, and covered patio area. Looks like a nice place for a warm cup of coffee or an evening beverage. The neighborhood has a walking trail, and is central to all of the great shopping, dining, and fun that Conroe has to offer. With easy access to I-45, and the Loop, commuting in any direction is convenient. Come tour this home today, it may be gone tomorrow!!' ,`Acres` = '0.1263' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S799100 - PINEWOOD FOREST, BLOCK 1, LOT 38, ACRES 0.126' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pinewood Forest' ,`TaxAmount` = '4351' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708349' WHERE `Matrix_Unique_ID` = '208311158' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T20:30:31.510' ,`MLSNumber` = '56330622' ,`ListAgentFullName` = 'Hai Le' ,`ListOfficeName` = 'Houston Realty' ,`SellingAgentFullName` = 'Glenda Jackson' ,`SellingOfficeName` = 'Jackson Enterprises' ,`Latitude` = '29.934803' ,`Longitude` = '-95.481894' ,`PhotoCount` = '17' ,`PostalCode` = '77086' ,`RoomCount` = '6' ,`ListPrice` = '219000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Northleaf' ,`StreetNumber` = '6506' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large house, updated, in quiet cul-de-sac with no back neighbor. Roof was replaced 2016. New Water heater 2018. Updated. Ready to move in. New 2022 AC Evaporator Coil and furnace unit. 3 bedrooms with split plan. Large living room. Dining room. Breakfast area. Huge Master bedroom with sitting area. Rooms dimensions is approximated, please independently confirm.' ,`Acres` = '0.1667' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 44 NORTHWEST PARK SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwest Park Sec 04' ,`TaxAmount` = '3860' ,`TaxRate` = '2.4283' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708349' WHERE `Matrix_Unique_ID` = '208661703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T20:45:15.677' ,`MLSNumber` = '23291382' ,`ListAgentFullName` = 'Erika Hernandez' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801097' ,`Longitude` = '-95.470087' ,`PhotoCount` = '21' ,`PostalCode` = '77055' ,`RoomCount` = '11' ,`ListPrice` = '404999.00' ,`Status` = 'Active' ,`StreetName` = 'Raton' ,`StreetNumber` = '6907' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1964' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Ready to live in the quickly changing area of SPRING BRANCH for an affordable price? This area offers great schools, low TAX RATE, accessibility to major highways & plenty of shopping & entertainment. This home features 2 PRIMARY bedrooms both very spacious & with Full Bath attached. Recent updates : NEW ROOF, all new energy efficient windows & new blinds, new tile in common areas & bathrooms & new carpet in bedrooms, New restroom vanities, New light fixtures and bonus recessed can lights, ALL NEW paint on exterior & interior along with new exterior doors, new 6 panel interior doors, and lastly new ceiling fans. If you are in need of 2 huge primary bedrooms with attached full baths and additional 2 extra bedrooms & extra rooms please call for appointment. Need a video tour? See link attached. Home is ready for move in.' ,`Acres` = '0.1653' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 3 PINE TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Terrace' ,`TaxAmount` = '6309' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708350' WHERE `Matrix_Unique_ID` = '208714819' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T20:02:46.743' ,`MLSNumber` = '89550915' ,`ListAgentFullName` = 'Sonia Posadas' ,`ListOfficeName` = 'Metro Plus Realty PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531292' ,`Longitude` = '-95.317559' ,`PhotoCount` = '44' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'Ravencrest' ,`StreetNumber` = '4034' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3153' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing house in Ravenwood Estates community on a 37,026 Sq Ft lot.\r\nOversized 3 car garage with TECHSHIELD (radiant barrier roof-decking). Frech doors study, upstairs game room, granite counter tops, new carpet, huge backyard, spacious primary bedroom with coffered ceiling, jetted tub and shower. New dishwasher and AC unit downstairs.' ,`Acres` = '0.85' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RAVENWOOD ESTATES SEC 1 (A0546 HT&BRR)(PEARLAND) BLK 2 LOT 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '37026' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '484' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MASSEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ravenwood Estates Sec 1' ,`TaxAmount` = '10493' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663708350' WHERE `Matrix_Unique_ID` = '208914035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T21:34:28.943' ,`MLSNumber` = '56171960' ,`ListAgentFullName` = 'Kimberly Bennett' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.276785' ,`Longitude` = '-94.836163' ,`PhotoCount` = '20' ,`PostalCode` = '77551' ,`RoomCount` = '6' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Victory' ,`StreetNumber` = '2025' ,`StreetSuffix` = 'Avenue' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 2 Bedroom, 2 full Bathrooms and 1 extra room (office, craft rm) House on Galveston Island 2 blocks from Offatts Bayou, 10 minutes from Moody Gardens. Great front porch with an attached garage. Perfect as an investment or your vacation home! Huge Kitchen w/granite counter tops for entertaining families and friends.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL&JONES SUR E 84FT OF LOT (4-1)' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas 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,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Hollywood Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708350' WHERE `Matrix_Unique_ID` = '209375996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T20:20:53.817' ,`MLSNumber` = '10953169' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884639' ,`Longitude` = '-95.789041' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '348990.00' ,`Status` = 'Active' ,`StreetName` = 'Sumac Bluff' ,`StreetNumber` = '23910' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Now selling Chesmar\'s Brand New Town Square Collection in Elyson! CORNER & CULDESAC HOMESITE! The beautiful brand new Springfield Plan features a Two Story, 2 Bedroom with a flex room/3rd bedroom, 2 Bath Home a 2 Car Garage. This home boasts a covered front porch, a covered back porch & a covered second story balcony. The open Kitchen/Family room has plenty of natural light from it\'s abundant windows & also includes a separate dining space. Large Primary Bedroom with Texas sized shower & walk in closet. Located steps from the Upcoming Elyson Commons!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 ELYSON SEC 32' ,`LotDesciption` = 'Corner,Cul-De-Sac,Greenbelt,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Convection 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,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708350' WHERE `Matrix_Unique_ID` = '211664756' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T20:20:17.733' ,`MLSNumber` = '79458809' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868456' ,`Longitude` = '-95.835384' ,`PhotoCount` = '23' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '330990.00' ,`Status` = 'Active' ,`StreetName` = 'Oriole Valley' ,`StreetNumber` = '23915' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1474' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Now selling Chesmar\'s Brand New Town Square Collection in Elyson! The beautiful brand new Storybrooke Plan features a Two Story, 2 Bedroom with a flex space that can be used as a third bedroom, 2 Bath Home a 2 Car Garage. This home boasts a covered front porch, a covered back porch & a covered second story balcony. The open Kitchen/Family room has plenty of natural light from it\'s abundant windows & also includes a separate dining space. Large Primary Bedroom with Texas sized shower & walk in closet. Located steps from the Upcoming Elyson Commons!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 2 ELYSON SEC 32' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708350' WHERE `Matrix_Unique_ID` = '211664868' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T20:29:07.783' ,`MLSNumber` = '13601507' ,`ListAgentFullName` = 'Hai Le' ,`ListOfficeName` = 'Houston Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.941920' ,`Longitude` = '-95.360072' ,`PhotoCount` = '31' ,`PostalCode` = '77032' ,`RoomCount` = '4' ,`ListPrice` = '189500.00' ,`Status` = 'Active' ,`StreetName` = 'Whittier' ,`StreetNumber` = '2106' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Buy this house on one of the largest lot in neighbor. Implement your own design and update as House needs some updates. Price is reflecting some outstanding updates.\r\nThere bedrooms are all on second floor. Large family room on first floor. This house was never flooded through out all big hurricanes as its lots is one of the highest in neighborhood.' ,`Acres` = '0.1037' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 110 BLK 11 GREENBRIAR COLONY T/H' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '4515' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '227' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CALVERT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Greenbriar Colony T/H' ,`TaxAmount` = '2972' ,`TaxRate` = '2.5707' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708350' WHERE `Matrix_Unique_ID` = '211709363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T21:14:51.390' ,`MLSNumber` = '79937918' ,`ListAgentFullName` = 'Amy Crow' ,`ListOfficeName` = 'Corison Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.754503' ,`Longitude` = '-95.030797' ,`PhotoCount` = '6' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Westridge Park' ,`StreetNumber` = 'TBD' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'KWS Builder- NEW CONSTRUCTION \"The Langmore\" is located in Four Corners Estates Phase 4, a highly sought-after location. The Langmore features a spacious living area with high ceilings and an open concept for family living and entertaining. One story-4 bedroom and 2.5 bath. The primary bedroom comes complete with a walk-in closet and an ensuite bath. Extended covered patio, perfect for enjoying the view. \r\nKWS Builders has built amazing custom homes for years. As a premier builder in the Lake Livingston area, you will find the experience to be professional and rewarding. Call today to learn more about this custom home and other custom home options!' ,`Acres` = '1.023' ,`Area` = '44' ,`BuilderName` = 'KWS Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Four Corners Estates Phase 4 Lot 74 & 75' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Four Corners Estates Phase 4' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Well' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663708350' WHERE `Matrix_Unique_ID` = '211749053' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T21:00:45.397' ,`MLSNumber` = '3154644' ,`ListAgentFullName` = 'Amy Crow' ,`ListOfficeName` = 'Corison Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.756023' ,`Longitude` = '-95.030015' ,`PhotoCount` = '6' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Westridge Park' ,`StreetNumber` = 'tbd' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'KWS Builder- NEW CONSTRUCTION \"The Magnolia\" is located in Four Corners Estates Phase 4, a highly sought-after location. The Magnolia is pure luxury featuring a large kitchen , high ceilings, spacious living area and lots of space for entertaining! One story-3 bedroom and 2.5 bath. The primary bedroom comes complete with a walk-in closet and an ensuite bath. Extended covered patio, perfect for enjoying the view. KWS Builders has built amazing custom homes for years. As a premier builder in the Lake Livingston area, you will find the experience to be professional and rewarding. Call today to learn more about this custom home and other custom home options!' ,`Acres` = '1.02' ,`Area` = '44' ,`BuilderName` = 'KWS Builders, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Four Corners Estates Phase 4 Lots 79 & 80' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Four Corners Estates Phase 4' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708351' WHERE `Matrix_Unique_ID` = '211794661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T21:10:48.720' ,`MLSNumber` = '5579291' ,`ListAgentFullName` = 'Amy Crow' ,`ListOfficeName` = 'Corison Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.754316' ,`Longitude` = '-95.029744' ,`PhotoCount` = '7' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Westridge Park -' ,`StreetNumber` = 'TBD' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'KWS Builder- NEW CONSTRUCTION \"The Willows\" is located in Four Corners Estates Phase 4, a highly sought-after location. Come cozy up this winter next to the fireplace in this open concept home with high ceilings and many custom details. One story-3 bedroom and 2.5 bath. The primary bedroom comes complete with a walk-in his/her closet and an ensuite bath. Extended covered patio, perfect for enjoying the view. KWS Builders has built amazing custom homes for years. As a premier builder in the Lake Livingston area, you will find the experience to be professional and rewarding. Call today to learn more about this custom home and other custom home options!' ,`Acres` = '1.029' ,`Area` = '44' ,`BuilderName` = 'KWS Builders, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Four Corners Estates Phase 4 Lot 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Four Corners Estates Phase 4' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Well' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663708351' WHERE `Matrix_Unique_ID` = '211795538' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T21:23:55.137' ,`MLSNumber` = '47190797' ,`ListAgentFullName` = 'Amy Crow' ,`ListOfficeName` = 'Corison Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.755895' ,`Longitude` = '-95.029086' ,`PhotoCount` = '6' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Westridge Park' ,`StreetNumber` = '?' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2383' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'KWS Builder- NEW CONSTRUCTION Currently being built! \"The Houston\" is located in Four Corners Estates Phase 4, a highly sought-after location. The Houston features a spacious living area with high ceilings and an open concept for family living and entertaining. One story-3 bedroom and 2.5 bath. The primary bedroom comes complete with a walk-in closet and an ensuite bath. Extended covered patio, perfect for enjoying the view. KWS Builders has built amazing custom homes for years. As a premier builder in the Lake Livingston area, you will find the experience to be professional and rewarding. Call today to learn more about this custom home and other custom home options!' ,`Acres` = '1.015' ,`Area` = '44' ,`BuilderName` = 'KWS Builders, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Four Corners Estates Phase 4 Lot 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Four Corners Estates Phase 4' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708351' WHERE `Matrix_Unique_ID` = '211796162' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T20:20:20.637' ,`MLSNumber` = '3294001' ,`ListAgentFullName` = 'Dalia Groh' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.289567' ,`Longitude` = '-94.825418' ,`PhotoCount` = '3' ,`PostalCode` = '77551' ,`RoomCount` = '4' ,`ListPrice` = '364900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue L' ,`StreetNumber` = '5218' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW BUILD DOUBLE PRIMARY ROOMS in GREAT Midtown LOCATION with completion dates mid Sept. This home sits close to Broadway with quick access to the Beach, Moody Gardens, UTMB and the STRAND with many restaurants and activities! Ideal for 2nd home or a short term rental where the market is sizzling HOT. Step onto a Large balcony on the first floor & enter into a Bright, Airy Family Living room which boasts High ceilings & open concept, kitchen with quartz counters and all new SS appliances. SPC luxury vinyl flooring will be added throughout home. A Half bath on the first floor is convenient for you and your guests. From the kitchen the back door opens to a wide balcony with stairs down to a large fully fenced back yard for your BBQ and entertaining pleasure. Two Primary Bedrooms are on the second floor, with en-suite baths. Relax on your balcony in the front bedroom where you will feel the beautiful Galveston breezes while enjoying your morning coffee or evening cocktail.' ,`Acres` = '0.0689' ,`Area` = '33' ,`BuilderName` = 'High Tide LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 21 BLK 20 DENVER RESURVEY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Resurvey' ,`TaxAmount` = '759' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708351' WHERE `Matrix_Unique_ID` = '211877044' --> 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','211901612','1663708351','211901612','2022-09-08T20:06:45.107','61666100','Denise Garza','Mission Realty','','','30.190261','-95.619165','10','77354','3','189900.00','Active','Boardwalk','30018','Drive','Magnolia','2','0','3','1834','Single-Family','Great starter home in Magnolia sits on a large lot. This 3 bedroom home offers plenty of open space with a combo dining, and the living room offers a separate sitting area and fireplace. The center of the home has a large room that can be used has a separate living area and or game room. Primary bath has dual vanities, standing shower and separate soaking tub. There is also a small storage shed in corner of the property.','0.3788','15','','','','','Sellers Disclosure','1','','1','Magnolia/1488 East','Central Electric','0','S774800 - PARK PLACE MH PARK, BLOCK 1, LOT 49, SERIAL # TXFL','Cleared,Wooded','16500','Survey','','','0','','0','','0','','','','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal','1','Ranch','Park Place Mh Park','2990','1.8587','Public Water,Septic Tank','2003','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T21:36:10.997' ,`MLSNumber` = '44526864' ,`ListAgentFullName` = 'Elisa Ramos' ,`ListOfficeName` = 'Metro Plus Realty PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813866' ,`Longitude` = '-94.979505' ,`PhotoCount` = '28' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Sativa' ,`StreetNumber` = '7811' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2146' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this 4 bdrm, 3.5 bath home that also features a Chefs kitchen. Custom stained wood cabinets, pot filler faucet and so much more. Kitchen is open to the family room and dining area. New AC installed in 2019. Floor in the garage has been redone. This home definitely has an elegant look to it. Refrigerator, Washer and Dryer stays.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 59 SPRINGFIELD ESTATES SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Springfield Estates Sec 02' ,`TaxAmount` = '6009' ,`TaxRate` = '3.095' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708351' WHERE `Matrix_Unique_ID` = '211983317' --> 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','212138298','1663708351','212138298','2022-09-08T21:05:36.597','88367903','Jacob Chackonal','MIH REALTY, LLC','','','29.741883','-95.302145','5','77011','9','590000.00','Active','Avenue I','6841','','Houston','2','2','4','3216','Single-Family','Huge Home !!! Has a large master bedroom downstairs w/master bath. Inside laundry room,big family room. 2 A/C 5 ton units with two separate meters for the house and the business and the garage apt.','0.1148','4','','','','','Mud,Sellers Disclosure','','','','East End Revitalized','Central Gas','0','LTS 1 & 2 BLK 83 CENTRAL PARK','Subdivision Lot','5000','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','FRANKLIN ELEMENTARY SCHOOL (HOUSTON)','AUSTIN HIGH SCHOOL (HOUSTON)','EDISON MIDDLE SCHOOL','Accompany,Controlled Access,Leave Business Card','Appraisal District','2','Traditional','Central Park','4207','2.3307','Public Sewer,Public Water','1980','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','212193931','1663708351','212193931','2022-09-08T20:33:11.143','59487803','Beverly Bradley','Weekley Homes','','','30.212890','-95.330989','10','77302','6','350000.00','Active','Rising Wren','15611','Court','Conroe','2','0','3','1878','Single-Family','Brilliant comforts and timeless beauty combine to create the dynamic new home in Artavia. Your spacious Owner’s Retreat awaits your personal design flair. Pamper yourself and explore your wardrobe potential in the luxurious Owner’s Bath and walk-in closet. Each spare bedroom presents a uniquely appealing place to thrive and personalize. Your open floor plan provides a stylish variety of dining, home office, and living spaces. The eat-in kitchen includes ample room devoted to meal prep, dining, storage, and presentation. Covered porches are located in the front and back yards, offering plenty of outdoor relaxation opportunities.\r\n\r\nContact the David Weekley at ARTAVIA Team to schedule your in-person or video tour of this sensational new construction home in Conroe, Texas!','','19','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,No Disclosures','1','','','Spring Northeast','Central Gas,Zoned','1','Lot 15 Block 01','Greenbelt,Other,Subdivision Lot','','Survey','','995','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','SAN JACINTO ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Artavia','','3.19','Public Sewer,Public Water','2022','Builder'); --> 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','212242618','1663708351','212242618','2022-09-08T21:36:20.827','9291966','Samantha Sloan','The Texas Living Real Estate G','','','30.140641','-94.900113','35','77535','3','410000.00','Active','Road 6609','68','','Dayton','2','1','3','2261','Single-Family','Exquisite country living in Encino Estates! Fabulous Dallas plan in highly sought after Section 1 - rare opportunity! Perfectly situated on an oversized lot with mature shade trees and tons of space to create your dream outdoor living area. Oversized true 3 car garage and upgraded elevation with large covered front porch provide spectacular curb appeal. Functional open concept living in this amazing floor plan offers a private study, formal dining, and HUGE open kitchen with large island adjoining the living area. Gorgeous white cabinets with upgraded backsplash and countertops quickly make this your favorite kitchen of all! The beautiful Owner\'s Retreat features spa-like private bath with separate walk in shower and garden tub. Generously sized secondary bedrooms are tucked away separately and share a perfectly sized bath worthy of guests! Other great features include a sprinkler system, gutters, and security system. LOW TAXES, 15 min from 99 Grnd Pkwy, 5 min from Dayton!','0.689','52','','','','','Sellers Disclosure','1','Wood Burning Fireplace','1','Dayton','Central Electric','1','ENCINO ESTATES, SEC 1, BLOCK 9, LOT 4, ACRES .689','Cleared','30013','Appraisal District','','450','0','','3','','0','','','','','Composition','74 - Dayton','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Encino Estates, Sec 1','5230','1.7512','Aerobic,Public Water','2018','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','212322066','1663708351','212322066','2022-09-08T20:45:42.023','71484421','Candice Cucco','United Real Estate','','','30.298741','-94.849836','48','77327','6','299000.00','Active','County Road 2255','614','Road','Cleveland','2','0','3','1600','Single-Family','Lovely 3 bed 2 bath country home sitting on 4 stunning park like acres. Located in Tarkington ISD in the quiet Davis Hill Big Thicket subdivision. This well maintained home boast high ceilings, crown molding, a beautiful stone fireplace, over sized laundry room, a cozy primary bedroom adorned with wooden beams and an accent wall along with a spacious Primary bathroom with luxury finishes. The land offers a beautiful stocked pond with a bridge to a small island, large mature trees, a chicken coop, and a little garden area. The property is fully fenced in with a separately fenced backyard. Relax on the large covered porch and enjoy all the peace and quiet the country has to offer. Such a charming and peaceful place to call HOME!','4','52','Clayton Homes','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Liberty County East','Central Electric','0','DAVIS HILLS BIG THICKET PARK, LOT 10, ACRES 4.0','Cleared','174240','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','102 - Tarkington','TARKINGTON PRIMARY SCHOOL','TARKINGTON HIGH SCHOOL','TARKINGTON MIDDLE SCHOOL','Accompany,Leave Business Card,Supra Keybox','Seller','1','Ranch','Davis Hills Big Thicket Park','1392','1.53','Aerobic,Well','2016','Builder'); --> 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','212326777','1663708351','212326777','2022-09-08T20:06:06.420','62882904','Caley Crochet','Rachel Crochet Properties,LLC','','','29.803161','-95.434695','32','77008','7','759000.00','Active','Sea King','2006','Street','Houston','2','0','3','2244','Single-Family','Beautiful remodeled 3 bedroom 2 bath home located on a corner lot in Lazybrook. 4th Bedroom, 7x10, is\r\naccessed via the primary suite area and perfect for an office/nursery. Extremely open floor plan w/ a large bonus area, butler’s pantry w/ brick wall accent & custom-made built in hall tree.House boasts an oversized kitchen, large island w/ cook top that over looks the living room. Kids play area/flex area off of the living room. New cabinetry, SS appliances & walk in pantry. Engineered hardwood floors through out living area and primary bedroom. Enormous primary closet. Primary bath has large shower & double vanity. French doors off of primary suite w/ a pathway to covered back porch. Covered porch with cedar siding & recessed lighting. Indoor laundry room House has new 30 yr old roof, 2020 Trane furnace, Trane AC unit, Trane AC coil, all new double pane windows, interior & exterior doors, light fixtures, hardware, baseboards, interior/exterior paint. Home won’t last long!','0.1835','9','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Timbergrove/Lazybrook','Central Electric','0','LT 43 BLK 5 LAZYBROOK','Corner,Subdivision Lot','7992','Appraisal District','','','0','','1','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Supra Keybox','Seller','1','Traditional','Lazybrook','8413','2.3307','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully