Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T15:44:43.477' ,`MLSNumber` = '4595616' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Jennifer Leteff' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.532926' ,`Longitude` = '-95.526793' ,`PhotoCount` = '9' ,`PostalCode` = '77358' ,`RoomCount` = '5' ,`ListPrice` = '461585.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Jim Hall' ,`StreetNumber` = '213' ,`StreetSuffix` = 'Lane' ,`City` = 'New Waverly' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new D. R. Horton home on an acre! One story, 3 car garage, 4 bed, 3 bath. Guest suite has bathroom to itself. Large study at front of home! Gorgeous white cabinetry in the kitchen! Double paned low E vinyl windows, LED lighting, Techshield radiant barrier, plus tons of other energy features! Deed restricted enough to keep the neighborhood beautiful, but still allows for RV garage and a horse to be on the property. Home site has a ton of trees, very close to the National Park and is down the street from Lake Conroe and a boat slip. Come see it today!' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'New Waverly Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WAVERLY PLACE - SEC 1, BLOCK 5, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43318' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waverly Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695181' WHERE `Matrix_Unique_ID` = '206970779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T15:03:13.073' ,`MLSNumber` = '10579876' ,`ListAgentFullName` = 'Cristina Lara' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688256' ,`Longitude` = '-95.348553' ,`PhotoCount` = '7' ,`PostalCode` = '77021' ,`RoomCount` = '7' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Madrid' ,`StreetNumber` = '6742' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a cozy home with a central location in the University area. Kitchen bar, stainless steel range, microwave, dishawasher, and wine rack with a large prep area. Stackable washer and dryer conveys, alarm, blinds, steel automatic gate with remote control and wood fence. (Refrigerator belongs to tenant.)' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 10 GRAND PARK' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARTSFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Park' ,`TaxAmount` = '3483' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695181' WHERE `Matrix_Unique_ID` = '207719846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T14:17:59.580' ,`MLSNumber` = '40325023' ,`ListAgentFullName` = 'Chauntel Ardoin' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943361' ,`Longitude` = '-95.254548' ,`PhotoCount` = '17' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunlit Pass' ,`StreetNumber` = '4503' ,`StreetSuffix` = 'Loop' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1967' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Come view this beautifully remodeled 4 bedroom, 2 bathroom home. Featuring an open floor plan with 2 masters, a formal dining off the entry way, LED lightening throughout, and a 5 mega pixel/2 TB camera system that can be viewed from TV and any mobile devices. Homeowner can view all outdoor cameras from the main inside TV. Enjoy this gourmet chef\'s kitchen with stainless steel appliances, granite countertops, soft close drawers and cabinets, wet bar with built in wine cooler, wine rack and additional sink. The custom kitchen and breakfast nook overlook the family room. Upgraded fans and light fixtures throughout home. New AC installed in 2021. If all these extras was not enough, enjoy extremely low energy bills of no more than $30 per month due to the solar panels. Come check out this beauty before it is gone!' ,`Acres` = '0.1231' ,`Area` = '1' ,`BuilderName` = 'Pioneer Plantation' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 4 CANYON VILLAGE AT PARK LAKES SEC 7' ,`LotDesciption` = 'Corner' ,`LotSize` = '5363' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PARK LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Village at Park Lakes' ,`TaxAmount` = '5625' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695181' WHERE `Matrix_Unique_ID` = '208954932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T15:09:58.473' ,`MLSNumber` = '4015087' ,`ListAgentFullName` = 'Rhonda Perales' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.245459' ,`Longitude` = '-95.491607' ,`PhotoCount` = '45' ,`PostalCode` = '77384' ,`RoomCount` = '11' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Crossing' ,`StreetNumber` = '130' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Meadows of Jacobs Reserve home situated on a premium cul-de-sac lot w/greenbelt to the right & aquatic center behind, including resort-style pool, sunbathing patio, splash pad, picnic pavilion, trees/park space, playgrounds, two dog parks (small/large) & a catch & release stocked fishing pond. Prefer a little more privacy? How about your own heated PebbleTec pool with rock waterfall, grotto, spa & outdoor kitchen! Or relax inside with 3450sf of comfortable living space, including 4 bedrooms, 3.5 baths, a formal dining room & huge game room/media room combo. An open kitchen/breakfast/living area is perfect for entertaining with an L-shaped granite island that seats six and GE Profile stainless appliances. The bedrooms are large and all feature tray ceilings and walk-in closets. There is crown molding throughout, high ceilings, wood floors downstairs, a central vacuum, water softener, 4-camera security system, multi-jet master shower, plus much more! Don\'t wait to see this one!' ,`Acres` = '0.1551' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S721100 - THE MEADOWS AT JACOBS RESERVE 01, BLOCK 4, LOT 29' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '6758' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Meadows At Jacobs Reserve' ,`TaxAmount` = '10839' ,`TaxRate` = '2.7488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695181' WHERE `Matrix_Unique_ID` = '209328482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T14:35:05.530' ,`MLSNumber` = '43018518' ,`ListAgentFullName` = 'Bianca Moreno' ,`ListOfficeName` = 'Olde Homestead Properties of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.012471' ,`Longitude` = '-95.087243' ,`PhotoCount` = '14' ,`PostalCode` = '77336' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Beckman' ,`StreetNumber` = '2020' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This 4 bed/2 bath, open concept manufactured home is situated in a quiet neighborhood in Huffman ISD and ready for you to call it home. Its country living with easy access to FM 1960 and the heart of Huffman, TX. This one won\'t last long! Schedule a tour today!' ,`Acres` = '0.2608' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 BLK 1 LAKE HOUSTON WOODLAND TERRACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Houston Woodland Terrace' ,`TaxAmount` = '1786' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663695181' WHERE `Matrix_Unique_ID` = '209886671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T15:55:53.147' ,`MLSNumber` = '79075093' ,`ListAgentFullName` = 'Yadira Villarreal' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.752346' ,`Longitude` = '-95.200695' ,`PhotoCount` = '29' ,`PostalCode` = '77364' ,`RoomCount` = '8' ,`ListPrice` = '253000.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Lane' ,`City` = 'Point Blank' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own a Lake House in walking distance to Lake Livingston! Breath taking views of the lake are something you will enjoy on your regular stroll to the lake\'s edge.\r\nProperty has 2 new AC units.' ,`Acres` = '0.2185' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'NORTH WOODS #1, BLOCK 4, LOT 7, ACRES .2185' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '9518' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'North Woods #1' ,`TaxAmount` = '1734' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663695181' WHERE `Matrix_Unique_ID` = '210148290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T14:36:36.757' ,`MLSNumber` = '74901590' ,`ListAgentFullName` = 'Christina Alvarez' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794837' ,`Longitude` = '-95.548670' ,`PhotoCount` = '12' ,`PostalCode` = '77043' ,`RoomCount` = '5' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Brinwood' ,`StreetNumber` = '10167' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1601' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Located in one of the most desirable neighborhoods Shadow Oaks in Spring Branch. This lovely home has 4 bedroom 2 full baths PLUS Mother in Law suite which includes kitchen, bath and 1 bedroom! The garage has also been converted to a flex 1 bedroom 1 bath. This home is perfect to bring extra income! Quick access to Memorial City Mall, City Centre, and major Freeways! Call to schedule your private showing today' ,`Acres` = '0.2013' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 ROYAL OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8769' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHADOW OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Oaks Sec 01' ,`TaxAmount` = '6467' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695182' WHERE `Matrix_Unique_ID` = '210435472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T14:35:47.807' ,`MLSNumber` = '22963623' ,`ListAgentFullName` = 'Hillary Krebs' ,`ListOfficeName` = 'The Good Label Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829392' ,`Longitude` = '-95.427887' ,`PhotoCount` = '20' ,`PostalCode` = '77018' ,`RoomCount` = '5' ,`ListPrice` = '897000.00' ,`Status` = 'Active' ,`StreetName` = 'Sue Barnett' ,`StreetNumber` = '1587' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1449' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An investors dream! Nearly 1/2 an acre of lot square footage and nestled onto a quiet street with walkability to some of the areas most popular restaurants, parks, and grocery stores. Situated on the dividing line between Oak Forest and Garden Oaks, the existing 2-bed/2-bath home can be easily renovated and additional structures added (the back yard is perfect for adding a pool and outdoor oasis!), or tear it down and rebuild your dream home. The lots can be subdivided as needed or keep this generous piece of land all to yourself. The possibilities are truly endless. Don\'t miss this rare opportunity!' ,`Acres` = '0.4695' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Garden Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 27 & 28 BLK 55 GARDEN OAKS SEC 5' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '20450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DURHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Garden Oaks Sec 05' ,`TaxAmount` = '20971' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695182' WHERE `Matrix_Unique_ID` = '211084035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T14:39:34.997' ,`MLSNumber` = '71741710' ,`ListAgentFullName` = 'Azeez Elegbeji' ,`ListOfficeName` = 'The Elegbeji Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722059' ,`Longitude` = '-95.866637' ,`PhotoCount` = '33' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Casen Ranch Ln' ,`StreetNumber` = '28602' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '\"Perry Home” A rare-find diamond on a CUL-DE-SAC in ultra-desirable Creek Cove at CROSS CREEK RANCH! This stunning home has a fire place to keep you warm doing the winter season, 4 bedrooms, 3 full baths, game room and study. This incredible home was lovingly cared for by the current owners and had all of the features and amenities buyers are looking for, as well as being zoned for acclaimed KATY ISD schools.' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Creek Cove at Cross Creek Ranch Sec 16, BLOCK 1, Lot 56' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Creek Cove At Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695182' WHERE `Matrix_Unique_ID` = '211137339' --> Updated record success