Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T20:47:30.910' ,`MLSNumber` = '38809064' ,`ListAgentFullName` = 'Christopher Sarrat' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.506729' ,`Longitude` = '-94.968357' ,`PhotoCount` = '17' ,`PostalCode` = '77518' ,`RoomCount` = '7' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Mary Lane' ,`StreetNumber` = '121' ,`StreetSuffix` = '' ,`City` = 'Bacliff' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1719' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom, 2 bath home, Wood laminate & ceramic tile floors throughout.  Spacious living room with bay window and fireplace. Large eat in kitchen, breakfast bar and dining space with french doors leading to your covered patio. You will love the huge backyard with beautiful trees.  Home is located one block from the water, near shopping centers, restaurants, Kemah area and Bayshore Park is right down the street.  Easy access to 146.  Adjacent lot number 20 can be purchased separately.  Room sizes are approximate, please measure for accuracy.  Call today to see.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 88 Anthony Hatch NE 50FT of Lot 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12400' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'KENNETH E. LITTLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Baycrest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706076' WHERE `Matrix_Unique_ID` = '205769229'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T20:44:46.877' ,`MLSNumber` = '42746542' ,`ListAgentFullName` = 'Dolores Yarrito' ,`ListOfficeName` = 'Top Guns Realty on Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.366352' ,`Longitude` = '-95.672834' ,`PhotoCount` = '20' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Ridge' ,`StreetNumber` = '20125' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New, completed, and never lived in spacious Creede floor plan home looking for a new homeowner ready to fill home with love, fun and memories.  Neutral calming gray tones surround the family area for evening and weekend relaxation.  The open modern kitchen has a huge beautiful sparkling quartz counter perfect for hosting family and friend gatherings.  Outdoor covered patio and large backyard offers many options for outdoor entertaining, playground equipment, and storage shed.  Home is located in the popular Fairwater subdivision in Montgomery Independent School District, just minutes from Lake Conroe, Margaritaville Lake Resort, golfing, shopping, fine dining, and medical facilities.' ,`Acres` = '0.1732' ,`Area` = '39' ,`BuilderName` = 'Castlerock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S503205 - FAIRWATER 05, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7553' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '775' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706076' WHERE `Matrix_Unique_ID` = '208174601'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T21:26:41.757' ,`MLSNumber` = '53059707' ,`ListAgentFullName` = 'Becky Schenk' ,`ListOfficeName` = 'Oro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344974' ,`Longitude` = '-96.611317' ,`PhotoCount` = '19' ,`PostalCode` = '77879' ,`RoomCount` = '3' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Moss Oak' ,`StreetNumber` = '218' ,`StreetSuffix` = 'Street' ,`City` = 'Somerville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 2 bedroom, 1 bathroom, 768 sf cottage is ready for you to call home or be your weekend getaway! The home greets you with a front deck and garden before walking into the bright, main living space open to the kitchen and dining area with an ample amount of storage space in the pantry and cabinets. The full bathroom features a beautifully tiled shower with soaking tub. Storage space continues in each bedroom closet and a large linen closet in the hallway. Located only 3.2 miles from Lake Somerville and close to local diners, dives, grocers and gas stations. You don’t want to miss this home conveniently situated across the street from the Somerville Place community playground and pavilion.' ,`Acres` = '0.11' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S2502 SOMERVILLE PLACE LOT 314, .1148 ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Somerville Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706076' WHERE `Matrix_Unique_ID` = '210341436'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T20:00:37.887' ,`MLSNumber` = '76933514' ,`ListAgentFullName` = 'Casey Johnson' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.429996' ,`Longitude` = '-95.578285' ,`PhotoCount` = '40' ,`PostalCode` = '77318' ,`RoomCount` = '11' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Point Aquarius' ,`StreetNumber` = '12910' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3195' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the gated community of Point Aquarius on the shores of Lake Conroe! This beautiful home has a backyard oasis w/chlorine pool, hot tub, screened in covered back patio, & pool decking to accommodate lots of outdoor furniture, space for a grill, & a great place to entertain. Private study just off the entry w/french doors & wood floors. Tile throughout the main living areas & master suite. Amazing island kitchen features gas stove, SS appliances, granite counter tops, double sink, automatic exhaust fan on microwave, walk-in corner pantry, & eat in breaksfast room w/chandelier. Living room w/gas fireplace. Spacious master w/vaulted ceiling & double doors leading out to the pool. Master bath w/soaking tub, walk in shower, double vanity w/makeup area, & walk in closet w/extra under stair storage. 4 bedrooms up w/large gameroom. Whole home Generator, solar screens, 4X8 storage shed, radiant barrier, oversized garage, and so much more. See Feature Sheet! Schedule a showing today!' ,`Acres` = '0.2104' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'POINT AQUARIUS 06, BLOCK 4, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9167' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Point Aquarius 06' ,`TaxAmount` = '6766' ,`TaxRate` = '2.2748' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706076' WHERE `Matrix_Unique_ID` = '210668192'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T20:35:55.033' ,`MLSNumber` = '98961708' ,`ListAgentFullName` = 'Stacy Jones' ,`ListOfficeName` = 'Texas 1st Choice Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.372807' ,`Longitude` = '-95.084287' ,`PhotoCount` = '23' ,`PostalCode` = '77510' ,`RoomCount` = '7' ,`ListPrice` = '233000.00' ,`Status` = 'Active' ,`StreetName` = '14th' ,`StreetNumber` = '12106' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Downtown Santa Fe.  4 bedroom, 2 bath, 2 car garage.  Gorgeous Large Mature Trees!  Beautiful updated Kitchen with Lovely Butcher Block and Granite counter tops  Plenty of cabinet space.  Primary bedroom steps down to Bamboo flooring with glass French doors.  Split floor plan with open concept.  Large, open, detached 2 car garage.' ,`Acres` = '0.2388' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 149 E MITCHELL SUR LOTS 27 & 28 BLK 5 ALTA LOMA TOWNSIT' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Alta Loma Townsite' ,`TaxAmount` = '4571' ,`TaxRate` = '2.6465' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706076' WHERE `Matrix_Unique_ID` = '211122734'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T21:17:03.610' ,`MLSNumber` = '72165349' ,`ListAgentFullName` = 'Sandra Billings' ,`ListOfficeName` = 'Billings Real Estate Group' ,`SellingAgentFullName` = 'Mary Grimaldo' ,`SellingOfficeName` = 'Strada' ,`Latitude` = '29.841734' ,`Longitude` = '-95.832805' ,`PhotoCount` = '47' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '799000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Shadow Grass' ,`StreetNumber` = '4802' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the exclusive neighborhood of Katy Lake Estates this custom 1-story home w/ 3 car garage on 1.38 acres with a casita is perfectly situated on a cul de sac street. No neighbors behind for the the privacy you desire. This home features all solid surfaced flooring. Upgraded spec level with 8 ft doors, coffered ceilings and a fully remodeled kitchen with an expansive island. The breakfast area and game room look out onto the fenced acreage & pool. The large primary room has a remodeled ensuite w/super shower & enormous walk in closet. 3 good sized secondary rooms, one with a private bathroom are on the opposite wing of the home. The casita is sheetrocked and has a 1/2 bath. It\'s currently a workshop but can be finished to be a separate guest suite or hobby area or home office or 4 th car garage. 2 new HVAC\'s, a whole house vacuum, full brick/stone, new water softener/filtration, new wireless pool controller, tech shield, Plantation shutters and more. 2 community lakes.' ,`Acres` = '1.38' ,`Area` = '25' ,`BuilderName` = 'Custom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 KATY LAKE ESTATES SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '60113' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Lake Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.03' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706076' WHERE `Matrix_Unique_ID` = '211212313'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T20:37:31.750' ,`MLSNumber` = '44897220' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.778468' ,`Longitude` = '-95.592783' ,`PhotoCount` = '6' ,`PostalCode` = '77079' ,`RoomCount` = '9' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Barryknoll' ,`StreetNumber` = '14111' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2247' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Estate Sale --- Add your own special touch in updating. Prestigious Spring Branch ISD. Great Game Room for entertaining.' ,`Acres` = '0.1774' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 6 NOTTINGHAM WEST SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7728' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WILCHESTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nottingham West' ,`TaxAmount` = '8301' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706076' WHERE `Matrix_Unique_ID` = '211683675'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T20:27:46.650' ,`MLSNumber` = '72645860' ,`ListAgentFullName` = 'Rebecca Sherwood' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075339' ,`Longitude` = '-95.467328' ,`PhotoCount` = '26' ,`PostalCode` = '77388' ,`RoomCount` = '7' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Lockgate' ,`StreetNumber` = '3322' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market- no inspections took place. Buyer just found a different house better suited for their family.\nSpacious and affordable 4 bedroom, 2 bath home in the established community of Dove Meadows. Open and spacious living area makes it a prime space for entertaining family and friends. Updates to the home include new roof and solar \"Attic Breeze\" fan (5/2022 with transferable warranty), 10x12 Moragn shed, laminate flooring and granite countertops. Great location conveniently located near 99 and I45. Community amenities include pool and clubhouse, and zoned to Klein ISD schools.\n' ,`Acres` = '0.161' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 BLK 7 017*D6031700-003-007-061 DOVE MEADOWS SEC 3 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KREINHOP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dove Meadows Sec 03 R/P' ,`TaxAmount` = '5107' ,`TaxRate` = '2.804' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706077' WHERE `Matrix_Unique_ID` = '211766377'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211805536','1663706077','211805536','2022-09-02T21:20:04.210','87834029','Monica Foster','eXp Realty, LLC','','','29.818158','-94.974259','32','77521','6','255000.00','Active','Cinnamon Lake','5635','Drive','Baytown','2','0','3','1492','Single-Family','***Please read agent remarks****\r\nWelcome to this charming 3 bedroom 2 bath home. Walk into a large living room with beautiful real wood floors. An eat-in kitchen and 3 bedrooms to suit. Perfect starter home or downsize to this cozy home. Refrigerator and washer and dryer to stay with the sale of the home.','0.148','2','','','Electric Dryer Connections,Gas Dryer Connections','','Mud','1','','','Baytown/Harris County','Central Gas','1','LT 11 SPRINGFIELD ESTATES SEC 6','Subdivision Lot','6448','Appraisal District','','340','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','23 - Goose Creek Consolidated','VICTORIA WALKER ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Springfield Estates Sec 06','5257','3.095','Public Sewer,Public Water','2008','Appraisal');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T21:54:21.360' ,`MLSNumber` = '26761798' ,`ListAgentFullName` = 'Fafu Zeng' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049272' ,`Longitude` = '-95.396271' ,`PhotoCount` = '29' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayleaf' ,`StreetNumber` = '23426' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated 4 Bedroom 2 bath 2-car garage home with 2nd story deck that overlooks huge treed yard. Brand new double wide driveway! Newly painted throughout both inside and outside. New vinyl, tile and carpet flooring. Updated bathrooms and kitchen. The primary bedroom with a full bathroom is downstairs and other 3 bedrooms with a full bathroom are upstairs. Gas fireplace in Game room. Close to Mercer Botanical Gardens and minutes away from golf course. This home won\'t last! Schedule your show today.' ,`Acres` = '0.1653' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 50 TIMBER LANE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane Sec 06' ,`TaxAmount` = '5339' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706077' WHERE `Matrix_Unique_ID` = '211888669'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212146736','1663706077','212146736','2022-09-02T20:04:49.980','9595655','Connie Inmon','CB&A, Realtors','','','29.946352','-95.744499','39','77433','9','465000.00','Active','Maravillas Cove','17019','Drive','Cypress','4','0','4','2607','Single-Family','A two-story home that features Lennar\'s \'Home within a Home.\' This beautiful home includes a main home and a private suite that are seamlessly connected with a dual access door which allows for as much interaction between the main home and the private suite as you desire. The main home includes 3 spacious bedrooms, three full bathrooms, a generous family room, a large open kitchen with a granite center island, a walk-in pantry, and a dining room. The primary bedroom includes a private bathroom retreat with a separate shower and garden tub and dual vanities and a huge walk-in closet. This home also features an upstairs loft or optional flex room as well as a walk-in utility room, plenty of extra storage, and a two-car garage. The full private suite is perfect for elderly parents, returning children, a home office, long-term guests, or any family member living with you. It includes its own private entrance, a living room, a kitchenette with a laundry area, a full bathroom and a bedroom.','0.1377','25','Lennar','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Cypress South','Central Electric','1','LT 5 BLK 2 BRIDGELAND HIDDEN CREEK SEC 20','Subdivision Lot','6000','Appraisal District','','1255','0','','2','Electric Oven,Freestanding Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','BRIDGELAND HIGH SCHOOL','SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Lockbox Front','Builder','1.5','Traditional','Bridgeland','10168','3.4329','Water District','2017','Appraisal');  --> New record created successfully<br />