Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T00:20:09.270' ,`MLSNumber` = '27231597' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702043' ,`Longitude` = '-95.706274' ,`PhotoCount` = '25' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '6923' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New One story Ranch Style home- by D.R. Horton! Completed!! Beautiful Vinyl Wood Large Plank Flooring throughout the high traffic areas, Tile in all Wet Areas & Luxurious Carpeting in Bedrooms! The Casual Dining Room & Family Room flows gracefully into the Gourmet Kitchen! Gourmet Kitchen is a Chef\'s dream with Upgraded Quartz Counters, Tile Back-splash, Large Eat-in Working Island with Under-mount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Tall Shaker Cabinets & more! Primary Private Suite with Luxurious Bathroom/Spa featuring Double Sink Vanity, Massive Shower with Seamless Glass Door, Walk-in Closet! 3 Guest Bedrooms & 1 Full Bath! Covered Patio! LOW Utility Cost with the outstanding Energy Features including: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home Automation\" Control your home from anywhere w/Echo & Dot! NO FLOODING! Amenities include: Pool, & Splash Pad! Just 20 minutes to The Galleria! Soon Updated Photos' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 27/Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642595' WHERE `Matrix_Unique_ID` = '210399110'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T23:19:50.410' ,`MLSNumber` = '40383501' ,`ListAgentFullName` = 'Zhoudan Lang' ,`ListOfficeName` = 'United Real Estate Austin' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818445' ,`Longitude` = '-95.678594' ,`PhotoCount` = '27' ,`PostalCode` = '77084' ,`RoomCount` = '12' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Zephyr Glen' ,`StreetNumber` = '3431' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A well-kept spacious property in the middle of west Houston. The owner kept the property super clean and well maintained. The property has 4 bedrooms and 2.5 bath, 1 office down, 2 game room up and 4 bedrooms up. Home is located conveniently close to I-10 and Texas 99. It is super convient to access to all highways, Energy Corridor and schools. Easy access Close to Cullen Park, within3-miles of walking/biking trails, picnic areas, and baseball/soccer fields. Close to I-10, 99, Hwy 6 and Park & Ride Facilities. Zoned to the highly-acclaimed Katy ISD. Low HOA fee. Never flooded. Walklk-in pantry. Refrigerator (new in 2021) stays, Carpet is super clean and shinning like new. The super clean and maintained home make you feel new home.  Schedule your showing today! Don\'t miss it.' ,`Acres` = '0.1085' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 47 BLK 3 BARKERS CROSSING SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Barkers Xing Sec 04' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642595' WHERE `Matrix_Unique_ID` = '212460218'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T23:17:19.143' ,`MLSNumber` = '56908515' ,`ListAgentFullName` = 'Kristie Houston' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Leslie Minter' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.972440' ,`Longitude` = '-95.183132' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '650000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Butano Springs Lane' ,`StreetNumber` = '17627' ,`StreetSuffix` = '' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4085' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 bed, 4.5 bath, 3 car garage home on nearly HALF OF AN ACRE cul-de-sac lot in Eagle Springs! Meticulously maintained home with high ceilings and custom wood plantation shutters throughout. Entertaining is a breeze with the open living, kitchen and eating area that flows into the formal dining room. Chef\'s kitchen boasts upgraded Kent Moore cabinets and granite counters, GE Profile double ovens(1 is convection), gas cooktop plus tons of storage and counter space. Primary suite features a separate sitting area with backyard access. Primary en suite has separate vanities, jet tub and large tiled shower. Upstairs game/bedroom with full bath is a great spot for guests or get togethers. Step outside to the backyard oasis featuring a large Pebble Tech pool with water feature plus tons of uncovered/covered patio space. No back fence neighbors. Additional amenities include: whole house generator, Energy star certified in 2008, full yard sprinkler system and complete security system.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 1 EAGLE SPRINGS SEC 33' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '20422' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642596' WHERE `Matrix_Unique_ID` = '213091112'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T23:08:04.377' ,`MLSNumber` = '95811441' ,`ListAgentFullName` = 'Maricela Benton' ,`ListOfficeName` = 'Lea Homes Realty INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.830393' ,`Longitude` = '-95.131603' ,`PhotoCount` = '40' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '316950.00' ,`Status` = 'Active' ,`StreetName` = 'Cattle' ,`StreetNumber` = '273' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lea Homes is offering this 3 bedroom, 2 bath signature series home that features a modern theme with trend conscious colors and 8 ft plank flooring throughout entire home (no carpet). The home sits on a large lot with a privacy fenced backyard. The home has 10-foot ceilings throughout and 11-foot ceilings in family room and extra-large primary bedroom. The kitchen features upgraded quartz countertops, 42-inch cabinets, brush nickel faucets, hardware and door levers, also a Samsung appliance package. Dining room has a modern chandelier and living room and primary bedroom have trendy ceiling fans. The primary bathroom includes an oversize fully tiled walk-in shower with a built-in seat and an added window for light. The antique porcelain tile floors and designer mirrors make it a real treat after a long day. An efficient Carrier HVAC system with digital thermostat will keep your electricity bills low. The subdivision has a private boat ramp for homeowners.' ,`Acres` = '0.1964' ,`Area` = '44' ,`BuilderName` = 'LEA HOMES INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Texas Acres SEC 3 BLK 13 LOT 15' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '26' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Texas Acres' ,`TaxAmount` = '44' ,`TaxRate` = '2.0361' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642596' WHERE `Matrix_Unique_ID` = '213125639'  --> 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','213284001','1669642596','213284001','2022-11-26T00:20:08.180','23341454','Manu Dyse','Newhomeprograms.com LLC','','','30.362708','-95.617833','0','77316','3','235750.00','Active','Hammon','16629','','Montgomery','2','0','3','1500','Single-Family','Welcome home! This lovely home is ready for to call home. Strategically located close to Lake Conroe an loads of entertainment options. This 3 bedroom 2 bathroom home has been adorned with many updates including a fully fenced in backyard and patio. Schedule your tour today!!','0.0482','39','','','','','Sellers Disclosure','','','','Lake Conroe Area','Central Gas','1','LAKE CONROE VILLAGE, BLOCK 6, LOT 30, 50.000000% UDI','Subdivision Lot','2100','Appraisal District','','500','0','','0','','0','','','','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Lake Conroe Village UDI','1441','1.825','Public Sewer,Public Water','2018','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T23:06:48.547' ,`MLSNumber` = '3357327' ,`ListAgentFullName` = 'Maricela Benton' ,`ListOfficeName` = 'Lea Homes Realty INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.830556' ,`Longitude` = '-95.132171' ,`PhotoCount` = '30' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Cattle' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lea Homes is offering this 3-bedroom, 3 bath signature series home. This new construction sits on one and 1/2 lots totaling 14,147 Sq Ft. The home has 10-foot ceilings throughout and 11-foot ceilings in family room The kitchen features upgraded quartz countertops, 42-inch cabinets, brush nickel faucets, and a Samsung appliance package. The primary bathroom includes a fully tiled walk-in shower with a sitting bench, a large walk-in closet. 8 ft plank flooring in master bedroom, kitchen, living and dining area and carpet in the remaining 2 bedrooms, Antique porcelain tile flooring in all restrooms and utility room. Texas Acres is a lake access subdivision located in Onalaska, TX\r\n\r\n\r\nPlease verify bedrooms dimensions and also note that grass has been edited' ,`Acres` = '0.1964' ,`Area` = '44' ,`BuilderName` = 'LEA HOMES INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Texas Acres SEC 3 BLK 6 LOT 33 and 32' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '14147' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '26' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Texas Acres' ,`TaxAmount` = '44' ,`TaxRate` = '2.0361' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642596' WHERE `Matrix_Unique_ID` = '213346155'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T23:02:23.463' ,`MLSNumber` = '75371124' ,`ListAgentFullName` = 'Anabel Servin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022027' ,`Longitude` = '-95.783380' ,`PhotoCount` = '24' ,`PostalCode` = '77447' ,`RoomCount` = '12' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Farm Pasture' ,`StreetNumber` = '17454' ,`StreetSuffix` = 'Trail' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, well-maintained home is located in the quiet community of Dellrose. Upon entering you will notice the beautiful flooring and nice floorplan. The kitchen/breakfast is open to the family room. The kitchen boasts a beautiful large island with ample counter space, with wood cabinets, granite countertops, and stainless-steel appliances. This light, bright, open-concept living space is perfect for entertaining. \r\nA spacious owner suite is accompanied by a fully tiled master bathroom with separate split vanity sinks followed by an enormous closet.  \r\n\r\nDellrose has many amenities, which include a pool, splash pad, and multiple parks within the community. The home is in a great location with easy access to lots of restaurants and shopping.  This home has quick access to 290 and 99 allowing for a speedy commute anywhere you need to go! Come check it out today! Room dimensions are approximate please verify!' ,`Acres` = '0.1716' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 DELLROSE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7473' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dellrose Sec 3' ,`TaxAmount` = '10355' ,`TaxRate` = '3.5256' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642596' WHERE `Matrix_Unique_ID` = '213468381'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T00:20:09.130' ,`MLSNumber` = '74999293' ,`ListAgentFullName` = 'Enrique Martinez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.914990' ,`Longitude` = '-95.392189' ,`PhotoCount` = '14' ,`PostalCode` = '77060' ,`RoomCount` = '5' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Hollyvale' ,`StreetNumber` = '419' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1157' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO YOUR NEW HOME.! Beautiful House located in Colonial Hills Subdivision the heart of Houston\'s North Side has a new Roof ,New A.C.new floors,Kitchen and Bathrooms have fine Granite countertops,. is a must to see this georgeous property something you can call home.near to main freeways,schools,shopping centers,restaurants you name it. 2 car garage.(can be converted to Garage Apt) for more info call Agent.\r\n\r\nSELLER VERY MOTIVATED.! MAKE YOUR OFFER' ,`Acres` = '0.1934' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 4 COLONIAL HILLS' ,`LotDesciption` = 'Other' ,`LotSize` = '8424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'BUSSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALDINE HIGH SCHOOL' ,`SchoolMiddle` = 'ALDINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Colonial Hills' ,`TaxAmount` = '2396' ,`TaxRate` = '2.1528' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642597' WHERE `Matrix_Unique_ID` = '213900311'  --> 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','214220829','1669642597','214220829','2022-11-25T23:34:55.713','68149487','Judy Voigt','JLA Realty','','','29.356494','-95.595776','44','77430','7','520000.00','Active','Deer Run','20418','Road','Damon','3','0','4','2400','Single-Family','Welcome to your home in the country. This beautiful home sits on 3 acres in a neighborhood with seclusion and convenience set against Brazos Bend State Park. The 1 ½ story home is well-designed with 4 spacious bedrooms, 3 baths, up-graded appliances, HVAC, and structural construction attributes that are not typical to residential construction. There is a large well house to keep lawn mowers/yard tools with a water well that is 322’ deep, and a water softener that makes the water even better. There is a large metal shop for hobbies, a shed, spacious porches, a screened in back porch, and a covered outdoor barbeque area for family events. The subdivision has 3 parks: 2 along the neighborhood fishing lake and one on the Brazos River. Wildlife is abundant. The home has NEVER flooded even with the previous two 500-year rain fall events. Neighborhood is zoned in the sought after Needville school district. High speed fiber internet service is available.  Quick access to Hwy 288 and Hwy 59.','3.02','30','','','Electric Dryer Connections,Washer Connections','','Exclusions,Owner/Agent,Sellers Disclosure','1','Wood Burning Fireplace','1','Fort Bend Southeast','Central Gas,Propane','1','0080 E ROBERTSON, TRACT 158 (S PT), ACRES 3.02, PECAN BEND S','Cul-De-Sac','131551','Appraisal District','','165','0','','2','Gas Oven','0','','','Gas Range','','Composition','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Accompany,Leave Business Card,Supra Keybox','Seller','1.5','Traditional','E Robertson','5543','1.8957','Aerobic,Septic Tank','2002','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T00:18:47.967' ,`MLSNumber` = '32263021' ,`ListAgentFullName` = 'Max Guo' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709370' ,`Longitude` = '-95.746172' ,`PhotoCount` = '10' ,`PostalCode` = '77450' ,`RoomCount` = '7' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage Cove lane' ,`StreetNumber` = '20811' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2021' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Convenient to Westpark Tollway and Grand Pkwy, Zoned to top rated Katy ISD schools with Elementary, Junior HS, and HS schools all rated 9/10. Located in Grand Lakes with lake trails, playgrounds, swimming pools, tennis courts, and dog park. The house is of high ceiling, and only a couple of years of roof, kitchen updates, appliances, hard floors, gas log fireplace, sprinkler system, and recently replaced AC.' ,`Acres` = '0.1578' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKES PHASE THREE SEC 9, BLOCK 2, LOT 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lakes Ph Three Sec 9' ,`TaxAmount` = '6296' ,`TaxRate` = '2.5063' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642597' WHERE `Matrix_Unique_ID` = '214318223'  --> 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','214412157','1669642597','214412157','2022-11-26T00:20:04.747','42029255','Geraldine McCurry','BHGRE Gary Greene','','','29.798718','-95.488337','0','77055','11','695000.00','Active','Glourie','1529','Drive','Houston','3','0','5','2344','Single-Family','Photos coming soon.  New construction surrounds this corner property in the gorgeous neighborhood of Glenmore Forest.  9,000+ sf corner lot.  Property sold AS IS.  Beautiful old oak tree, pecan tree ... Great opportunity to build your custom home on large corner lot in desirable Spring Branch.  Currently no viewing of interior.  Must have appointment to walk the property.  Zoned to exemplary Spring Branch schools. Easy access to downtown, Energy Corridor, Med Center, Galleria area.  Convenient for Awty International, Duchesne Academy, Regis School.','0.2133','24','','','Gas Dryer Connections,Washer Connections','','Estate,Sellers Disclosure','','','','Spring Branch','Central Gas','0','LT 1 BLK 6 GLENMORE FOREST','Corner,Subdivision Lot','9291','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','49 - Spring Branch','VALLEY OAKS ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','LANDRUM MIDDLE SCHOOL','Appointment Required','Appraisal District','1.5','Traditional','Glenmore Forest','13138','2.4415','Public Sewer,Public Water','1957','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214430037','1669642597','214430037','2022-11-26T00:20:03.623','45131679','Tammy Downey','Martha Turner Sotheby\'s International Realty','','','30.039463','-95.133728','0','77345','10','1589000.00','Active','Royal Point','5911','Court','Kingwood','4','2','5','4853','Single-Family','Located in the upscale community of Royal Shores, magnificent only begins to describe this newly renovated Mediterranean masterpiece with breath taking views of Lake Houston. Designed for luxury living this stunning home offers lots of upgrades, high ceilings, light-filled interiors, open concept living space w/ curated finishes & authentic details. Welcome your guest through the oversized custom wrought iron front door into the dramatic foyer w/ lovely marble floors, matching iron staircase that flows effortlessly into the family & dining room. The architecturally unique chef\'s kitchen w/ commercial grade Subzero kitchen appliances, double ovens, 6 burner cook top & abundance of cabinets is open to family room w/ sweeping countertops. The breathtaking 2 story family room with Austin stone FP seamlessly blends the gorgeous outdoor living areas w/ the indoor family room & kitchen through walls of newly installed storm tight hurricane 5 proof windows.','0.4686','32','Jaeger Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Kingwood East','Central Gas','1','LT 3 BLK 1 ROYAL SHORES SEC 3 PAR R/P NO 1','Subdivision Lot,Water View','20413','Appraisal District','','985','0','','3','Convection Oven,Double Oven','1','Gunite,In Ground','','Gas Range,Grill','','Composition','29 - Humble','WILLOW CREEK ELEMENTARY SCHOOL (HUMBLE)','KINGWOOD HIGH SCHOOL','RIVERWOOD MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Mediterranean','Royal Shores','19678','2.5839','Public Sewer,Public Water,Water District,Well','2006','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T00:20:08.943' ,`MLSNumber` = '10054910' ,`ListAgentFullName` = 'Madison Holt' ,`ListOfficeName` = 'Home Topic Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868166' ,`Longitude` = '-95.470545' ,`PhotoCount` = '39' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Victory' ,`StreetNumber` = '4444' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2197' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 4444 Victory Ln. Primary bathroom BRAND NEW!! 3 BED 2.5 BATH in gated community. Featuring a private office suite, formal dining and large living area. Recessed lighting throughout home. Formal dining area with multi level ceilings, chandelier and large windows perfect for hosting family/guest. Kitchen - breakfast nook, island with cooktop, stainless steal appliances replaced in 2015. Jack-n-Jill style bathroom between bedroom 2/3 upstairs. Backyard with covered seating area. Book your tour today! **Bedroom dimensions are approximate' ,`Acres` = '0.1153' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 1 HUNTINGTON PARK PAR R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5022' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Park Prcl R/P' ,`TaxAmount` = '5331' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642597' WHERE `Matrix_Unique_ID` = '214499157'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T00:20:08.850' ,`MLSNumber` = '91972883' ,`ListAgentFullName` = 'Christopher Easley' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.058372' ,`Longitude` = '-95.376636' ,`PhotoCount` = '1' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Joy Ridge' ,`StreetNumber` = '23339' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1911' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.132' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 BRECKENRIDGE FOREST SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Forest' ,`TaxAmount` = '5906' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642597' WHERE `Matrix_Unique_ID` = '214720872'  --> 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','214893699','1669642598','214893699','2022-11-25T23:08:06.920','46905069','Danny Robinson','United Real Estate','','','32.630000','-96.930000','32','75137','9','680000.00','Active','Wind Ridge','1014','Drive','Duncanville','3','0','4','3221','Single-Family','Relocating to North Texas?  This Unique Custom home features 4 Bedrooms, 3 full baths, 3 fireplaces & a 3 car garage with an extended carport.   This is the perfect place to relax after work.   Updates include electrical wrought iron Security rear entrance gate, a basketball court and a  resurfaced legal diving 10\' pool.  For added comfort come enjoy the climate controlled sunroom and intercom system throughout the home.  The additional custom walk in closet is a must see..  the fireplaces are located in the living room, family room and primary bedroom.  Split bedrooms. Large kitchen with lots of counterspace, Breakfast area has large glass doors overlooking the patio.  Custom lighting around the back fence, close to schools.  Utility off Family Room for easy access.  Large Primary bedroom features wonderful window views to the swimming pool with access through the Sun Room.','0.4293','84','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace,Wood Burning Fireplace','3','','Central Gas,Heat Pump','0','GREENBRIAR ESTATES 5TH SEC BLK E LOT 13 VOL2001181/1409 DD09','Subdivision Lot','18700','Appraisal District','','','0','','3','Double Oven,Electric Oven','1','Gunite,In Ground','','Electric Cooktop','','Aluminum','485 - Duncanville','SMITH ELEMENTARY SCHOOL (DUNCANVILLE)','','BYRD MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Colonial','Greenbriar Estates','9580','2.6323','Public Sewer,Public Water','1983','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215077729','1669642598','215077729','2022-11-26T00:56:12.727','38181585','Christie Mertz','ResLand Realty Group','','','28.447590','-96.405360','11','77982','0','310000.00','Active','Circle Hook','15','','Port O Connor','0','0','0','1600','Single-Family','A fisherman’s getaway! Conveniently located across the street from Speedy Stop and Coastal Bend Marine in Port O’Connor, Texas. This metal building in the new up and coming Espiritu Santo Bay Resort community features 1600 square feet of open space with endless possibilities for you to make it your own! It includes a 640 square foot awning, a great spot to park your boat and clean your gear. Come take a look at this property, it’s a must see!','0.2219','65','','','','','No Disclosures','','','','','No Heating','0','A0019 SANTIAGO GONZALES, BLOCK 35, TRACT PT OF 1, ACRES 0.22','Cleared','','','','','0','','2','','0','','','','','Other','169 - Calhoun County','PORT O\'CONNOR ELEMENTARY','CALHOUN HIGH SCHOOL','TRAVIS MIDDLE SCHOOL (CALHOUN COUNTY)','Appointment Required','Seller','1','Barndominium','Espiritu Santo Bay Resort','','','Public Sewer,Public Water','2022','Seller');  --> New record created successfully<br />