Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T16:28:33.853' ,`MLSNumber` = '19058010' ,`ListAgentFullName` = 'Felicia Stinnett' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.643358' ,`Longitude` = '-95.936583' ,`PhotoCount` = '8' ,`PostalCode` = '77441' ,`RoomCount` = '7' ,`ListPrice` = '885000.00' ,`Status` = 'Active' ,`StreetName` = 'Whispering Pecans' ,`StreetNumber` = '3215' ,`StreetSuffix` = 'Drive' ,`City` = 'Weston Lakes' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'To be built. Custom built with all the high-end details! Homesite is a beautiful view lot in The Reserve at Weston Lakes. Open floorplan with tall ceilings throughout 100% Stucco exterior. Designer finishes include luxurious bathrooms. Kitchen has side by side 6\' built-in refrigerator/freezer and 48\" gas commercial style range! Oversized eat at island this home is designed for entertaining friends and family! Step outside for country and river views, no neighbors behind your home. Outside back terrace has over 500\' of outdoor living space. Quality built with high energy efficiency in mind. Weston Lakes is a secure beautiful country club neighborhood with a strong community feel. Great schools and security gates this is a highly desired development unique to the area.' ,`Acres` = '0.2938' ,`Area` = '30' ,`BuilderName` = 'Makenna' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RESERVE AT WESTON LAKES SEC 4, BLOCK 1, LOT 33, REPLAT NO. 1' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot,Water View,Wooded' ,`LotSize` = '14150' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Reserve At Weston Lakes Sec 4' ,`TaxAmount` = '876' ,`TaxRate` = '2.1698' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694837' WHERE `Matrix_Unique_ID` = '205130671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T17:13:46.440' ,`MLSNumber` = '29177059' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946844' ,`Longitude` = '-95.782750' ,`PhotoCount` = '29' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '798298.00' ,`Status` = 'Active' ,`StreetName` = 'Heartleaf Aster Way' ,`StreetNumber` = '11106' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Cambridge for sale by Newmark Homes in Bridgeland. 5 beds (2 down), 4.5 baths, living, formal dining, mud room, game room, media room, four car garage, courtyard entrance. This is the one you\'ve heard about, modern, sleek, and elegant. Come see this home before it sells... because it will soon!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '24/01/06' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9450' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.637885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694837' WHERE `Matrix_Unique_ID` = '205227180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T16:45:40.787' ,`MLSNumber` = '44493374' ,`ListAgentFullName` = 'Kaleb Monroe' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895773' ,`Longitude` = '-95.547153' ,`PhotoCount` = '50' ,`PostalCode` = '77040' ,`RoomCount` = '5' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Pines' ,`StreetNumber` = '14810' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Have you ever dreamed of living in a Smart Home? Well, dream no more because we have the listing for you! Own the smartest home of the block, is a 4 bedroom (all up), 2.5 bathrooms with just a little over 2100 sqft, FULLY updated, no carpet, and it comes integrated with Amazon Alexa! In addition to its voice-activated capabilities, you will find a fully updated kitchen with a contemporary cooktop, Granite countertops, great amount of counter space, and custom Knotty Alder Wood cabinets. It doesn’t stop there, upstairs you will find 4 large bedrooms with amazing closet space. The master suite fit for a king and queen with updated double vanity. Can’t forget about the amazing backyard where you can bask in the shade under the home’s large covered back Rest assured this property did not experience flooding or any busted pipes during the freeze. Important note: the home also comes with solar panels which the buyer will have to take overpayments. Hurry it won’t be on the market long.' ,`Acres` = '0.1641' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 4 WINDFERN FOREST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Windfern Forest Sec 04' ,`TaxAmount` = '4588' ,`TaxRate` = '2.541' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694837' WHERE `Matrix_Unique_ID` = '206977894' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T17:35:46.783' ,`MLSNumber` = '89824878' ,`ListAgentFullName` = 'Kevin Reed' ,`ListOfficeName` = 'RE/MAX All Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.915048' ,`Longitude` = '-94.092488' ,`PhotoCount` = '17' ,`PostalCode` = '77705' ,`RoomCount` = '6' ,`ListPrice` = '278000.00' ,`Status` = 'Active' ,`StreetName` = 'Kenner' ,`StreetNumber` = '11444' ,`StreetSuffix` = 'Road' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated country charmer in the sought after Hampshire Fannett school district!! Beautiful farm plank tile sets the stage for this open concept remodel. The kitchen has updated cabinets, central island and granite surfaced with plenty of storage spaces. The window over the sink overlooks the front lawn that is lined with large pecan trees for shade. Step into the primary bathroom with the updated walk in shower with wood plank tile walls and stone flooring. The bac yard is full of life with birds of all kinds and it is completely fenced and ready for your pets. The garage has extra space for tools and toys. Walking into the home from the garage, you will enter the mud room with extra sink and over sized pantry. This home has so much to offer, if you need a peaceful quiet area then book your appointment to view this gem today!' ,`Acres` = '0.97' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 4 9 13 ORANGE FARMS .967AC' ,`LotDesciption` = 'Wooded' ,`LotSize` = '42253' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '110 - Hamshire-Fannett' ,`SchoolElementary` = 'HAMSHIRE-FANNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAMSHIRE-FANNETT HIGH SCHOOL' ,`SchoolMiddle` = 'HAMSHIRE-FANNETT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Orange Farms' ,`TaxAmount` = '4018' ,`TaxRate` = '2.0652' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694837' WHERE `Matrix_Unique_ID` = '210582218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T17:25:36.483' ,`MLSNumber` = '46713647' ,`ListAgentFullName` = 'Min Mai' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.011731' ,`Longitude` = '-95.630157' ,`PhotoCount` = '9' ,`PostalCode` = '77429' ,`RoomCount` = '5' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Marblepointe' ,`StreetNumber` = '13518' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious single story 4 bedroom home is located in a lake view community just 2 miles / 5 minutes away from 249. Interior features include an additional flex room arched by secondary bedrooms, spacing living room with high ceilings and breakfast area with views to the backyard, backed by a greenbelt. Race track lane swimming pool and tennis court provide abundant outdoor relax for kids and parents. Excellent schools. Schedule your showings today!' ,`Acres` = '0.1435' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 2 LAKES AT NORTHPOINTE SEC 2' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '765' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes/Northpointe Sec 02' ,`TaxAmount` = '8188' ,`TaxRate` = '3.0164' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663694837' WHERE `Matrix_Unique_ID` = '210674182' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T16:05:00.567' ,`MLSNumber` = '92215445' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.952733' ,`Longitude` = '-95.206648' ,`PhotoCount` = '25' ,`PostalCode` = '77346' ,`RoomCount` = '13' ,`ListPrice` = '489857.00' ,`Status` = 'Active' ,`StreetName` = 'Sunlit Falls' ,`StreetNumber` = '15803' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Terrace, Elevation A). CURRENTLY UNDER CONSTRUCTION. Two story. 4 bedrooms. 3.5 baths. Spacious island kitchen open to informal dining room and family room. Primary suite with large walk in closet. Large Game Room and three additional bedrooms upstairs. Covered patio and attached 2 car garage. Forget the world outside and come home to Balmoral, a community surrounded by beauty and peace in the West Lake Houston area of northeast Beltway 8 in Humble, TX. Balmoral offers residents connected living with luxurious homes and many amenities to choose from, including the Houston area\'s Crystal Clear Lagoon surrounded by glistening white sand beaches. Stop by the Westin Homes model home today to find out more about Balmoral!' ,`Acres` = '0.1834' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7991' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '1813' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694837' WHERE `Matrix_Unique_ID` = '210766233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T16:18:25.300' ,`MLSNumber` = '34367110' ,`ListAgentFullName` = 'Wayne Comer' ,`ListOfficeName` = '360 Realty & Management' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401645' ,`Longitude` = '-94.911961' ,`PhotoCount` = '17' ,`PostalCode` = '77590' ,`RoomCount` = '3' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = '18th' ,`StreetNumber` = '1119' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1187' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL RECENTLY REMODELED 3 BEDROOM 1 BATH HOME IN TEXAS CITY\r\nTENANT OCCUPIED UNTIL THE END OF SEPTEMBER 2022' ,`Acres` = '0.1895' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 D RICHARDSON SUR LOT 9 BLK 35 MAINLAND PARK SEC A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mainland Park' ,`TaxAmount` = '2861' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694838' WHERE `Matrix_Unique_ID` = '210972584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T16:33:10.743' ,`MLSNumber` = '34944752' ,`ListAgentFullName` = 'Jovani Frank' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.010793' ,`Longitude` = '-95.539999' ,`PhotoCount` = '18' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Mentmore' ,`StreetNumber` = '8338' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story cottage style home with primary bedroom down in the sought after Champion Forest! Gorgeous new flooring, recent interior and interior paint, recent E windows, beautiful oak tress covering front yard, roof at 7 years new. Come take a tour and bring your best offer so this can be your new home!' ,`Acres` = '0.1768' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 017*C2915074-004-002-010 CHAMPION FOREST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Champion Forest Sec 04' ,`TaxAmount` = '5529' ,`TaxRate` = '2.3465' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694838' WHERE `Matrix_Unique_ID` = '211010288' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T17:05:56.020' ,`MLSNumber` = '59073952' ,`ListAgentFullName` = 'Loretta Moehle' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.797423' ,`Longitude` = '-95.100138' ,`PhotoCount` = '37' ,`PostalCode` = '77360' ,`RoomCount` = '10' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '184' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming rustic ranch style 3/2/2 with original pine flooring, wood walls, living room beams and fireplace will make a memory when you first step in the door. Enter into an enclosed porch with 3 sets of French doors to open whenever you like for entertaining. Pass by the fenced deck, perfect for a hot tub moment as you enter the main house. The kitchen is central to both the dining room and the living room. The warmth of this home is evident especially in the living room, with its wood beams and corner fireplace. The primary bedroom is split from the other two bedrooms. Outside there is a two car size garage/shop building and two fenced areas for your pets. Outside you will find another 16x16 deck for entertaining. In all the home offers 1370 square feet of charm and sits on .3295 acres. Come take a look to see how you can put your personal touch on this awesome cottage, only two blocks from access to Lake Livingston.' ,`Acres` = '0.3295' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'Oak Ridge Lot 144 and 145' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14351' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Ridge' ,`TaxAmount` = '1586' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694838' WHERE `Matrix_Unique_ID` = '211073660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T16:49:39.787' ,`MLSNumber` = '45142559' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.184310' ,`Longitude` = '-95.147694' ,`PhotoCount` = '13' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '383740.00' ,`Status` = 'Active' ,`StreetName` = 'Constantine' ,`StreetNumber` = '3006' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Over 25,000 square foot wooded lot and 3 car garage! This 4 bedroom 3 full bathroom, has two beds and two full baths downstairs! The open kitchen features shaker cabinets, granite countertops and stainless-steel appliances! The spacious Primary Suite is tucked away for your own private retreat with separate shower and garden tub. The home has front sprinklers, and a home automation system. You will appreciate the great storage and energy efficient features throughout.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 10 Block 13 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25017' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates at Roman Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694838' WHERE `Matrix_Unique_ID` = '211113931' --> Updated record success