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-08T22:38:16.470' ,`MLSNumber` = '21509778' ,`ListAgentFullName` = 'Chip Bubela' ,`ListOfficeName` = 'Bubela & Associates, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.093267' ,`Longitude` = '-97.611745' ,`PhotoCount` = '17' ,`PostalCode` = '78617' ,`RoomCount` = '6' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Vaquero' ,`StreetNumber` = '105' ,`StreetSuffix` = 'Court' ,`City` = 'Del Valle' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous newly built home, on an oversized corner lot.. This spacious 4 bedroom & 3 bath craftsman like home features an open floor plan with beautiful tile floors, nice cabinetry with granite counter top, walk in pantry & much more! Upstairs you will find a family room with views towards the City of Austin and COTA. The massive fenced in backyard features a fabulous pool ready to keep you cool. Located approx. 10 minutes from Circuit of The Americas, approx. 15 minutes from Tesla Gigafactory, and approx. 25 minutes from Bastrop..\r\nSchedule your private showing before its gone!' ,`Acres` = '0.75' ,`Area` = '83' ,`BuilderName` = 'Hector Torres' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TWIN CREEKS SUBDIVISION, BLOCK C, LOT 17, ACRES 0.750' ,`LotDesciption` = 'Corner' ,`LotSize` = '32670' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '210 - Bastrop' ,`SchoolElementary` = 'CEDAR CREEK ELEMENTARY SCHOOL (BASTROP)' ,`SchoolHigh` = 'CEDAR CREEK H S' ,`SchoolMiddle` = 'CEDAR CREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Twin Creeks Sub' ,`TaxAmount` = '97' ,`TaxRate` = '1.895' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663708379' WHERE `Matrix_Unique_ID` = '207494783'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T22:11:25.070' ,`MLSNumber` = '57855024' ,`ListAgentFullName` = 'Kevin Scott' ,`ListOfficeName` = 'NextHome Executives' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.626504' ,`Longitude` = '-97.852797' ,`PhotoCount` = '14' ,`PostalCode` = '78641' ,`RoomCount` = '9' ,`ListPrice` = '424999.00' ,`Status` = 'Active' ,`StreetName` = 'Earl Keen' ,`StreetNumber` = '228' ,`StreetSuffix` = 'Street' ,`City` = 'Leander' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2229' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful almost new home in the growing Larkspur subdivision. This home is loaded with custom features that are unique to this home...in addition to the interior updates, this home has a water softener, tankless water heater, custom storage in the garage, and much more! All bedrooms are on the second level so the entire main floor is available for entertaining friends and family! Granite countertops throughout the entire house. ALL APPLIANCES INCLUDED even the additional fridge in the garage! Covered patio in the backyard with a separate shed for storing yard items included.' ,`Acres` = '0.108' ,`Area` = '83' ,`BuilderName` = 'Milestone' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S11943 - CAUGHFIELD PH 7A, BLOCK GG, LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4704' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '123 - Leander' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Larkspur' ,`TaxAmount` = '12912' ,`TaxRate` = '2.8158' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708380' WHERE `Matrix_Unique_ID` = '209330201'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T23:30:06.750' ,`MLSNumber` = '29792466' ,`ListAgentFullName` = 'Sheryle Campbell' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708392' ,`Longitude` = '-95.406608' ,`PhotoCount` = '41' ,`PostalCode` = '77030' ,`RoomCount` = '10' ,`ListPrice` = '1997000.00' ,`Status` = 'Active' ,`StreetName` = 'McClendon' ,`StreetNumber` = '2031' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern NEW CONSTRUCTION in the established Southgate Community will be both ENERGY EFFICIENT and SMART TECHNOLOGY. Walking distance to the Medical Center and Rice University, this fabulous entertaining home offers over 5100 sf of living space with a bright OPEN FLOOR PLAN accented by 11 foot ceilings and MODERN FINISHES constructed with an impressive attention to detail. Quality construction starts with the PIER & BEAM foundation elevated 4 feet above ground & a gorgeous stone exterior with black framed double pane windows. The stunning exterior offers just a glimpse of the luxurious detailing found inside, including the reclaimed-look wood floors that flow continuously throughout the downstairs & upstairs. A gourmet island kitchen boasts QUARTZ COUNTERS and top-of-the-line Dacor appliances. This two-story home is elevator capable with 4 bedrooms and 4 ensuite bathrooms upstairs. An expansive covered patio with outdoor kitchen and room for pool. Ready by September 1, 2022' ,`Acres` = '0.1446' ,`Area` = '17' ,`BuilderName` = 'NRR COnstruction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 3 BLK 6 SOUTHGATE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southgate' ,`TaxAmount` = '12628' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708380' WHERE `Matrix_Unique_ID` = '209487857'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T23:44:13.383' ,`MLSNumber` = '17187175' ,`ListAgentFullName` = 'Michael Hewitt' ,`ListOfficeName` = 'Hewitt Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.108095' ,`Longitude` = '-95.394647' ,`PhotoCount` = '16' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '268000.00' ,`Status` = 'Active' ,`StreetName` = 'Loddington' ,`StreetNumber` = '28807' ,`StreetSuffix` = 'Street' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Roof, Gutters and Re-piped with APEX in 2021. Kitchen and Baths remodeled in 2018. Rare 4 bedroom 1 story, with all vinyl plank flooring. Large primary bedroom and bath with garden tub, separate shower and granite vanity with double sinks. Kitchen has recent cabinets granite counters, travertine backsplash, stainless LG appliances, a large island with extra storage, and room for bar chairs! Laundry room combined with gigantic walk in pantry!  Breakfast room and Formal dining rooms! Gas Log Fireplace! New light fixtures and fans throughout 2018. New Wifi capable Garage Door opener 2018. New garage access door and new French door 2021. Recent fence on 2 sides. New Wood deck in back yard 2022.' ,`Acres` = '0.14' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FOX RUN 06, BLOCK 2, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'FORD ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fox Run 06' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708380' WHERE `Matrix_Unique_ID` = '210491252'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T22:13:15.953' ,`MLSNumber` = '73061125' ,`ListAgentFullName` = 'Xiaoming Shao' ,`ListOfficeName` = '31 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826749' ,`Longitude` = '-95.805515' ,`PhotoCount` = '38' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Puccini' ,`StreetNumber` = '24919' ,`StreetSuffix` = 'Place' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2683' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two Story Home with 3 Bedrooms plus a study room, Master Down, plus another bedroom down. Large Gameroom Up, and Computer Nook. Separate Master Bath Tub and Shower, Covered Rear Patios and Full Sod Front and Rear Yard, 2\" Faux Wood Blinds, Environments For Living Certified Energy Efficient. New paint. Move in ready. Dimensions and other information are estimated. Please verify them by yourselves.' ,`Acres` = '0.134' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2 CAMILLO LAKES SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '5837' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes Sec 2' ,`TaxAmount` = '9402' ,`TaxRate` = '3.5333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708380' WHERE `Matrix_Unique_ID` = '210537257'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T22:40:39.270' ,`MLSNumber` = '20687979' ,`ListAgentFullName` = 'Hillory Shearer' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764526' ,`Longitude` = '-95.459711' ,`PhotoCount` = '33' ,`PostalCode` = '77056' ,`RoomCount` = '10' ,`ListPrice` = '1950000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Hollow' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5823' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled on over an acre only minutes from The Galleria and Memorial Park, the home greets with light, space and elegance that flows from room to room. Contemporary flair unites w/ spectacular finishes in this meticulously updated home. A rooftop deck& 5 patios overlook Buffalo Bayou. The interior of this home maintains original features mixed with designer Laura U’s flair.Clean lines accentuate the modern undertones that artfully accent countless views of dense, mature greenery. The customBentwood kitchen is perfect for entertaining. Elegant draperies on the floor to ceiling windows fit perfectly, a bright gallery awaiting an art collection, & the show stopping lights throughout are masterpieces themselves. The master bathroom boasts marble walls in the steam shower & the sauna completes your own private spa oasis. All these features & much more (there\'s still a second story to discuss) make this house a unique find in a desirable location. Must be seen in person. Never flooded.' ,`Acres` = '1.1898' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 2 PINE HOLLOW SEC 2' ,`LotDesciption` = 'Ravine,Water View,Waterfront' ,`LotSize` = '51826' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pine Hollow Sec 02' ,`TaxAmount` = '36927' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708380' WHERE `Matrix_Unique_ID` = '211219727'  --> 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','211960485','1663708380','211960485','2022-09-08T23:34:53.833','19920208','Peggy Metcalf','RE/MAX Space Center-Clear Lake','','','27.898509','-97.297092','15','78374','6','350000.00','Active','Santa Catalina','1133','Street','Portland','2','0','4','2033','Single-Family','Beautiful inside and out this 4 bedroom/2 bath home is nestled in the prestigious Bay Ridge\r\nsubdivision, proximity to schools, restaurants, and shopping. The stately stone exterior and the dramatic arched entryway lend a grand entrance into the spacious family room, complete with tile flooring and elegant tray ceilings. The large kitchen granite island overlooking the family room perfects the open floor plan concept. Upgraded tumbled marble backsplash with glass tile accents and granite countertops in the kitchen gives this home a custom look. The laundry room is complete with a sink,  cabinets, and folding area that opens into the large main closet with access to the stunning main bathroom with a tiled walk-in shower, double sinks, vanity, and plenty of counter space. Enjoy the convenience of the drop zone leading from the garage. Top it off with the covered patio, palapa, and large backyard for outdoor activities.','0.138','85','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','1','','','','Central Electric','0','BAY RIDGE UNIT 11 BLK 24 LT 17 0.138 ACRES','Subdivision Lot','6120','Appraisal District','','','0','','2','Freestanding Oven','0','','','Electric Range','','Composition','254 - Gregory-Portland','S.F. AUSTIN ELEMENTARY SCHOOL','GREGORY-PORTLAND HIGH SCHOOL','GREGORY-PORTLAND JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Ranch','Portland-Bay Ridge','6441','2.4224','Public Sewer,Public Water','2014','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','212237553','1663708380','212237553','2022-09-08T23:09:40.120','43431105','Scott Mortimore','Executive Texas Realty','','','30.092444','-95.744785','50','77447','10','625000.00','Active','Three Pines','22830','Drive','Hockley','3','1','4','2921','Single-Family','Welcome home to this breathtaking home sitting on just under an acre of land! This statement home makes you feel like you\'re always on vacation. Sitting on a quiet cul-de-sac lot offering four bedrooms, three baths with a private pool and luscious landscaping. From the moment you arrive on the impressive driveway you’ll be greeted by a beautiful front porch and lots of natural landscaping. The primary bedroom showcases large windows overlooking your beautiful property, an impressive en-suite and oversized closet. The secondary bedrooms and game room are also generous in size! The home features a modern, yet cozy upgraded kitchen, built-ins, updated laminate flooring, and new paint throughout the floor plan that flows perfectly. The backyard matches the wow-factor with its beautiful freeform pool and freestanding patio. You\'ll never want to leave this retreat!','0.9875','35','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Hockley','Central Gas','1','TR 12 BLK 2 2920 WEST U/R ABST 7 S BRWON','Wooded','43016','Appraisal District','','250','0','','3','Double Oven','1','Gunite','','Gas Cooktop','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Ranch,Traditional','Soloman Brown Abs #7','8884','2.1056','Aerobic,Septic Tank,Well','2001','Appraisal District');  --> New record created successfully<br />