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-25T20:36:45.800' ,`MLSNumber` = '82195001' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.614775' ,`Longitude` = '-95.260091' ,`PhotoCount` = '27' ,`PostalCode` = '77075' ,`RoomCount` = '6' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Bentondale' ,`StreetNumber` = '10315' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.114' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 CLEARWOOD CROSSING SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '4968' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = '' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clearwood Crossing Sec 2' ,`TaxAmount` = '5559' ,`TaxRate` = '3.1563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702987' WHERE `Matrix_Unique_ID` = '206515999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:30:03.940' ,`MLSNumber` = '90075414' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.951395' ,`Longitude` = '-95.496236' ,`PhotoCount` = '28' ,`PostalCode` = '77066' ,`RoomCount` = '7' ,`ListPrice` = '294900.00' ,`Status` = 'Active' ,`StreetName` = 'Natasha Run' ,`StreetNumber` = '5219' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2479' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.135' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 COPPER FALLS' ,`LotDesciption` = 'Other' ,`LotSize` = '5882' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MCDOUGLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copper Falls' ,`TaxAmount` = '5596' ,`TaxRate` = '2.9105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702987' WHERE `Matrix_Unique_ID` = '206791448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:43:49.030' ,`MLSNumber` = '31166263' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.529500' ,`Longitude` = '-95.467065' ,`PhotoCount` = '28' ,`PostalCode` = '77545' ,`RoomCount` = '7' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Hawthorne Glen' ,`StreetNumber` = '3939' ,`StreetSuffix` = 'Court' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.162' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ESTATES OF TEAL RUN SEC 5, BLOCK 1, LOT 22' ,`LotDesciption` = 'Other' ,`LotSize` = '7055' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '615' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'GOODMAN ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Teal Run Sec 5' ,`TaxAmount` = '4977' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702988' WHERE `Matrix_Unique_ID` = '206941972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:27:29.863' ,`MLSNumber` = '88696434' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.306724' ,`Longitude` = '-95.500760' ,`PhotoCount` = '17' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Falling Pine' ,`StreetNumber` = '308' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1263' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S799100 - PINEWOOD FOREST, BLOCK 1, LOT 120, ACRES 0.126' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '351' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinewood Forest' ,`TaxAmount` = '4774' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702988' WHERE `Matrix_Unique_ID` = '207117332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:13:09.643' ,`MLSNumber` = '44474655' ,`ListAgentFullName` = 'Steven Robinson' ,`ListOfficeName` = 'Hometown America Incorporated' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583641' ,`Longitude` = '-96.341741' ,`PhotoCount` = '39' ,`PostalCode` = '77434' ,`RoomCount` = '8' ,`ListPrice` = '263900.00' ,`Status` = 'Active' ,`StreetName` = 'McCarty' ,`StreetNumber` = '709' ,`StreetSuffix` = 'Avenue' ,`City` = 'Eagle Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow! All the work has been done for you! Beautifully renovated 3 bed, 2 bath family home on a HUGE LOT ideally located close to Eagle Lake, major highways, grocery stores and shopping opportunities in Eagle Lake, TX. This home has been fully renovated with inviting vinyl flooring and tile throughout, new paint, HVAC, stainless apps and roof--all done in 2022. Kitchen features on-trend tile flooring, tile backsplash, upgraded lighting, and luxe quartz countertops. In addition, the utility room is indoors and there is a bonus space which is perfect for a possible workshop or storage roof for outdoor or recreational gear. Large, fenced-fenced in backyard with room for kids and pets to roam. Low taxes!' ,`Acres` = '0.738' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PT LT 4 MCCREARY-MCCARTY EAGLE LAKE .739 AC & HOUSE' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '32147' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '161 - Rice Consolidated' ,`SchoolElementary` = 'EAGLE LAKE INTERMEDIATE SCHOOL' ,`SchoolHigh` = 'RICE HIGH SCHOOL (RICE CISD)' ,`SchoolMiddle` = 'RICE JUNIOR HIGH SCHOOL (RICE CISD)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mccreary-Mccarty' ,`TaxAmount` = '3008' ,`TaxRate` = '2.5343' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702988' WHERE `Matrix_Unique_ID` = '208773438' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T21:15:40.410' ,`MLSNumber` = '19936765' ,`ListAgentFullName` = 'Katherine Massey' ,`ListOfficeName` = 'NextHome Realty Solutions BCS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508946' ,`Longitude` = '-95.529165' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '13' ,`ListPrice` = '1598000.00' ,`Status` = 'Active' ,`StreetName` = 'Hope Farm' ,`StreetNumber` = '35' ,`StreetSuffix` = 'Road' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5755' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Westport custom home in award winning community of Sienna. Amazing lake and pool views.\r\nWow entrance with 2 story living and dining rooms. Must see in person to truly appreciate. Great home\r\nfor entertaining with very large kitchen, breakfast and family area. Lots of outdoor covered living space\r\nand large pool with tremendous deck surrounding entire space. Large Master with 2 sided fireplace to\r\nsitting area. Large His/Hers closets. Large master bath with vanity mirrors to the ceiling. 2 nd bedroom\r\ndown. 3 bedrooms up which have vaulted ceilings and large windows all with great views. Oversized 4\r\ncar garage and 3 walk in attic spaces provide all the storage you will need. 3 new 16 seer HVAC, 2 new\r\n50 gal water heaters, new hardwood floors, new stainless appliances, pool with lifetime warranty, and\r\nrecent metal fence eliminate any big costs. Extremely energy efficient design. No MUD taxes.' ,`Acres` = '1.3475' ,`Area` = '38' ,`BuilderName` = 'Westport' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA ACREAGE ESTATES PHASE 1, BLOCK 5, LOT 11, ACRES 1.347' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '58697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Acreage Estates Ph 1' ,`TaxAmount` = '22344' ,`TaxRate` = '2.1129' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702988' WHERE `Matrix_Unique_ID` = '208920291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:32:36.910' ,`MLSNumber` = '10913729' ,`ListAgentFullName` = 'Mari Montgomery' ,`ListOfficeName` = 'Mari Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.550374' ,`Longitude` = '-95.609979' ,`PhotoCount` = '50' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '282500.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Lakes' ,`StreetNumber` = '38' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BETTER THAN NEW HOME W/DIRECT SAM HOUSTON NAT\'L FOREST ACCESS! HUNTING SEASON JUST AROUND THE CORNER! Located high and dry on hill above beautiful Lake Conroe, this single story 4 BR/2BA/2 Car Garage home features top of the line custom window blinds that BOTH filter light or \"black\" out the light - up to you, gleaming granite counters and a bonus island with extra storage, \"smart\" thermostat, plug for an ELECTRIC CAR, etc in garage, kitchen open to living so you can \"kiss the cook\" and all watch college football, pristine LARGE back concrete patio for entertaining & enjoying the copious amount of wildlife as you are directly on the Forest. You won\'t believe your ears when you experience the lack of noise, replaced by PEACE and TRANQUILITY in this PRIME location in Wildwood Shores! WWS is a paradise on earth featuring GREAT FISHING, 2 pools, tennis court, basketball court, picnic areas, large covered pavilion, 2 boat launches, dry boat storage, day marina and more! COME SEE TODAY!' ,`Acres` = '0.1222' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WILDWOOD SHORES (SEC 10), BLOCK 2, LOT 38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5323' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Controlled Access,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wildwood Shores' ,`TaxAmount` = '3515' ,`TaxRate` = '1.8438' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702988' WHERE `Matrix_Unique_ID` = '211637676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:45:27.290' ,`MLSNumber` = '51991062' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.505078' ,`Longitude` = '-95.714639' ,`PhotoCount` = '7' ,`PostalCode` = '77469' ,`RoomCount` = '17' ,`ListPrice` = '667527.00' ,`Status` = 'Active' ,`StreetName` = 'Deep Lapis' ,`StreetNumber` = '1606' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston V, Elevation B) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with large walk-in closet. Spacious kitchen open to Family Room. Dining Room and Study. Game Room, 4 bedrooms, and 3 bathrooms upstairs. Covered patio and 3 car attached garage. This growing community is already a comfortable home to many who appreciate its state-of-the-art amenities and calming landscape. Outside Stone Creek Estates is the flourishing suburb of Rosenberg, Texas. Shopping is around the corner, there are multiple five-star restaurants, and most importantly is the access to the highly recognized Lamar Consolidated ISD. Stop by the Westin Homes model to learn more about Stone Creek Estates!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 20 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11420' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702988' WHERE `Matrix_Unique_ID` = '211690225' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:45:11.520' ,`MLSNumber` = '48568066' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.168281' ,`Longitude` = '-95.185885' ,`PhotoCount` = '28' ,`PostalCode` = '77357' ,`RoomCount` = '16' ,`ListPrice` = '519637.00' ,`Status` = 'Active' ,`StreetName` = 'Toscana' ,`StreetNumber` = '18904' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston, Elevation D) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Spacious island kitchen open to Family room. Formal Dining and Study. Game room and Media Room upstairs. Covered back patio and attached 2 car garage. Tavola, northeast Houston\'s newest master-planned community, features amenities such as a recreation center with a pool, park with a unique zip line and clubhouse, pocket parks and miles of wooded greenbelt trails that wind throughout the community. Tavola’s convenient location caters to major employment centers including the Greenspoint Business District and the new ExxonMobil campus. Located seven miles north of Kingwood and just two exits north of the new Grand Parkway, Tavola’s ideal location will easily link this community to any area of Houston. Stop by the Westin Homes home to learn more about Tavola!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 3, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8218' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.34' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702988' WHERE `Matrix_Unique_ID` = '211690681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:44:52.083' ,`MLSNumber` = '32900311' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.168195' ,`Longitude` = '-95.185870' ,`PhotoCount` = '28' ,`PostalCode` = '77357' ,`RoomCount` = '15' ,`ListPrice` = '524457.00' ,`Status` = 'Active' ,`StreetName` = 'Toscana' ,`StreetNumber` = '18928' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Lexington, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, informal dining room, and study. Spacious island kitchen open to Family room. Primary suite with large double walk-in closets. Second bedroom downstairs with private bath. Spacious game room and media room on second floor. Covered patio and 2-car garage. Tavola, northeast Houston\'s newest master-planned community, features amenities such as a recreation center with a pool, park with a unique zip line and clubhouse, pocket parks and miles of wooded greenbelt trails that wind throughout the community. Tavola’s convenient location caters to major employment centers including the Greenspoint Business District and the new ExxonMobil campus. Located seven miles north of Kingwood and just two exits north of the new Grand Parkway, Tavola’s ideal location will easily link this community to any area of Houston. Stop by the Westin Homes home to learn more about Tavola!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 26 BLK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7122' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.34' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702989' WHERE `Matrix_Unique_ID` = '211695661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:44:31.413' ,`MLSNumber` = '65410382' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841956' ,`Longitude` = '-95.861028' ,`PhotoCount` = '31' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '569637.00' ,`Status` = 'Active' ,`StreetName` = 'Bahia Bay' ,`StreetNumber` = '809' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Fairfax, Elevation AL). CURRENTLY BEING BUILT. Two story. 5 bedrooms. 3.5 baths. Spacious island kitchen open to family room and informal dining. Primary suite with large walk-in closet. Additional first floor bedroom with private bath. First floor study. 3 additional bedrooms, game room and media room on second floor. Covered patio and 2-car garage. Located a few miles north of Interstate 10 and west of the Grand Parkway in thriving Katy, Sunterra is an inviting 1,039-acre master-planned community featuring home designs that fit your lifestyle, Sunterra is a launch pad for family adventures. Splash, play, paddleboard, build sandcastles and more at our gorgeous Crystal Lagoons® amenity. Designed to fit your lifestyle, the master plan calls for approximately 2,200 homes, lakes, parks, playgrounds and an expansive Amenity Village with a clubhouse and a pool overlooking the lagoon. Stop by the Westin Homes sales model to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 114 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6783' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702989' WHERE `Matrix_Unique_ID` = '211697095' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:43:50.870' ,`MLSNumber` = '98795220' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960621' ,`Longitude` = '-95.201599' ,`PhotoCount` = '7' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '634854.00' ,`Status` = 'Active' ,`StreetName` = 'Gramina' ,`StreetNumber` = '11935' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter LVL, Elevation M) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, formal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Two additional bedrooms, spacious game room and media room on second floor. Covered rear patio and attached 2-car garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8142' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`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` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702989' WHERE `Matrix_Unique_ID` = '211701393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:45:44.920' ,`MLSNumber` = '8928605' ,`ListAgentFullName` = 'TaShana Talley' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.263605' ,`Longitude` = '-95.062500' ,`PhotoCount` = '40' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3373' ,`StreetNumber` = '291' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this opportunity. Five acres of unrestricted property beautifully manicured situated on a dead end rd. This home is immaculately kept, 4/2 with oversized bedrooms. and very large family room with open concept.Wrap around porch gives this home that southern charm feel.The large shop (over 2000 sq of concrete) compliments this home offering plenty of space for storage. Well is located in back room of shop for protection from the weather.' ,`Acres` = '5' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MACDONALD, LOT 70, TRACT 2, ACRES 5.0' ,`LotDesciption` = 'Other' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Macdonald' ,`TaxAmount` = '2878' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702989' WHERE `Matrix_Unique_ID` = '211720941' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T20:30:52.237' ,`MLSNumber` = '35186139' ,`ListAgentFullName` = 'Raquel Ginebra' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018993' ,`Longitude` = '-95.460036' ,`PhotoCount` = '39' ,`PostalCode` = '77090' ,`RoomCount` = '11' ,`ListPrice` = '369500.00' ,`Status` = 'Active' ,`StreetName` = 'Anvil' ,`StreetNumber` = '17406' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3358' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly updated home! Beautiful modern look with an open concept floor plan. New luxury laminate vinyl plank flooring, new cabinets, and new granite! Gorgeous on the exterior as well as inside. You will not want to miss this Houston gem!' ,`Acres` = '0.3782' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 10 PONDEROSA FOREST SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '16475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '749' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ponderosa Forest Sec 02' ,`TaxAmount` = '5542' ,`TaxRate` = '2.4101' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702989' WHERE `Matrix_Unique_ID` = '211737617' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T21:07:11.833' ,`MLSNumber` = '93005994' ,`ListAgentFullName` = 'Robert Pollard' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845264' ,`Longitude` = '-95.439574' ,`PhotoCount` = '28' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Don Alejandro' ,`StreetNumber` = '1711' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1746' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Close with access to 610, I-45 and 290! Popular area near Garden Oaks and Oak Forest businesses (Breweries, Shopping, Restaurants, Fitness facilities) and the property is ready to move in! GATED Community that has running path around the pond and is dog friendly!\r\nGreat floor plan w/ open concept first floor with large den and kitchen that opens to den. Kitchen has stainless appliances and granite countertops w/Breakfast bar. Flex room up can be office w/small niche or loft/game room. Large bedrooms. Primary is HUGE with large walk in closet. Fridge, washer and dryer stay.\r\n SOLAR PANELS that are owned with no loan or lease! In-line water heater and PEX plumbing with manifold! NO FLOODING' ,`Acres` = '0.0647' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 MARBELLA' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2817' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marbella' ,`TaxAmount` = '5332' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702989' WHERE `Matrix_Unique_ID` = '211834903' --> Updated record success