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-23T05:23:25.300' ,`MLSNumber` = '86311707' ,`ListAgentFullName` = 'J. Carter Breed' ,`ListOfficeName` = 'J. Carter Breed Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769443' ,`Longitude` = '-95.608981' ,`PhotoCount` = '44' ,`PostalCode` = '77079' ,`RoomCount` = '9' ,`ListPrice` = '447900.00' ,`Status` = 'Active' ,`StreetName` = 'Pinesap' ,`StreetNumber` = '631' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home and ready to move in! Fresh interior paint! New roof!  New carpet! Numerous plumbing, electrical, A/C, and balcony repairs completed in 2022. Most hardware replaced & all A/C ducts cleaned w/ anti-microbial. Huge 29x18 family room with travertine-type tile floors, fireplace, and built-ins. Appealing kitchen features tile flooring, granite counters, stainless appliances, bar with 2nd sink. Large living room has wood floors and beamed high ceiling. Master down and bath has double-headed shower, butted glass, granite counters. Features side patio and courtyard. 3 carpeted bedrooms up, one with access to balcony. Hollywood bath up has recent tub, granite counters, tile floors. Owners have spent $45K+ in upgrades and repairs in 2nd quarter 2022.' ,`Acres` = '0.1193' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TR 24 .033333 INT COMMON LAND & ELE WESTCHESTER VILLA T/H U/' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '5198' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '785' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'NOTTINGHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westchester Villa T/H' ,`TaxAmount` = '9375' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949659' WHERE `Matrix_Unique_ID` = '210137305'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T04:53:18.653' ,`MLSNumber` = '98706927' ,`ListAgentFullName` = 'Karol Deem' ,`ListOfficeName` = 'Deem Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760613' ,`Longitude` = '-95.615562' ,`PhotoCount` = '24' ,`PostalCode` = '77077' ,`RoomCount` = '9' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsbridge' ,`StreetNumber` = '12908' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2545' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Desirable west Houston location in gated community of friendly neighbors. Very private cul-de-sac but close to shopping, restaurants and freeways.  Well maintained home includes an Acorn Stairlift that we can remove.  Furniture, art and decorations can be included or removed.   Wonderful floor plan with formal living and dining at main entrance with double side fireplace for den and kitchen and breakfast area in rear of first floor.   On second floor very large primary bedroom and bathroom, plus office or game area at top of stairs.   Two bedrooms with one bath in hallway. Many large closets and oversized garage for extra storage.  Cozy fenced yard for pets with nice deck in rear for entertaining or BBQ. Yard has sprinkler system and is low maintenance.  Nice brick pavers driveway in front dresses up this home.  Vacant and easy to show.' ,`Acres` = '0.101' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 STONEHENGE SEC 2' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1078' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lake at Stonehenge' ,`TaxAmount` = '6425' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949659' WHERE `Matrix_Unique_ID` = '211169166'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T05:13:23.990' ,`MLSNumber` = '70336915' ,`ListAgentFullName` = 'Deanna Kirksey' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.910988' ,`Longitude` = '-95.088135' ,`PhotoCount` = '30' ,`PostalCode` = '77532' ,`RoomCount` = '3' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Diamondhead' ,`StreetNumber` = '1207' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS HOME IS IMMACULATE! ONE OWNER - In golf course community. This home has been well maintained, it has high ceilings that boast a wide open living and formal dining area with lots of windows, beautiful kitchen w/island and granite countertops, custom solid wood cabinets and breakfast area.  Large primary bathroom with garden tub and separate shower, and walk in closet.  Tile flooring throughout and carpet in bedrooms.  Covered back porch and beautiful landscaping in the back yard, great for your morning coffee or evening cold beverage. This home has a great location just across the street from the park and walking trails.  This community has a golf course and country club, pools and tennis court, parks and splash pad along with private river access with boat ramp and beach area, and lake access with boat ramp and lots of space for a picnic.' ,`Acres` = '0.2401' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 NEWPORT SEC 8' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '10458' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 08' ,`TaxAmount` = '6108' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949659' WHERE `Matrix_Unique_ID` = '211173746'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T05:13:14.083' ,`MLSNumber` = '46334503' ,`ListAgentFullName` = 'Jeffrey Sadler' ,`ListOfficeName` = 'Sadler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.489819' ,`Longitude` = '-95.508508' ,`PhotoCount` = '35' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '489900.00' ,`Status` = 'Active' ,`StreetName` = 'Rudolph' ,`StreetNumber` = '10311' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home situated on an OVERSIZED LOT w/ RESORT STYLE BACKYARD in Sienna. Offering the perfect blend of indoor & outdoor living. Enjoy the privacy of no back neighbors & fabulous views of the wooded reserve behind the home. This 4 bedroom, 2.5 bath home features a private study, Gameroom & media room. Seamless spaces flow from the kitchen & breakfast room to the spacious family room w/ soaring ceiling, fireplace & wall of picturesque windows offering spectacular views of the backyard oasis & lots of natural light. Chef\'s kitchen w/ expansive island, rich cabinetry, granite counters & built-in SS appliances. The first floor primary suite comes complete w/ a sitting area & newly renovated spa-like bath that will WOW you. Wrought iron staircase leads upstairs to the gameroom (w/ pool table), media room, 3 spacious beds & full bath. The impressive backyard features a pool & spa, large yard to run & play & unobstructed views of Oyster Creek wooded reserve.' ,`Acres` = '0.2221' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF SHIPMANS LANDING SEC 13-B, BLOCK 1, LOT 17' ,`LotDesciption` = 'In Golf Course Community,Wooded' ,`LotSize` = '9673' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'SIENNA' ,`TaxAmount` = '9460' ,`TaxRate` = '2.6079' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949659' WHERE `Matrix_Unique_ID` = '212151458'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T04:09:22.203' ,`MLSNumber` = '15180824' ,`ListAgentFullName` = 'Houston Posey' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016529' ,`Longitude` = '-95.324475' ,`PhotoCount` = '31' ,`PostalCode` = '77338' ,`RoomCount` = '12' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Twain Mark' ,`StreetNumber` = '6522' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new! This immaculately cared for home has it all including a beautiful 42\'x25\' covered back patio with stamped/stained concrete and gorgeous 6\" beaded Aspen wood ceiling backing up to the neighbors 5-acre property providing added privacy. Master has an updated walk-in shower. Includes a formal living; extremely large family room; large secondary rooms with large closets. Upstairs game room is a must see with unique den attached. Wood blinds; and has a 7x10 shoe room just for shoes!' ,`Acres` = '0.1687' ,`Area` = '12' ,`BuilderName` = 'Long Lake LTD' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 CYPRESSWOOD POINT SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7348' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Pt Sec 03' ,`TaxAmount` = '8117' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949660' WHERE `Matrix_Unique_ID` = '212221296'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T04:38:14.317' ,`MLSNumber` = '5794264' ,`ListAgentFullName` = 'Paulina Elizalde' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785254' ,`Longitude` = '-95.161950' ,`PhotoCount` = '44' ,`PostalCode` = '77015' ,`RoomCount` = '6' ,`ListPrice` = '239850.00' ,`Status` = 'Active' ,`StreetName` = 'Texarkana' ,`StreetNumber` = '14630' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Location close to Channelview!! . Beautiful home with lots of room for storage, additional home studio, recent driveway built, electric fence all around the home. Quiet neighborhood close to Schools and shopping.\r\nThis house has never been flooded. Schedule your appointment now.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '2017 CMH 26X68 HUD# NTA1787960 SERIAL# BL2002299TXA LEASE LA' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Lockbox Right Side' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Manor' ,`TaxAmount` = '1655' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663949660' WHERE `Matrix_Unique_ID` = '212392313'  --> 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','212482121','1663949660','212482121','2022-09-23T05:56:15.640','33039275','Cathy Stubbs','Keller Williams Realty -SW','','','29.621394','-95.594028','37','77478','8','465000.00','Active','Charleston','31','Street','Sugar Land','3','0','3','2787','Single-Family','Gorgeous modern ranch-style, one-story in highly sought-after Sugar Creek community. PRIME LOCATION on the 1st hole of the Sugar Creek Country Club Golf Course. Windows along the entire back of the home capture panoramic views. Remodeled in 2015 – new roof, HVAC, granite counters, French doors, appliances, lighting, and MORE. 4 skylights fill the home with natural light. Spacious kitchen with double oven, Bosch gas cooktop & dishwasher, granite counters, walk-in pantry, AND additional wall pantry! Great room with fireplace, bar, and wall of windows. Open concept is perfect for entertaining! Updated light fixtures and LED daylight lighting. Owner\'s suite with 2 full bathrooms, 2 walk-in closets and entrance to a private walled patio. Guest bedroom and office/bedroom have access to another private patio. Plantation shutters in all bedrooms. In-ground sprinkler system. Driveway replaced in 2016. Top-ranked FBISD Schools. Schedule a private tour today; this unique property won\'t last long.','0.1653','29','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Sugar Land East','Central Gas','1','SUGAR CREEK SEC 11, BLOCK 1, LOT 120','In Golf Course Community,On Golf Course,Subdivision Lot','7200','Appraisal District','','494','0','','2','Double Oven,Electric Oven','0','','','Gas Cooktop','','Other','19 - Fort Bend','DULLES ELEMENTARY SCHOOL','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Contemporary/Modern','Sugar Creek','3704','2.0094','Public Sewer,Public Water','1976','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T05:22:22.713' ,`MLSNumber` = '18405985' ,`ListAgentFullName` = 'Kerry Duncan' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809630' ,`Longitude` = '-95.841792' ,`PhotoCount` = '34' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Goldstrum' ,`StreetNumber` = '6927' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2003' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location in one of the smaller sections in Cane Island! A Library/Study with French doors set at entry and front of the home. Island Kitchen is open to the Dining Room and Family Room which features a back wall of windows. The spacious Master Bedroom also has a wall of windows. The Master bath includes a corner garden tub, a separate glass-enclosed shower and a walk-in closet. Mud room is right off the garage, and the Utility Room has plenty of room for a second fridge. The Covered Patio is also screened-in.  There is also a Warming Tray in the kitchen below the ovens.' ,`Acres` = '0.1421' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422385 CANE ISLAND SECTION 25 BLK 2 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6189' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island Sec 25' ,`TaxAmount` = '10800' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949660' WHERE `Matrix_Unique_ID` = '212758528'  --> 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','212812686','1663949660','212812686','2022-09-23T05:47:10.813','77844278','Gay Milliorn','RE/MAX Eastside','','','29.767867','-94.948782','44','77521','7','235000.00','Active','Apache','1407','Trail','Baytown','2','0','3','1539','Single-Family','This charmer is the home you\'ve been searching for! In addition to 3 bedrooms, 2 baths, and a 2 car garage, this home offers a great formal dining room (could also be an office or game room), high ceiling in the living area, a breakfast room, and great covered patio. Need a spot to park your boat? You\'ll love the extra driveway and gate into the spacious backyard. The roof and HVAC are less than 5 years old, and this home is brick on all 4 sides! No flooding and no HOA! Convenient location with easy access to Hwy 146, Garth Rd, and I-10. You\'ll want to see this one for yourself!','0.1793','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Baytown/Harris County','Central Electric','0','LT 9 BLK 4 CHAPARRAL VILLAGE SEC 1','Corner,Subdivision Lot','7810','Appraisal District','','','0','','2','Double Oven','0','','','Electric Cooktop','','Composition','23 - Goose Creek Consolidated','CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','CEDAR BAYOU J H','Appointment Required','Appraisal District','1','Traditional','Chaparral Village Sec 01','4665','2.97','Public Sewer,Public Water','1970','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','212832541','1663949660','212832541','2022-09-23T05:25:07.527','4393755','Stacy Sharp Gehring','Weichert,REALTORS-Murray Group','','','30.047066','-95.602868','28','77375','12','324900.00','Active','Havenmist','12151','Drive','Tomball','2','1','3','2348','Single-Family','This Lennar brick home gives you all the Extras you deserve. The upgrades & extras start with the front door, the floors, crown molding throughout, in the large open kitchen with granite counter tops, upgraded cabinetry, 5 burner gas stove, oven, mounted microwave & dishwasher. You get an upgraded Silgranite kitchen sink with a touch activated faucet & sprayer, there is also a touch activated faucet in the half bath. The grand living room has vaulted ceilings, an upgraded floor to ceiling brick fireplace with a wood mantel. The Primary bedroom has vaulted ceilings, a window seat, an on suite with his & her sinks, a large garden tub, an oversized shower, 2 large walk-in closets, separate toilet area & a garden window with glass bricks to give you natural lighting & privacy. Up stairs the game room is ready for game day entertaining with a large, mounted TV. The large back yard & patio are ready for a pool & play equipment. You are entitled to an above average home; This is that home','0.1767','14','Lennar','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Spring/Klein/Tomball','Central Gas','1','LT 17 BLK 3 PINECREST FOREST SEC 7','Cul-De-Sac','7699','Appraisal District','','370','0','','2','Gas Oven','0','','','Gas Range','','Composition','32 - Klein','KOHRVILLE ELEMENTARY SCHOOL','KLEIN CAIN HIGH SCHOOL','ULRICH INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Pinecrest Forest','5806','2.7066','Water District','2002','Appraisal District');  --> New record created successfully<br />