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-12-04T01:22:29.090' ,`MLSNumber` = '3494275' ,`ListAgentFullName` = 'Corey Johnson' ,`ListOfficeName` = 'RE/MAX Pearland' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886201' ,`Longitude` = '-95.559674' ,`PhotoCount` = '34' ,`PostalCode` = '77040' ,`RoomCount` = '7' ,`ListPrice` = '414799.00' ,`Status` = 'Active' ,`StreetName` = 'Juneau' ,`StreetNumber` = '15810' ,`StreetSuffix` = 'Lane' ,`City` = 'Jersey Village' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and charming Home in Highly Desirable Jersey Village w/ a lot of character and space for your entire family to enjoy. This Home offers Spacious Family Room,Formal Dining,Kitchen,Primary Suite & Media Room all are of a TEXAS SIZE. Kitchen offers Granite CounterTops w/ Double Oven and plenty of beautiful cabinet space throughout, Natural Sun for the Breakfast area. 1st Floor has 2 primary bedrooms on opposite sides of the Home. The Home offers High Ceilings Double Size Family and Formal Dining rooms with Wood Flooring. If space is what you need, then this is your Home. You also have a Sunroom off the primary bedroom. The second level has 2 Bedrooms & a Media Room plus a Bonus Room. Jersey Meadows, an 18-hole Golf Course nearby & will soon have a new Conference Center/Clubhouse overlooking the Greens. Jersey Village is an Incorporated City w/it\'s own Police & Fire Department. There are many Family events in Jersey Village giving it a small town feeling. NO HOA or MUD. CALL NOW' ,`Acres` = '0.2771' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 30 JERSEY VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12071' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jersey Village' ,`TaxAmount` = '10162' ,`TaxRate` = '2.837' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087068' WHERE `Matrix_Unique_ID` = '190746408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '72640461' ,`ListAgentFullName` = 'Daryl Charbula' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659222' ,`Longitude` = '-95.480795' ,`PhotoCount` = '35' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '363000.00' ,`Status` = 'Active' ,`StreetName` = 'Burdine' ,`StreetNumber` = '11115' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2075' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gleaming hardwoods adorn this Westbury gem. Expansive and handsomely appointed family room with a wood burning fireplace invites company and lots of furniture! Amazing floor plan and layout with an abundance of natural light to brighten the home. Nicely sized formal living room. Gorgeously refinished hardwood floors throughout the family, living and bedrooms. No Carpet! Spacious kitchen w/granite counters & tons of cabinet space opens to a generously sized dining room and breakfast area. Considerably large utility/mud room. Zoned to and within walking distance of highly sought after Parker Elementary School. Short commutes to the Medical Center, Galleria & Downtown. HVAC recently replaced. Fenced/Gated Back Yard.' ,`Acres` = '0.1768' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 48 WESTBURY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 03' ,`TaxAmount` = '6578' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675087068' WHERE `Matrix_Unique_ID` = '205826141' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '45490081' ,`ListAgentFullName` = 'Amy Ennis' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.300783' ,`Longitude` = '-94.273455' ,`PhotoCount` = '28' ,`PostalCode` = '75929' ,`RoomCount` = '3' ,`ListPrice` = '244999.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2558' ,`StreetNumber` = '213' ,`StreetSuffix` = '' ,`City` = 'Broaddus' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2405' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FISHERMAN\'S DREAM!! This charming home with oversized garage is the perfect place to retreat and enjoy the quiet life in the quaint town of Broaddus. It is a short 5 minute drive from Sam Rayburn Reservoir with easy boat launch access. The house sits on 2 full acres with a small pond at the back of the property. It features an open floorplan, covered patio and extra parking for guests. You don\'t want to miss out on seeing this beautiful property!!' ,`Acres` = '2' ,`Area` = '78' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 433 W GRAHAM & IMPROVEMENT' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '232 - Broaddus' ,`SchoolElementary` = 'BROADDUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROADDUS HIGH SCHOOL' ,`SchoolMiddle` = 'BROADDUS HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'AB 433 W GRAHAM & IMPROVEMENT' ,`TaxAmount` = '2584' ,`TaxRate` = '1.4992' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087068' WHERE `Matrix_Unique_ID` = '205978586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '22051927' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.976030' ,`Longitude` = '-95.740060' ,`PhotoCount` = '22' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '656604.00' ,`Status` = 'Active' ,`StreetName` = 'Via Santa Caterina' ,`StreetNumber` = '20734' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3265' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story Avinger floorplan features stucco and stone exterior, 4 bed, 3 bath with a double door entry. Get cozy in the great room featuring a nice electric fireplace with a wood mantel and decorative tile. There is luxury vinyl flooring throughout parts of the home. Unwind in the study room with your favorite book. Have a night in and grill some burgers outside on the covered patio with a gorgeous vault ceiling. This home comes with a gas connection for an outdoor BBQ. Enjoy the luxuries in this prime home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe 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` = '01/01/35' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8134' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087069' WHERE `Matrix_Unique_ID` = '209178084' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '27009248' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.354640' ,`Longitude` = '-95.536480' ,`PhotoCount` = '16' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '321670.00' ,`Status` = 'Active' ,`StreetName` = 'Bluebonnet Ridge' ,`StreetNumber` = '2756' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Blanco Floorplan - Charming one-story brick home. This floorplan is ideal for entertaining guests with spaces\r\nthat flow together seamlessly in the main living areas. Get creative with a flex area, that\r\ncan be used for office, playroom, or at-home gym. Benefit from a large central island and\r\nwalk-in pantry in the gourmet kitchen. Escape to the primary suite featuring a dual sink\r\nvanity, large walk-in closet, and luxury bath. Catch the sunset on the covered outdoor\r\npatio at your new home!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '01/03/10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5937' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westridge Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087069' WHERE `Matrix_Unique_ID` = '210005624' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '85198528' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.354640' ,`Longitude` = '-95.536480' ,`PhotoCount` = '19' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '319760.00' ,`Status` = 'Active' ,`StreetName` = 'Bluebonnet Ridge' ,`StreetNumber` = '2766' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Blanco Floorplan - Beautiful brick one-story brick home. This floorplan is ideal for entertaining guests with\r\nspaces that flow together seamlessly in the main living areas. Get creative with a flex\r\narea, that can be used for office, playroom, or at-home gym. Benefit from a large central\r\nisland and walk-in pantry in the gourmet kitchen. Escape to the primary suite featuring a\r\ndual sink vanity, large walk-in closet, and luxury bath. Catch the sunset on the covered\r\noutdoor patio at your new home!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '01/03/12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westridge Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087069' WHERE `Matrix_Unique_ID` = '211442326' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '70821505' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.354640' ,`Longitude` = '-95.536480' ,`PhotoCount` = '15' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '315335.00' ,`Status` = 'Active' ,`StreetName` = 'Bluebonnet Ridge' ,`StreetNumber` = '2728' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Blanco Floorplan - Beautiful brick one-story brick home. This floorplan is ideal for entertaining guests with\r\nspaces that flow together seamlessly in the main living areas. Get creative with a flex\r\narea, that can be used for office, playroom, or at-home gym. Benefit from a large central\r\nisland and walk-in pantry in the gourmet kitchen. Escape to the primary suite featuring a\r\ndual sink vanity, large walk-in closet, and luxury bath. Catch the sunset on the covered\r\noutdoor patio at your new home!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '01/03/05' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westridge Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087069' WHERE `Matrix_Unique_ID` = '212244203' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '12982886' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851271' ,`Longitude` = '-95.442468' ,`PhotoCount` = '20' ,`PostalCode` = '77091' ,`RoomCount` = '4' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Francis Oak Pl' ,`StreetNumber` = '5819' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Francis Landing! This 50 home community is nestled within a gate community that offers several access points for easy accessibility. This community will offer each home with first floor living, private backyards to each home and some floor plans will be available with private driveways.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Urbatechture' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Blk 1 Francis Landing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Francis Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087069' WHERE `Matrix_Unique_ID` = '212527055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '94816071' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850459' ,`Longitude` = '-95.442574' ,`PhotoCount` = '20' ,`PostalCode` = '77091' ,`RoomCount` = '4' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Cebra' ,`StreetNumber` = '5814' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Francis Landing! This 50 home community is nestled within a gate community that offers several access points for easy accessibility. This community will offer each home with first floor living, private backyards to each home and some floor plans will be available with private driveways.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Urbatechture' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Blk 1' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Francis Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087070' WHERE `Matrix_Unique_ID` = '212527230' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '35830517' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.976030' ,`Longitude` = '-95.740060' ,`PhotoCount` = '22' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '700466.00' ,`Status` = 'Active' ,`StreetName` = 'Via Santa Caterina' ,`StreetNumber` = '20718' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Windsor floorplan - This beautiful two-story brick home has a grand 8\' double door entry showcasing a stunning curved staircase and high ceilings. Entertaining guests in the open- concept layout is easy. The kitchen and great room flow together seamlessly. The centralized island makes makes baking a dream. Did I mention the stainless steel appliances, decorative tile backsplash, and silestone countertops? Luxury vinyl plank flooring runs throughout the main areas of the home. Don\'t hesitate to retreat to the covered patio or cozy up to the fireplace with a good book. This two-story home will check all the boxes for function and style!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe 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` = '01/01/31' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087070' WHERE `Matrix_Unique_ID` = '213053956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '73101194' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830861' ,`Longitude` = '-95.805541' ,`PhotoCount` = '24' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Deledda' ,`StreetNumber` = '3939' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1849' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Camillo Lakes in Katy, TX! The Chestnut floor plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all, including blinds and upgraded carpet in the bedrooms. The first floor offers the perfect entertainment space with vinyl plank flooring and a large kitchen island overlooking the family and dining rooms! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod and a sprinkler system! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 BLK 1 CAMILLO LAKES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2614' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087070' WHERE `Matrix_Unique_ID` = '213103118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '65204685' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830689' ,`Longitude` = '-95.804384' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '274990.00' ,`Status` = 'Active' ,`StreetName` = 'Faletti' ,`StreetNumber` = '3914' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1711' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Camillo Lakes in Katy, TX! The Cypress floor plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all, including blinds and upgraded carpeting in the bedrooms! The first floor offers the perfect entertainment space with vinyl plank flooring and a large kitchen island overlooking the expansive family and dining rooms! The gourmet kitchen is sure to please with 42\" cabinets, quartz countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a sizable shower and a spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod and a sprinkler system! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087070' WHERE `Matrix_Unique_ID` = '213112842' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '77341985' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830668' ,`Longitude` = '-95.804816' ,`PhotoCount` = '43' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '269990.00' ,`Status` = 'Active' ,`StreetName` = 'Faletti' ,`StreetNumber` = '3919' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1643' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Camillo Lakes in Katy, TX! The Sequoia floor plan is a spacious 2-story home with 3 bedrooms, 2.5 baths, and 2-car garage. This home has it all including blinds, upgraded carpeting in the bedrooms, and vinyl plank flooring throughout the first-floor common areas! The first floor offers the perfect space for entertaining a large kitchen island open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, quartz countertops, and stainless-steel appliances! Upstairs offers a split floor plan and private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and Texas-sized walk-in closet! Enjoy the great outdoors with full sod and a sprinkler system! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '2550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087071' WHERE `Matrix_Unique_ID` = '213435877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '52285043' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830530' ,`Longitude` = '-95.804817' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '269990.00' ,`Status` = 'Active' ,`StreetName` = 'Faletti' ,`StreetNumber` = '3911' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1643' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Camillo Lakes in Katy, TX! The Sequoia floor plan is a spacious 2-story home with 3 bedrooms, 2.5 baths, and 2-car garage. This home has it all including blinds, upgraded carpeting in the bedrooms, and vinyl plank flooring throughout the first-floor common areas! The first floor offers the perfect space for entertaining a large kitchen island open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and stainless-steel appliances! Upstairs offers a split floor plan and private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and Texas-sized walk-in closet! Enjoy the great outdoors with full sod and a sprinkler system! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087071' WHERE `Matrix_Unique_ID` = '213437902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '11747685' ,`ListAgentFullName` = 'Thomas Jolly' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.378523' ,`Longitude` = '-95.631441' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '659500.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor' ,`StreetNumber` = '17431' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 3 bedroom, 2.5 bath waterfront property on Lake Conroe is a must-see! The home has fresh paint and new carpet throughout, and the boat dock is brand new. It\'s located in the desirable South Shore Estates neighborhood, and it\'s perfect for a family or anyone who loves being on the water. Don\'t miss out on this one!' ,`Acres` = '0.154' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S572350 - HARBOR POINT REPLAT A, BLOCK 2, LOT 4-A, 5-A, ACRE' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6708' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbor Point Rep A' ,`TaxAmount` = '9979' ,`TaxRate` = '2.3542' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087071' WHERE `Matrix_Unique_ID` = '214142154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T01:22:29.090' ,`MLSNumber` = '75540573' ,`ListAgentFullName` = 'Gilbert Tovar' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874340' ,`Longitude` = '-95.664705' ,`PhotoCount` = '31' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Blend Stone' ,`StreetNumber` = '16806' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1531' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2022’s Final Blow-Out Deal of the Year is here! Cozy 1-story located in a cul-de-sac lot in NW Houston is going be an awesome start for the coming year! This home has it all! Quartz kitchen counter tops with accenting quartz backsplash, New kitchen cabinets with soft closing doors & drawers, Lazy Susan, Farmers sink, New stainless-steel appliances, Brushed nickel faucets & fixtures, recessed lighting, vaulted ceilings, new water resistant laminate flooring, fully updated Primary & Guest baths with new tubs & toilets, tub tile surround, new ceiling fans, 5-inch baseboards and so much more! If you need more conceiving: how about a New roof w/Techshield installed in 2020, new siding 2020 and new energy efficient windows 2020. Your going to want to make your appointment now! Call today!' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLMSLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'STONE CREEK' ,`TaxAmount` = '5554' ,`TaxRate` = '3.071' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087071' WHERE `Matrix_Unique_ID` = '215093724' --> Updated record success